what's wrong with htis corde ?

Discussion in 'ASP General' started by John, Aug 20, 2007.

  1. John

    John Guest

    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, Aug 20, 2007
    #1
    1. Advertising

  2. John

    Evertjan. Guest

    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., Aug 20, 2007
    #2
    1. Advertising

  3. 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
    Daniel Crichton, Aug 21, 2007
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Salisha Khan
    Replies:
    1
    Views:
    11,636
    JohnFol
    Aug 1, 2003
  2. Replies:
    2
    Views:
    385
  3. Pial
    Replies:
    4
    Views:
    56,621
    Phatman
    Aug 27, 2010
  4. Matthew
    Replies:
    7
    Views:
    657
    Priscilla Walmsley
    Jan 7, 2005
  5. John

    what's wrong with this corde ?

    John, Aug 20, 2007, in forum: ASP .Net
    Replies:
    4
    Views:
    297
    Steve C. Orr [MCSD, MVP, CSM, ASP Insider]
    Aug 20, 2007
Loading...

Share This Page