Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: Syntax error (missing operator) in query expression

    This is the full error:

    Microsoft JET Database Engine error '80040e14'
    Syntax error (missing operator) in query expression 'Band = ''A Perfect Circle'''.
    /results.asp, line 20

    I tried to fix this using a previous post about this error, but can't figure it out. Here's the code that Dreamweaver creates:

    Set results = Server.CreateObject("ADODB.Recordset")
    results.ActiveConnection = MM_shnlist_STRING
    results.Source = "SELECT * FROM Bands WHERE Band = '" + Replace(results__MMColParam, "'", "''") + "'"
    results.CursorType = 0
    results.CursorLocation = 2
    results.LockType = 1
    results.Open()

    Thanks
    Last edited by fateman; 07-19-03 at 23:28.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •