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
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
