> > q_createRecordSet.INFLOW NEQ "" > > dunno about the rest, but this should be NOT > q_createRecordSet.INFLOW IS ""
The two are identical, and the usual operator syntax would be "IS NOT", rather than "NOT ... IS". These statements would all perform the same test: <cfif a NEQ b> <cfif a IS NOT b> <cfif NOT a IS b> In a similar vein, you might want to use string functions to build your conditions instead; you might get infinitesimally better performance using Len, for example: <cfif not Len(Trim(q_createRecordSet.INFLOW))> Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
