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

This is an asp.net newsgroup, not an asp newsgroup.

For answers to asp questions, post to :

microsoft.public.inetserver.asp.general

That's where people who know the answer to questions about active server pages hang out.




Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espaol : http://asp.net.do/foros/
======================================
"John"  wrote in message news:e8eh0u04HHA.5984@TK2MSFTNGP04.phx.gbl...

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

You sure the error is really in the SQL and not your asp code?


"John"  wrote in message 
news:e8eh0u04HHA.5984@TK2MSFTNGP04.phx.gbl...

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

Oh, Ok,

Date isn't a function in SQL, try GetDate()

here is some information on the GetDate in SQL

http://msdn2.microsoft.com/en-us/library/ms186724.aspx



"John"  wrote in message 
news:e8eh0u04HHA.5984@TK2MSFTNGP04.phx.gbl...

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

It looks like the problem is that you've embedded double quotes within your 
double quotes.
Try using single quotes around the m like this:

fp_sQry="Select * From tblMatches Where( tblMatches.Date >=
DateAdd('m',-1,Date())) Order by tblMatches.Date DESC"

-- 
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net



"John"  wrote in message 
news:e8eh0u04HHA.5984@TK2MSFTNGP04.phx.gbl...

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