FanaticZine

Today I was trying this ColdFusion Code, which derived me crazy for about hour, finally I found the solution for the problem. I’ll post this code, so if anybody go through the same, to make it little easy on them. ok here I go..

in my script I used a SQL query looks something like this,

<cfset strSQL=“SELECT * FROM TestTable WHERE test_id=‘xx’”>

<cfquery datasource=“xxxxxx” name=“xxxxxxx” result=“xxxxx” >
#strSQL#
</cfquery>

If you try something like that, it should should pop you a SQL error, if you look the query closely, you would notice that the CFQUERY executes the following command, which we passed in to it.

SELECT * FROM TestTable WHERE test_id=“xx”

you should see that there is a differance between command which get executed and with the one passed in. Means it converts ” ‘ ” character in to ” “ ” this would pop a sql error,

The Reason for this is, CF has it’s automated character escape feature, if you send the above code, CF DOES NOT ESCAPE those characters, But CF Escape any character which are queted with single-quotes,

so the simple solution for the problem is to tell the CF to escape the special characters which are in the command, so this is how we doing to do it.

<cfset strSQL=“SELECT * FROM TestTable WHERE test_id=‘xx’”>

<cfquery datasource=“xxxxxx” name=“xxxxxxx” result=“xxxxx” >
# ‘#strSQL#’ #
</cfquery>

Problem solved, your query should work now..

Taare Zameen Par Movie

Honestly I never had a idea about this movie, when I took the DVD to my hand, I just had a idea that this going to be a just another candy movie, but to be honest I felt so guilty about feeling that way, coz this is a wonderful movie, I love this movie, and hats off for the Producer/Director Aamir Khan, that his investment became a creation that touches people’s heart about a forgotten subject on the society, as members of that society where people are trained and put into the race track of life, we forget everything in the middle and we just care about the winning that race, and when we are done, we push our children into the same race track forcing them to win.

how unfair, if you haven’t watch it..? watch it today.. that’s all I can comment, coz I do not want to go through the story,

A Child Labour

But one thing I should mention, if we don’t stop running this race for our children, the children we love so much, are going to hate us as they realize that their parents stole their childhood forever.

and there are so many innocents, waiting, praying and hoping that the help would reach them someday and they would be free.

problem is who.? WHO IS GOING TO RESCUE THEM..?

Exclusive Collection From dillysfashions.com

If you guys who are reading this are in to fashion, I hope you guys have heard about dillys fashions, they are one of the most popular exclusive fashioner designers in the town. well I was very facinated about their billboards sometime back. Why I am writing about them today is suddenly I bumped into their website today and It just made me to tap some words about them. I think site looks cool. Without writing much about it i’ll just post some pictures to fire-up your curiosity and leave the website link to enjoy their cool collection by your self.. last line try their “Catch a Dream” collection i think it’s really nice..

Site : http://www.dillysfashions.com/