ASP to SQL DB, all events within last 24 hours?

[ziggs]

Okay, I'm missing something here.

#1 - Did I set up the "datstring" correctly to define exact time 24 hours ago within a SQL Server 2000 database?

#2 - If so, should I use it in the WHERE clause differently?

datestring = DateAdd("h", -24, now())

SQL = SQL & " Where CallReceivedTime > '" & datestring & "'")

Here's the error message I'm getting -

Expected end of statement
/24hrcapture.asp, line 24, column 64
SQL = SQL & " Where CallReceivedTime > '" & datestr & "'")
---------------------------------------------------------------^

 

[ziggs]

Nevermind, I had a ) in the wrong place and finally figured it out.

 

[Chopstik]

Two things, though one may simply be a typo. First, you wrote in your original code:

SQL = SQL & " Where CallReceivedTime > '" & [COLOR=red]datestring[/color] & "'")

with this in the error code you see:

SQL = SQL & " Where CallReceivedTime > '" & [COLOR=red]datestr[/color] & "'")

If this is not a typo, then you need to change it to reflect the correct variable. One way to prevent this, incidentally, is to use Option Explicit (if you're not already using it).

The other thing I see is that you have a closing parenthesis at the end of your statement - but no opening parenthesis. And should this be inside your statement or just an error. I would check these two things first and then go from there.

------------------------------------------------------------------------------------------------------------------------
"I am not young enough to know everything."
Oscar Wilde (1854-1900)