Can anyone tell me what I'm doing wrong

[caballeros]

I have an access database that keeps track of tickets closed. What I'm trying to do is setup a query that will give me the results on a 5 day period, I have been able to create the query in access but when I try to add the query on my asp page I get the following error:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/remote/nov1601.asp, line 11

set rs = &quot;SELECT resolution.TicketNumber, resolution.Location, resolution.Technician, resolution.Failed, resolution.Refused, resolution.MethodClosed, resolution.TicketClosed FROM resolution WHERE resolution.TicketClosed > '#11/11/2001#' And resolution.TicketClosed < '#11/17/2001#';&quot;,conn, 2, 2
-------------------------------------------------^
Thanks in advance.

 

[link9]

Try axing that semicolon. They aren't needed when passing the query in ASP.

 

[vasah20]

in access, you don't need the ' marks around the date. just the # marks will do. that might clear it up for you. leo

------------
Leo Mendoza
lmendoza@students.depaul.edu

 

[Jonax]

... and I guess you could use BETWEEN in your WHERE-clause...? This is not a bug - it's an undocumented feature...
;-)