ASP
高手到哪里去呢？
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区老是显示 第 1 行: ',' 附近有语法错误 本地没有错误一上传上去就出错 快晕到了
这是它的错误提示：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ',' 附近有语法错误
if not rs1.eof then
if huiyuan=1 then
sql_Exe="EXECUTE dbo.accounthand2 '"&rs1("Account_Number")&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',"&huiyuanfei+rs1("memberacc")&",'"&dateadd("yyyy",1,rs1("memberdate"))&"',"&v_oid&""
else
sql_Exe="EXECUTE dbo.accounthand2 '"&rs1("Account_Number")&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',0,0,"&v_oid&""
end if
else
if huiyuan=1 then
sql_Exe="EXECUTE dbo.accounthand1 '"&Account_Number&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',"&huiyuanfei&","&dateadd("yyyy",1,date())&"','"&v_oid&""
else
sql_Exe="EXECUTE dbo.accounthand1 '"&Account_Number&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',0,0,"&v_oid&""
end if
end if
这是它的错误提示：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ',' 附近有语法错误
if not rs1.eof then
if huiyuan=1 then
sql_Exe="EXECUTE dbo.accounthand2 '"&rs1("Account_Number")&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',"&huiyuanfei+rs1("memberacc")&",'"&dateadd("yyyy",1,rs1("memberdate"))&"',"&v_oid&""
else
sql_Exe="EXECUTE dbo.accounthand2 '"&rs1("Account_Number")&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',0,0,"&v_oid&""
end if
else
if huiyuan=1 then
sql_Exe="EXECUTE dbo.accounthand1 '"&Account_Number&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',"&huiyuanfei&","&dateadd("yyyy",1,date())&"','"&v_oid&""
else
sql_Exe="EXECUTE dbo.accounthand1 '"&Account_Number&"',"&rs("id")&",'"&rs("username")&"',0,"&money&",1,0,1,'"&purpose&"',0,0,"&v_oid&""
end if
end if
...全文
