错误0x80040E14? [英] Error 0x80040E14?
本文介绍了错误0x80040E14?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
用于SQL Server的Microsoft OLE DB提供程序(0x80040E14)
第1行:'',''附近的语法不正确。
request2.asp,第139行>
for i = 1 to request.form(" hidmasterlistno)。count
错误代码
设置rs = conn.execute(" select masterlist_no,doc_num,rev,titlelist from masterlist where masterlist_no ="& request.form(" hidmasterlistno))(i)&"。")
下一步
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near '',''.
request2.asp, line 139
for i=1 to request.form("hidmasterlistno").count
error code here
Set rs = conn.execute( "Select masterlist_no , doc_num , rev , title from masterlist where masterlist_no = " &request.form("hidmasterlistno")(i)& "." )
next
推荐答案
任何专家请帮忙,真的很感激
i尝试做一些测试,打印出sql语句,如下所示。
从masterlist中选择masterlist_no,doc_num,rev,title,其中masterlist_no = 1111,2222,3333 。从masterlist中选择masterlist_no,doc_num,rev,title,其中masterlist_no = 1111,2222,3333。从masterlist中选择masterlist_no,doc_num,rev,title,其中masterlist_no = 1111,2222,333 3.
我不知道如何解决它,任何人都可以给我一些想法?谢谢
any expert please help, really appreciated
i try to do some testing, which is print out the sql statement, shown below.
Select masterlist_no , doc_num , rev , title from masterlist where masterlist_no = 1111, 2222, 3333. Select masterlist_no , doc_num , rev , title from masterlist where masterlist_no = 1111, 2222, 3333. Select masterlist_no , doc_num , rev , title from masterlist where masterlist_no = 1111, 2222, 3333.
i dont know how to fix it, anyone can give me some idea? thanks
你好chiytoo,
如果我有以下代码:
Hi chickytoo,
If I have the following code:
展开 | 选择 | Wrap | 行号
展开 | 选择 | Wrap | 行号
这篇关于错误0x80040E14?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文