You gonna post the cf code as well, or should we just make a guess as to what you've done in cold fusion?
:) -----Original Message----- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 12:10 PM To: CF-Talk 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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
