What is the error you are getting?
----- Original Message -----
From: "Bosky, Dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 3:10 PM
Subject: Dynamic query woes
> I needed to write this page in asp instead of cf and can't seem to locate
> the error in this query.
> I figured a few additional eyes would help!
>
>
> Dim StartDate, EndDate
> StartDate =
> DateSerial(Request("s_year"),Request("s_month"),Request("s_day"))
> EndDate =
DateSerial(Request("e_year"),Request("e_month"),Request("e_day"))
>
> qSearch =
> "SELECT TypeOfEvent,EventText,ModifiedDateTime,ModifiedBy,ActionPerformed
> "&_
> "FROM tbl_auditlog "&_
> "WHERE 0=0 "&_
>
> If Request("TypeOfSearch") <> "All" then
> "AND TypeOfEvent = '"&Request("TypeOfSearch")&"' " &_
> End If
>
> If Request("SearchByDateRange") = "yes" then
> "AND ModifiedDateTime BETWEEN '" & StartDate & "' AND '" & EndDate & "' "
&_
> End If
> "ORDER BY TypeOfEvent, ModifiedDateTime"
> ------------------
>
> Thanks,
> Dave
>
>
>
>
>
______________________________________________________________________
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
