wrap your date with quotes.
>-----Original Message----- >From: M. H. K. [mailto:[EMAIL PROTECTED]] >Sent: September 26, 2002 3: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]
