«

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

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.


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

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

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

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

Dan