Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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 »