28,391
社区成员
发帖
与我相关
我的任务
分享
SELECT SUM(CASE WHEN isnumeric(amount) = 1 THEN cast(amount AS decimal(38, 2)) ELSE 0 END)
FROM PQOrderLIN
WHERE pqorderno = 'PQ1204007'
<%
set rs=conn.exexute(sql)
if not rs.EOF then
response.write rs(0)
end if
%>
<%
set rs=server.createobject("adodb.recordset")
sql="SELECT SUM(CASE WHEN isnumeric(amount) = 1 THEN cast(amount AS decimal(38, 2))
ELSE 0 END) from PQOrderLin where PQorderNo='"&PQorderNo&"'"
set rs=conn.exexute(sql)
if not rs.EOF then
response.write rs(0)
end if
%>
如下报错~Unterminated string constant