ASP SQL query error with data types

[David McManus]

I am trying to use a query to filter SQL Server 2000 records by a date
value.
Here is relevant columns in my database table (tblContent):

title [nvarchar]
starting [smalldatetime]

.... and here is my query:

Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"

I've done exactly this query on numberous occassions in the past with no
problems at all but this time I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data
type to smalldatetime data type resulted in an out-of-range smalldatetime
value.

What on earth is going on? I'm not using a char data type anywhere! I am
doing all the initial development locally and I have just installed XP
Service Pack 2. I realise it's unlikely, but that's the only thing I can
possibly attribute it to. Or am I just missing something obvious?

Anyone able to help, please?
Thanks.

 

[Meelis Lilbok]

Hi

Use this date format and no problems

yyyymmdd

Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"

where date='yyyymmdd'


Mex

 

[David McManus]

Confused....

Could you tell me precisely where in my query you mean, please?

D

Hi

Use this date format and no problems

yyyymmdd

Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"

where date='yyyymmdd'


Mex

I am trying to use a query to filter SQL Server 2000 records by a date
value.
Here is relevant columns in my database table (tblContent):

title [nvarchar]
starting [smalldatetime]

... and here is my query:

Query = "SELECT title FROM tblContent WHERE starting = '" & date & "'"

I've done exactly this query on numberous occassions in the past with no
problems at all but this time I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char
data type to smalldatetime data type resulted in an out-of-range
smalldatetime value.

What on earth is going on? I'm not using a char data type anywhere! I am
doing all the initial development locally and I have just installed XP
Service Pack 2. I realise it's unlikely, but that's the only thing I can
possibly attribute it to. Or am I just missing something obvious?

Anyone able to help, please?
Thanks.

 

[Bob Barrows [MVP]]

http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion

Bob Barrows

Confused....

Could you tell me precisely where in my query you mean, please?

D

Hi

Use this date format and no problems

yyyymmdd

Query = "SELECT title FROM tblContent WHERE starting = '" & date &
"'"

where date='yyyymmdd'


Mex

I am trying to use a query to filter SQL Server 2000 records by a
date value.
Here is relevant columns in my database table (tblContent):

title [nvarchar]
starting [smalldatetime]

... and here is my query:

Query = "SELECT title FROM tblContent WHERE starting = '" & date &
"'"

I've done exactly this query on numberous occassions in the past
with no problems at all but this time I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of
char data type to smalldatetime data type resulted in an
out-of-range smalldatetime value.

What on earth is going on? I'm not using a char data type anywhere!
I am doing all the initial development locally and I have just
installed XP Service Pack 2. I realise it's unlikely, but that's
the only thing I can possibly attribute it to. Or am I just missing
something obvious?

Anyone able to help, please?
Thanks.