请高手来看一看!!我的SQL语句有什么错吗??小妹多谢了!
jonia 2003-08-20 10:25:29 <%
dim inventorysql,flag
inventorysql="select supply,salepn,buypn SUM(amount) as amounts from vebuybal where buy ='" & session("firm_short") & "'"
Dim rscv
Dim rscv_numRows
Set rscv = Server.CreateObject("ADODB.Recordset")
if request("ctype")="out" then
if request("txfgoods")<>""then
inventorysql=inventorysql&" and supply='" & request("txfgoods") & "'"
end if
if request("txfpn")<>""then
inventorysql=inventorysql&" and buypn='" & request("txfpn") & "'"
end if
inventorysql=inventorysql+"GROUP BY supply"
end if
rscv.Open inventorysql,MM_conn_STRING,1
rscv_numRows = 0
%>