Sunfinedata - sunfinedata.com - Sunfine Data
General Information:
Latest News:
Use MySQL data table in SpotFire 4 Jul 2013 | 12:27 am
1 Download and install MySQL Connector / ODBC 5.1 Download MySQL Connector/ODBC 5.1 at downloads.mysql.com site. Install the package once it is downloaded. 2 Configure MySQL data source Type “odbc” in...
Build dynamic VIEW with a stored procedure 3 Jul 2013 | 11:27 pm
From http://forums.mysql.com/read.php?100,52123,52123 Using stored procedure can build dynamic view in MySQL. Then call the view to get all data as needed. CREATE PROCEDURE createview( in_param1 in...
Create view with parameter in MySQL 3 Jul 2013 | 11:11 pm
From http://stackoverflow.com/questions/2281890/can-i-create-view-with-parameter-in-mysql Actually if you create func: create function p1() returns INTEGER DETERMINISTIC NO SQL return @p1; and view: c...
Use FTP command line client to copy folders 15 Jun 2013 | 10:53 pm
ncftp NcFTP Client (also known as just NcFTP) is a set of FREE application programs implementing the File Transfer Protocol (FTP).The current version is: 3.2.5 (January 17, 2011). The program has been...
MySQL transpose data from column to row and vice versa 31 May 2013 | 01:41 am
I was looking for how to transpose MySQL table from column to row or from row to column and came across the following two posts online. They taught me how to achieve the job nicely. 1. Pivot table bas...
One useful PHP site 9 Feb 2013 | 08:22 am
I was searching “RSS PHP generator” and found the following website. It provides a lot of useful PHP classes and examples. The RSS feed generator it provides is a great tool to have. I modify the exam...
How I Get My Pages Indexed In 24 Hours 8 Feb 2013 | 09:47 am
The following was from the internet. Everyday there is thirty threads asking how to get your website indexed faster. Refer to this thread next time you want to ask! This is how I get my pages indexed ...
How to mount a samba shared folder (Ubuntu x Ubuntu) 28 Jan 2013 | 09:43 am
Question I have a server for development (Ubuntu 12.04). On that machine, I have a shared folder named “projects”. I tried sudo mount -t smbfs smb://192.168.2.28/projects/myProject /mnt/myProject on m...
Automating PowerPoint With Python 6 Jun 2012 | 04:47 am
This is a post at http://www.s-anand.net/blog/automating-powerpoint-with-python/. I preserve it here for my personal use. Writing a program to draw or change slides is sometimes easier than doing it ...
Handling audio and video files freely 16 Apr 2012 | 08:30 am
From time to time, we need manipulate audio and video files. When we rip audio CD to audio files, we can rip the audio tracks to wma (Windows Media Player format) or mp3. Since Apple gadgets do not ac...
