dave,
i would re-write that section of ASP code to correct both the sql
string and the startdate, enddate format as follows:
<%
Dim StartDate, EndDate
StartDate = Request("s_month") & "/" & Request("s_day") & "/" &
Request("s_year")
EndDate = Request("e_month") & "/" & Request("e_day") & "/" &
Request("e_year")
qSearch = "SELECT
TypeOfEvent,EventText,ModifiedDateTime,ModifiedBy,ActionPerformed
"
qSearch = qsearch & " FROM tbl_auditlog "
qSearch = qsearch & " WHERE 0=0"
If Request("TypeOfSearch") <> "All" then
qSearch = qSearch & " AND TypeOfEvent = " &
Request("TypeOfSearch")
End If
If Request("SearchByDateRange") = "yes" then
qSearch = qSearch & " AND ModifiedDateTime BETWEEN " & "'" &
StartDate & "'"
qSearch = qSearch & " AND " & "'" & EndDate & "'"
End If
qSearch = qSearch & " ORDER BY TypeOfEvent, ModifiedDateTime"
%>
~ dina
______________________________________________________________________
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
