what's wrong with htis corde ?

[John]

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/new.asp, line 43

fp_sQry="Select * From tblMatches Where( tblMatches.Date >=
DateAdd("m",-1,Date())) Order by tblMatches.Date DESC"
---------------------------------------------------------------------^thanks
for your help

 

[Evertjan.]

John wrote on 20 aug 2007 in microsoft.public.inetserver.asp.general:

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/new.asp, line 43

fp_sQry="Select * From tblMatches Where( tblMatches.Date >=
DateAdd("m",-1,Date())) Order by tblMatches.Date DESC"
---------------------------------------------------------------------^t
hanks for your help

Internal quotes in a sql string should be single,
otherwise the string is broken.

 

[Daniel Crichton]

Evertjan. wrote on 20 Aug 2007 17:35:05 GMT:

John wrote on 20 aug 2007 in microsoft.public.inetserver.asp.general:


Internal quotes in a sql string should be single, otherwise the string
is broken.

Or should be doubled up so that a double quote is an element of the string.

Dan