I tend to agree that NEQ if fine. Just my two cents. J.
-----Original Message----- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 1:58 PM To: CF-Talk Subject: Why Is and not NEQ [Was: LT Function] oi Bruce!! >>dunno about the rest, but this should be NOT q_createRecordSet.INFLOW IS "" why should it be like that? I was under the impression the "IS" has been deprecated, and that it is similar to a "like" and thus has a longer processing time as opposed to EQ and NEQ (and yes I do realise that it is only milliseconds.......) -- Critter, MMCP Certified ColdFusion Developer Crit[s2k] - <CF_ChannelOP Network="Efnet" Channel="ColdFusion"> ------------------------------------- Tuesday, October 30, 2001, 1:38:31 PM, you wrote: DB> q_createRecordSet.INFLOW NEQ "" DB> dunno about the rest, but this should be NOT q_createRecordSet.INFLOW IS "" DB> -----Original Message----- DB> From: Dave Watts [mailto:[EMAIL PROTECTED]] DB> Sent: Tuesday, October 30, 2001 12:36 PM DB> To: CF-Talk DB> Subject: RE: LT Function >> The values I am checking are int Datatypes, >> >> this is exactly what I'm doing >> >> <CFIF checkDay EQ day(q_createRecordSet.dt)> >> <CFIF q_createRecordSet.INFLOW NEQ ""> >> >> <CFSET mnInf=rtrim(q_createRecordSet.INFLOW)> >> <CFSET mnInfDt=q_createRecordSet.dt> >> <CFIF rtrim(q_createRecordSet.INFLOW) LT mnInf> >> <CFSET mnInf=q_createRecordSet.INFLOW> >> <CFSET mnInfDt=q_createRecordSet.dt> >> </CFIF> >> </CFIF> >> </CFIF> DB> Are you sure that rtrim(q_createRecordSet.INFLOW) is numeric? You might want DB> to wrap it in Val() and see what happens. DB> Dave Watts, CTO, Fig Leaf Software DB> http://www.figleaf.com/ DB> voice: (202) 797-5496 DB> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
