语法错误 [英] syntax error

问题描述

我收到此错误并且无法找出正确的语法。

似乎没有改变引号的区别。

谢谢！

---------------------

查询表达式''GenKTitles中的语法错误（缺少运算符）。标题=白色

圣诞节''。

---------------------

<％

Dim DataConn，SQL

SearchTerm =" White Christmas"
设置DataConn = Server.CreateObject（" ADODB .Recordset"）

DataConn.ActiveConnection = MM_GenKAccess_STRING

SQL =" SELECT GenKStock。*，GenKTitles。*"

SQL = SQL &安培; 来自GenKStock INNER JOIN GenKTitles ON GenKStock.OrderNo =

GenKTitles.ItemNumber"

SQL = SQL& WHERE GenKTitles.Title = + SearchTerm +""

设置rsResults = DataConn.Open（SQL）

％>

解决方案

> SQL = SQL& "在哪里GenKTitles.Title ="" + SearchTerm +""

> SQL = SQL& "在哪里GenKTitles.Title ="" + SearchTerm +""

或


SQL = SQL& "在哪里GenKTitles.Title =" &安培; Chr（34）&修剪（SearchTerm）&

Chr（34）


同时检查 www.aspfaq.com 用''和'来处理问题在字符串中。在

我的国家名称或经常喜欢D''haese whta导致问题当你围绕

搜索字符串时出现'''' + searchstring +"''"

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.Title= White
Christmas''.
---------------------
<%
Dim DataConn, SQL
SearchTerm = "White Christmas"
Set DataConn = Server.CreateObject("ADODB.Recordset")
DataConn.ActiveConnection = MM_GenKAccess_STRING
SQL = "SELECT GenKStock.*, GenKTitles.* "
SQL = SQL & "FROM GenKStock INNER JOIN GenKTitles ON GenKStock.OrderNo =
GenKTitles.ItemNumber "
SQL = SQL & "WHERE GenKTitles.Title= " + SearchTerm + ""
Set rsResults = DataConn.Open(SQL)
%>

解决方案

> SQL = SQL & " WHERE GenKTitles.Title= "" + SearchTerm + ""

> SQL = SQL & " WHERE GenKTitles.Title= "" + SearchTerm + ""

or

SQL = SQL & " WHERE GenKTitles.Title= " & Chr(34) & Trim(SearchTerm) &
Chr(34)

Also check www.aspfaq.com to handle the problem with '' and " in string. In
my country name or often like D''haese whta cause a problem when you surround
the searchstring by "''" + searchstring + "''"

这篇关于语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！