You can see the error by checking in <windows system dir>\LogFiles\W3SVC1(or
similar)\inXXXXXX.log
but I think you may be getting error trying to concatenate your string
across if then blocks, try it without the &_
i.e.
sSql = "<select clause>"
if <condition>
sSql = sSql & "<condition>"
end if
etc.
----- Original Message -----
From: "Bosky, Dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 3:31 PM
Subject: RE: Dynamic query woes
> Nothing the page won't display at all it gives the following error msg:
> HTTP 500 - Internal server error
> Internet Explorer
>
> If I take this section of code out the page it works fine.
>
> Dave
>
>
> -----Original Message-----
> From: Robert Gatton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 27, 2002 3:25 PM
> To: CF-Talk
> Subject: Re: Dynamic query woes
>
> What is the error you are getting?
>
> ----- Original Message -----
> From: "Bosky, Dave" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, May 27, 2002 3:10 PM
> 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
> >
> >
> >
> >
> >
>
>
______________________________________________________________________
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
