This is the ASP code I haven't wrote it in CF. Dave
-----Original Message----- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 3:25 PM To: CF-Talk Subject: RE: Dynamic query woes 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 ______________________________________________________________________ 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
