<cfif criteria neq "">AND field1 <> field2,</cfif> and then you ternimate by anything true to complete the coma delimited list... like AND 1 <> 0 > -----Message d'origine----- > De: Roger Lim [SMTP:[EMAIL PROTECTED]] > Date: Tuesday, September 12, 2000 2:17 AM > �: [EMAIL PROTECTED] > Objet: I have a problem.. > > Hi there, > > I've a problem which I'm trying hard to solve, hope you guys can help me > out > on this.. > > I have two huge tables with alot of fields. One of the table is driven by > a > form which will be filled by user and not all the fields are compulsory. > > I am required to compare these two tables and to match the correct data > out. > > However I can't perform a <CFQUERY> with lots 'AND' criteria because some > of > the fields are NULL. I only need to match those fields that the user > enter. > > How do I go about doing it? > > Hope that my message is clear. > > Thanks, > Roger > > -------------------------------------------------------------------------- > ---- > Archives: http://www.mail-archive.com/[email protected]/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
