syntax error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • shank

    syntax error

    I get this error and can't figure out the correct syntax.
    Doesn't seem to make a difference changing the quotes around.
    Thanks!
    ---------------------
    Syntax error (missing operator) in query expression 'GenKTitles.Tit le= White
    Christmas'.
    ---------------------
    <%
    Dim DataConn, SQL
    SearchTerm = "White Christmas"
    Set DataConn = Server.CreateOb ject("ADODB.Rec ordset")
    DataConn.Active Connection = MM_GenKAccess_S TRING
    SQL = "SELECT GenKStock.*, GenKTitles.* "
    SQL = SQL & "FROM GenKStock INNER JOIN GenKTitles ON GenKStock.Order No =
    GenKTitles.Item Number "
    SQL = SQL & "WHERE GenKTitles.Titl e= " + SearchTerm + ""
    Set rsResults = DataConn.Open(S QL)
    %>


Working...