disregard this. I know ...the commas.
On Tue, 30 Jul 2002, Alex wrote:
> <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>
> >
> >
>
______________________________________________________________________
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
