indradhi

SQL Server Procedure to Export Query result to Excel

I recently created these SQL Server 64 bit Procedure to help export query result to existing excel enjoy USE [devdb] GO /****** Object: StoredProcedure [dbo].[exportquery2excel] Script Date: 11/14/2014 4:01:12 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — ============================================= — Author: Indradhi Nugraha Mulyanto — Create date: 15/11/2014 16:02 — Description: Export QueryContinue reading “SQL Server Procedure to Export Query result to Excel”

How to Read CSV file in SQL Server 64 bit

This is example how to read CSV file using SQL Server 64 bit : SELECT * FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0’, ‘Text;Database=E:\SUPM\Reports\2014\Weekly\39\Source\Data OSS\;HDR=YES’, ‘SELECT * FROM 20140929_DataOSS_2G_clean1.csv’) Enjoy

Enabled your MySql server managed remotely in linux ubuntu

Open /etc/mysql/my.cnf Comment this line

Enabled mod_rewrite linux ubuntu

PHP Module Installed but wont running

Recently i’m facing a problem that PHP module i need and installed won’t run. I’m using ubuntu 13.10 and lamp package. I noticed that in phpinfo() : Additional .ini files parsed, not loading the ini files for the module i have installed. Scan this dir for additional .ini files, point to ‘/etc/php5/apache2/conf.d’. After several hour iContinue reading “PHP Module Installed but wont running”

Solved Login Loop Ubuntu 13.04

My Ubuntu 13.04 suddenly got login loop of disaster… I cannot login to my account but i can login to guest account i solved it (after 2 hours) by : pressing Ctrl + Alt + F3 and logged into shell type mv .Xauthority Xauthority.bak sudo apt-get install –reinstall xorg sudo reboot i can logged toContinue reading “Solved Login Loop Ubuntu 13.04”

Resolved ‘uuid’ is not allowed in element when open jrxml in iReport

Sometimes when using iReport in windows, the jrxml cannot be opened because of ‘uuid’ is not allowed in element. The most simple things you can do is to open the jrxml in text editor that support regular expression replacement, find this regex uuid=”[^”]*” or uuid=”\w*-\w*-\w*-\w*-\w*” then replace it with blank string. That’s it now tryContinue reading “Resolved ‘uuid’ is not allowed in element when open jrxml in iReport”

Display Array of Data with Paging

I found this artifac in my codeigniter helper hehe.. I used it to display array of data per page with these parameter : 1. $data = array of data 2. $currentpage = page you want to display 3. $rowperpage = number of data to display per page 4. $rowcount = number of data in $dataContinue reading “Display Array of Data with Paging”