帮忙查看一下sql语句出错！

[sarm]

rs.open "SELECT SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour where year= "&uyear&" group by year",conn,1,3

我的问题是：
1、这个语句通不过
2、我还想加一个把所有数据加起来（当where year＝"&uyear&"），可不知道该怎么写？？
thanks

[sarm]

唉！！还是没人吗？？

[guihengzhang]

SELECT year,SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour where year= "&uyear&" group by year

[sarm]

谢谢一楼的，那还有第2 个问题那？？

[yslcuk]

rs.open "SELECT SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour where year= '"&uyear&"' group by year",conn,1,3

少了个单引号

[sarm]

晕！！楼上的一个都不行！！
忘了说一下，year是smallint

[aobao]

rs.open "SELECT SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour group by year having year= '"&uyear&"' ",conn,1,3

[sarm]

好像还是不行？？

[chang1216]

把sql语句打出来 放在查询分析器里看看不就知道了

[sarm]

整理一下！
rs.open "SELECT SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour where year="&uyear&" ",conn,1,3

出错：
[IBM][CLI Driver][DB2/NT] SQL0104N 在 "M labour where year=" 之后发现意外的记号 "END-OF-STATEMENT"。期望的记号可能包括："<row_value_constructor>"。 SQLSTATE=42601

[wwweasy]

rs.open "SELECT SUM(onetime) as onetimesum, SUM(bursary) as bursary,SUM(helpmonth) as helpmonthsum,SUM(helptotal) as helptotalsum,SUM(balance) as balancesum,SUM(deathmoney) as deathmoneysum FROM labour where year='"&uyear&"' ",conn,1,3
在查询分析器里看看好用不?

[wwweasy]

不好用后面再加上group by year

[linxianlie]

检查一下是不是得到uyear的数据类型不正确。

[czhenq]

看看运行后的sql语句

可能是你的uyear的问题

[银狐被占用]

SELECT SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour where year= "&uyear&"
union all
SELECT year,SUM(onetime), SUM(bursary),SUM(helpmonth),SUM(helptotal),SUM(balance),SUM(deathmoney) FROM labour

[sarm]

我到！还是不行，我把程序贴上来帮忙看看！！

[sarm]

dim uyear
uyear = Request.QueryString("year")

Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open"UID=userid;PWD=8116116;dsn=labour"
Set rs=Server.CreateObject("ADODB.Recordset")
Set rs.ActiveConnection = Conn
rs.CursorType = 3

rs.open "SELECT SUM(onetime) as onetimesum, SUM(bursary) as bursary,SUM(helpmonth) as helpmonthsum,SUM(helptotal) as helptotalsum,SUM(balance) as balancesum,SUM(deathmoney) as deathmoneysum FROM labour where year="&uyear&" ",conn,1,3