on 9/26/02 12:21 PM, M. H. K. at [EMAIL PROTECTED] wrote:

> 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 ?

how about sSQL = "SELECT * FROM Subscribe WHERE [Date] > 8/23/2002"
                                          ^^^^^ ^    ^


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

Reply via email to