注册 登录
编程论坛 ASP技术论坛

请大虾们帮帮忙

人王 发布于 2012-03-31 10:30, 316 次点击
DLSQL = "SELECT Max([HY]) AS [HY],Min([LY]) AS [LY] FROM ("
DLSQL = DLSQL & " SELECT Max([EX-Time]) AS [HY],Min([EX-Time]) AS [LY] FROM [Expenditure]"
DLSQL = DLSQL & " Union SELECT Max([C-AcceptDate]) AS [HY],Min([C-AcceptDate]) AS [LY] FROM [CreditCard]"
DLSQL = DLSQL & " Union SELECT Max(A.[S-Date]) AS [HY],Min(A.[S-Date]) AS [LY] FROM [G-Title] AS A,(SELECT DISTINCT [G-Number] FROM [GroupMembers] WHERE ([D-Subscribe]+[D-Discount]+[D-RealMeney]+[D-Card]) > 0) AS B WHERE A.[G-Number] = B.[G-Number] "
DLSQL = DLSQL & ")"
我运行后出现下面的信息
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ')' 附近有语法错误。
数据库连接都是没错的。
大家看看哪里出错了啊,谢谢啦!!!
2 回复
#2
yms1232012-04-03 15:26
你把这段SQL语句的执行语句临时注释掉,然后输出一下运行时的SQL语句看一下
#3
人王2012-04-11 09:53
回复 2楼 yms123
具体怎么弄?不知道怎么办?我是新手。麻烦帮帮忙啊
1