Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > what's wrong with htis corde ?

Reply
Thread Tools

what's wrong with htis corde ?

 
 
John
Guest
Posts: n/a
 
      08-20-2007

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


 
Reply With Quote
 
 
 
 
Evertjan.
Guest
Posts: n/a
 
      08-20-2007
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)
 
Reply With Quote
 
 
 
 
Daniel Crichton
Guest
Posts: n/a
 
      08-21-2007
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


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
what's wrong with this corde ? John ASP .Net 4 08-20-2007 05:47 PM
Zero Config keeps connecting to the wrong AP =?Utf-8?B?ZGdyaWZmaXRo?= Wireless Networking 2 03-04-2005 05:52 PM
Is XML Doc wrong or is Schema wrong? (or both) Matthew XML 7 01-07-2005 10:05 PM
wrong connection status Peter Welk Wireless Networking 0 12-22-2004 03:26 PM
XP SP2 Wrong IP on connection D Wells Wireless Networking 3 12-09-2004 03:35 AM



Advertisments