what's wrong with this 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

 

[Juan T. Llibre]

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.

 

[Mike]

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

 

[Mike]

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

 

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

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"