You mean other than the word "WHERE"?  ;o)

-----Original Message-----
From: M. H. K. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 2:22 PM
To: ActiveServerPages
Subject: Date filtering on SQL


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.unsub%%

---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to