what's wrong with this corde ?

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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 español : http://asp.net.do/foros/
======================================
 
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"
 
Back
Top