Can you honestly say that a "date" is in that sql statement? I see a
mathematical expression: 08 / 23 / 2002 which is roughly equal to 1.737 x
10^-4
Dates are delimited by ' in sql server. Use ISO format. Consider [Tore's
explanation when he posts it because he loves this topic :-) and]
CAST('20020823' as DATETIME)
David L. Penton, Microsoft MVP
JCPenney Application Specialist / Lead
"Mathematics is music for the mind, and Music is Mathematics for the
Soul. - J.S. Bach"
[EMAIL PROTECTED]
Do you have the VBScript Docs or SQL BOL installed? If not, why not?
VBScript Docs: http://www.davidpenton.com/vbscript
SQL BOL: http://www.davidpenton.com/sqlbol
-----Original Message-----
From: M. H. K. [mailto:[EMAIL PROTECTED]]
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near '>'.
sSQL="Select * from Subscribe Date > 08/23/2002"
I'd appreciate it if someone could point out what the problem is here ?
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
