Take out the commas and all will be good.
HTH
Clint Tredway
--------- Original Message ----------------------------------
from: James Blaha <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Tue, 30 Jul 2002 14:28:52 -0400
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>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
