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)
%>
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)
%>