Let’s face it, life isn’t worth living most days. What can you do about it? I’m afraid you can’t do much. It will cause you to try and escape from reality and then where will you be? Crushed without a place to go. Yeah, that’s the kind of consequences I’m talking about most of the time. So, why bother with it all? I’m not sure why I do most days. Wouldn’t it be easier to off myself? I mean who hasn’t thought about killing themselves from time to time? I know I have. It would be nice not to have these thoughts and feelings about my life. But I do have them and they won’t go away. So I must deal with them. There’s nothing wrong with that, I guess? Maybe there is. I don’t know for sure. So just allow it to be whatever it wants to be. If life wants me dead, who am I to argue with it? There’s so many things in this life that don’t matter. So many things in this life that do matter. I need to find a balance in between the two things and make it work out for me.
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.
Comments
Post a Comment