<CFQUERY name="JobApplicants" datasource="ABC">
SELECT *
FROM HRWebAgent.tApply
WHERE ReqNO > 0
AND 0=0
<CFIF #form.ReqNo# NEQ "0">
, AND (ReqNo='#ReqNo#')
</CFIF>
<CFIF #form.FIRSTNAME# NEQ "0">
, AND (FIRSTNAME LIKE '#FIRSTNAME#%')
</CFIF>
On Tue, 30 Jul 2002, James Blaha wrote:
> 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>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
