Against All Odds

Dhamma Cycle is on Google play

Thu, 10 May 2012 10:11:00 -0700

Last Tuesday, I've launched Dhamma Cycle on Google Play. It's for those buddhism who want to keep in touch with Buddha's dhamma and want to listen while reciting. It's my so-called 4th android application. Please help me to use my application. Download

LINK

Parsing List Value in Oracle

Tue, 24 Apr 2012 12:32:00 -0700

Being Coldfusion programmer, parsing list value in coldfusion is very simple. If list value is "list1|list2|list3|list4", we can parse with ListToArray in Coldfusion as follow.

Above coding, we must need to assign true for includeEmptyFields if list value will contain empty. In Oracle, it's touch to parse and we need to write Oracle function. [More]

Concatenate numeric and string data field in mssql

Fri, 13 Apr 2012 11:25:00 -0700

Today I've found how to concatenate numeric and string format in mssql. As we all know, concatenate two strings in mssql is very simple and well-known formula as follow


SELECT First_Name + ', ' + Last_Name FROM myTable

[More]

Simple way to check wifi network

Tue, 10 Apr 2012 01:05:00 -0700

Today I know how to check wifi network is ON and OFF for andriod. Normally, there is so many checking for wifi network but what I'm gonna show is very simple way to check. First of all, we need to define that we want to use WIFI network in andriod manifest as follow:

Then, we need to add following function whether WIFI network is open or not in device. [More]

Wrap Oracle script

Sun, 25 Mar 2012 21:44:00 -0700

Today, I know how to wrap Oracle objects called stored procedure, functions, views and so on. It's because I want to make secure for our project source. How-to-do is very simple. 1) Open common prompt 2) and go to Bin folder under Oracle just like "C:\Oracle\Bin" 3) Then type following script


C:\Oracle\Bin\wrap iname=/SP/mysp.sql oname=/SP/wrap_mysp.sql

[More]

Replace function in SQL

Tue, 06 Mar 2012 00:43:00 -0700

Today I've found how Replace function is useful in SQL. Because I need to update all columns of every table in our database. Using Replace is very simple.


UPDATE  SET
columnText = REPLACE (columnText, 'StringToFind', 'StringToReplace')


Above query is correct for nvarchar field but when I'm trying to replace for ntext and text field, it's getting error that "replace isn't ok for text field". That's why I'm goggling and found nice example as follow.


UPDATE 
 SET columnText =
REPLACE(SUBSTRING(columnText, 1, DATALENGTH(columnText)), 'StringToFind','StringToReplace') 

Share tables of schema in same SID
Mon, 27 Feb 2012 04:05:00 -0700
Today, I need to sync data of different schema in same SID (same database). Honestly, I'm not very good at Oracle but I gotta develop this kind of project. That's why I've asked in StackOverFlow and @Luck Woodwords and he replied good solution.

http://stackoverflow.com/questions/9452488/how-to-create-oracle-dblink-in-same-sid#comment11957843_9452488
				 [More]

Get Javascript value from Coldfusion in same page
Fri, 10 Feb 2012 10:05:00 -0700
Today, I've found funny resolution to get javascript value from Coldfusion in same page without reloading. I'm not sure whether it might be useful or not, but for me it's kinda useful.

Usage



	


#JSvalue#


get Table height with javascript
Thu, 19 Jan 2012 21:29:00 -0700
Normally, it's hard to get table height with javascript because javascript cannot read or retrieve table as follow







	
		Height
	




				 [More]



Backup Oracle database with bat file
Thu, 12 Jan 2012 08:57:00 -0700
Today, I've found how to backup/export Oracle database with bat file. I've just created it for only one schema first. Why I'm using to import Oracle with bat file because of there is no auto backup feature in Oracle (as far as I know). That's why  it's needed to create bat file and integrate with window task scheduler (run daily).

First of all, open Notepad and save as OracleBackup.bat first. Then, paste following  code into this file.


@echo off
echo Importing Oracle Start
echo =======================
exp system/password file=C:/ppshein.dmp grants=y owner='ppshein';
echo ==========================
echo Importing Oracle End

				 [More]


Coldfusion documentation application is in Android market
Fri, 06 Jan 2012 09:34:00 -0700
Today, I'm glad to inform to all that my Coldfusion documentation application is in Android market now. I'm planning to add more cool features in it just like tablet version and so on.

Coldfusion Documentation


Android Coldfusion documentation application
Sun, 01 Jan 2012 09:37:00 -0700
Today, I've finalised Android Coldfusion documentation application for Coldfusion developer. This one is my third android application for my Android developer life and enhance more features which not included in my later applications.

In this Coldfusion documentation application, you can search functions and tags of Coldfusion and view all lists of functions and tags either. Likewise, functions and tags which you search are not in this documentation, you can search similar functions and tags of CF.
				 [More]


CFIDE with multiple instance
Sat, 24 Dec 2011 02:13:00 -0700
Today I got the problem that I cannot use following sentence in one of my instance.


 


And hit JS error and don't know why. That's why I just go viewsource and found that CFIDE is missing for one of my CF instances. I cannot convince why Adobe cannot include CFIDE for multiple instances installation. That's why I know there is two ways to solve this bug of Coldfusion multiple instance installation.
				 [More]


Review for the uCertify(Zend-PHP5 simulator)
Thu, 15 Dec 2011 08:15:00 -0700


	Well, the first ever simulator I’ve got present.Overall it has main functions  or menu

	 

	
		Tests
	
		Quiz
	
		Notes
	
		Reports

				 [More]


Get free exam simulator from uCertify
Tue, 29 Nov 2011 23:15:00 -0700

	 

	uCertify, leading IT certification provider company is willing to spring for a license, that's a full license, for any of their test prep kits for one of my blog readers. The only requirement to get the full license is that you write a review of the software, within 30 days, that will be a guest post here on this blog.

	 

	So, I am offering this to all of my blog readers. Today is Nov 30, 2011. To get a chance to win the prep kit license, go to the ucertify site and take a look at the available tests. Decide which you would like to take.

	 

	Once you've made your choice, come back here and post a comment about which you would like and why you want to take it. Doesn't have to be anything big; just a couple of sentences is fine.

	 

	Make sure you either leave a real email address or you are signed in when you leave the comment. You don't need to leave your email address in the text of your comment if you are signed in. I can send you a message via the it toolbox messaging system in that case.

	 

	I will randomly choose the winner from the comments on Dec 10, 2011. So, you have about 10 days to post a comment.

	 

	Once I have notified the winner and they agree to review the software in a guest post here on this blog, I will give the info to Ucertify and they'll hand out the license.

	 

	The guest post doesn't need to be huge. At least a few hundred words which is just a page or two of double spaced text. As an example, this  blog post is over 400 words. I'll be glad to proofread and edit it if you would like me to mail me (pyaephyoeshein[at]gmail[dot]com).