Hi All.
I'm an ASP newb. I'm using Frontpage 2002 at the moment to connect to a SQL 2000 database. I'm able to execute the following command in SQL:
Select *
From calldata
Where (Extension= '129' AND Date >= DateAdd(Day, DateDiff(Day, 0, '6/18/2007'), -0)
and Date < DateAdd(Day,DateDiff(Day,0,'6/18/2007'),1))
The "Date" field is a DateTime datatype.
This command in SQL runs fine.
However, when I bring this over to FrontPage, and put in form field values, it's pukes:
Database Results Error
Unable to find operator in query string. Query string currently is SELECT * From merlin Where (Extension= ? AND Date >= DateAdd(Day, DateDiff(Day, 0, '::CallDate::'), -0) and Date < DateAdd(Day,DateDiff(Day,0,'::CallDate::'),1))
Notice it looks as if it's trying to pass the extension field (because it shows a ?), but it doesn't want to pass along the CallDate field.
I'm running out of places to bang my head around here. Can someone shed a little bit of light this way?
Thanks very much in advance.
I'm an ASP newb. I'm using Frontpage 2002 at the moment to connect to a SQL 2000 database. I'm able to execute the following command in SQL:
Select *
From calldata
Where (Extension= '129' AND Date >= DateAdd(Day, DateDiff(Day, 0, '6/18/2007'), -0)
and Date < DateAdd(Day,DateDiff(Day,0,'6/18/2007'),1))
The "Date" field is a DateTime datatype.
This command in SQL runs fine.
However, when I bring this over to FrontPage, and put in form field values, it's pukes:
Database Results Error
Unable to find operator in query string. Query string currently is SELECT * From merlin Where (Extension= ? AND Date >= DateAdd(Day, DateDiff(Day, 0, '::CallDate::'), -0) and Date < DateAdd(Day,DateDiff(Day,0,'::CallDate::'),1))
Notice it looks as if it's trying to pass the extension field (because it shows a ?), but it doesn't want to pass along the CallDate field.
I'm running out of places to bang my head around here. Can someone shed a little bit of light this way?
Thanks very much in advance.