So there I was… attempting to figure out the best way to to a like clause in a query statement using the cfqueryparam tag.

I had it coded like this:

like <cfparam cfsqltype="cf_sql_varchar" value="#arguments.search_criteria#">

Well that didn’t work. So I did some googling. After a little bit of searching, I finally found out how it should be coded.

like <cfparam cfsqltype="cf_sql_varchar" value="%#arguments.search_criteria#%">

After laughing at how simple that was… I used it. Worked like a charm.

Been attempting to put a datetime variable into a MySQL Database via ColdFusion. For the life of me, I couldn’t figure out what I was doing wrong.

At first I tried:

#createODBCDateTime(now())#

For some reason that was only giving me the date and not the time.

Then I tried splitting up the date and time into two different fields, one for the date and the other for the time. Then I tried this code:

#createODBCDate(now())#

#createODBCTime(now())#

That gave me the date, but still not the time. Well I did some searching and then found there’s a built in function in MySQL to do this. Why not.

Talk about simple:

NOW()

Well guess what, it worked just like a charm.

Ah now we come to ColdFusion. Such a great language to be programming websites in. I figured since I created a Hello World sample app in other languages, why not here. Here’s the most basic output for ColdFusion:

<cfoutput>Hello World</cfoutput>

Of course we can make it a bit more fun… by using a variable to hold the “Hello World” in and then output that variable. In the next example, we’ll use greetings as the variable.

<cfset greetings="Hello World">
<cfoutput>#greetings#</cfoutput>

So yep that’s that, simple enough.