Skip to main content

Jorrit Janszen

Member since Dec 11, 2008

Recent Blog Comments By Jorrit Janszen

  • Ask Ben: Protecting Database Table Names In ColdFusion CFQuery

    Posted on Jul 27, 2007 at 10:48 AM

    This maybe a bit of dirty code: (but it cannot be any dirtier than allready described by the requestor) Why not make a list of "safe" to edit tables and check with listFindNoCase(application.safeToEditTableList,form.tablename) or do a cfswitch with the tableaname?... read more »

  • Always Define Your ColdFusion Query Column Types

    Posted on May 29, 2007 at 8:01 AM

    Another awfull thing is queries of queries. ColdFusion seems to guess the column types in stead of adapting them from the query object. For example: If you have a resultset from let's say 200 records with a numeric column where the first 100 records are NULL and you do a WHERE statement: WHERE nume... read more »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
— Ben Nadel