try something like...
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
qSearch = qSearch & "AND TypeOfEvent = '"&Request("TypeOfSearch")&"' "
End If
If Request("SearchByDateRange") = "yes" then
qSearch = qSearch & "AND ModifiedDateTime BETWEEN '" & StartDate & "'
AND '" & EndDate & "' "
End If
qSearch = qSearch & "ORDER BY TypeOfEvent, ModifiedDateTime"
hth
Bosky, Dave wrote:
> 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
