# sign alert! ..you don't need those in <cfif>'s to reference a variable.
<cfif form.reqNo neq 0> works. -Craig >>-----Original Message----- >>From: Venable, John [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, July 30, 2002 2:41 PM >>To: CF-Talk >>Subject: RE: SQL Help >> >> >>I don't think you need commas at all, the AND is the logical breakup of >>statements. >> >>John >> >>-----Original Message----- >>From: James Blaha [mailto:[EMAIL PROTECTED]] >>Sent: Tuesday, July 30, 2002 2:29 PM >>To: CF-Talk >>Subject: SQL Help >> >> >>Can any one help me out here? I'm having a problem getting this query to >>work with putting in the proper commas when necessary in myWHERE clause >>for the SQL statement. >> >>James Blaha >> >><CFQUERY name="JobApplicants" datasource="ABC"> >>SELECT * >> >>FROM HRWebAgent.tApply >> >>WHERE ReqNO > 0 >> >> <CFIF #form.ReqNo# NEQ "0"> >> AND (ReqNo='#ReqNo#'), >> </CFIF> >> >> <CFIF #form.FIRSTNAME# NEQ "0"> >> AND (FIRSTNAME LIKE '#FIRSTNAME#%'), >> </CFIF> >> >> <CFIF #form.LASTNAME# NEQ "0"> >> AND (LASTNAME LIKE '#LASTNAME#%'), >> </CFIF> >> >> <CFIF #form.APPLIED_DATE# NEQ "0"> >> <!--- Dates go in order of old:recent i.e. BETWEEN >>'11/4/2000' AND '6/18/2001' ---> >> AND (APPLIED_DATE BETWEEN '#back_date_listed2#' AND >>'#now_date2#'), >> </CFIF> >> >> >> <CFIF #form.Desired_Position# NEQ "0"> >> <!--- Desired_Position IN ('Briarcliff','New >>York') ---> >> AND (Desired_Position IN >>(#ListQualify(Form.Desired_Position,"'")#)), >> </CFIF> >> >> >> >></CFQUERY> >> >> >> ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
