sSQL="Select * from Subscribe Date > 08/23/2002" Isn't Date a reserved word? I would try this...
"select * from subscribe where [date] = '08/23/2002'" -----Original Message----- From: M. H. K. [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 12: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]
