老是出错,请大家看看!解决了有分!
放在网页上的SQL语句如下:
SELECT DRACCNO,
SUM(CASE WHEN TRXCODE = '60024' THEN AMOUNT1 ELSE 0 END) AS 交易总金额1,
SUM(CASE WHEN TRXCODE = '2420' THEN AMOUNT1 ELSE 0 END) AS 交易总金额2,
SUM(CASE WHEN TRXCODE = '9018' THEN AMOUNT1 ELSE 0 END) AS 交易总金额3,
SUM(CASE WHEN TRXCODE = '2589' THEN AMOUNT1 ELSE 0 END) AS 交易总金额4,
SUM(CASE WHEN TRXCODE = '9026' THEN AMOUNT1 ELSE 0 END)
AS 交易总金额5
FROM NFSJN1
WHERE LEFT(cast(DRACCNO AS varchar), 8) = '0001' OR
LEFT(cast(DRACCNO AS varchar), 8) = '0266' OR
LEFT(cast(DRACCNO AS varchar), 8) = '0112' OR
LEFT(cast(draccno AS varchar), 8) = '0911'
GROUP BY DRACCNO
运行后结果显示:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:93: unclosed string literal
SQL="SELECT DRACCNO,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:94: unclosed character literal
SUM(CASE WHEN TRXCODE = '60024' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?1,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:94: unclosed character literal
SUM(CASE WHEN TRXCODE = '60024' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?1,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:95: unclosed character literal
SUM(CASE WHEN TRXCODE = '2420' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?2,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:95: unclosed character literal
SUM(CASE WHEN TRXCODE = '2420' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?2,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:96: unclosed character literal
SUM(CASE WHEN TRXCODE = '9018' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?3,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:96: unclosed character literal
SUM(CASE WHEN TRXCODE = '9018' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?3,
^
An error occurred at line: 33 in the jsp file: /dzyh/fenxi.jsp
Generated servlet error:
C:\Tomcat4.1\work\Standalone\localhost\_\dzyh\fenxi_jsp.java:97: unclosed character literal
SUM(CASE WHEN TRXCODE = '2589' THEN AMOUNT1 ELSE 0 END) AS 浜ゆ??婚?棰?4,
等等,全部说在数字上加的引号有问题,我也搞不清楚了,