ASP经典SQL查询错误信息，正确的语法请 [英] ASP Classic SQL Query error message, right syntax please

问题描述

我传递的URL两（2）参数，构建SQL语句：

I am passing two (2) parameters in the URL, and building the following SQL:

mQry = "SELECT DISTINCT name FROM link3 WHERE invoice_num ="  & request.querystring("num") & "AND name LIKE" & request.querystring("nam")

我得到一个错误信息：

I got an error message:

Microsoft OLE DB提供了Oracle错误80040E14

Microsoft OLE DB Provider for Oracle error '80040e14'

ORA-00933：SQL命令未正确结束

ORA-00933: SQL command not properly ended

什么是正确的语法呢？

推荐答案

您需要把周围的LIKE子句报价。此外，您可以考虑使用百分比为通配符匹配

You need to put quotes around the LIKE clause. Also, you could consider using percents for wildcard matching

mQry = "SELECT DISTINCT name FROM link3 WHERE invoice_num =" & request.querystring("num") & " AND name LIKE '%" & request.querystring("nam") & "%' "

这篇关于ASP经典SQL查询错误信息，正确的语法请的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！