ASP 中的sql语句response.write 出来少sql

[Megan2008]

sql语句很长，只列出其中有问题的一段
sql=""
sql="sql前面的省略
"where t1.starttime>=t2.repdate and t1.starttime<t3.repdate )t1,
当我把这些语句response出来后发现在这句话后面开始丢失部分sql语句
请问该如何避免这样的问题，谢谢

[sy_binbin]

那说明你SQL语句有问题，或者字符串拼接有问题

[layers2323]

sql语句拼接有误吧

[Megan2008]

最初我也以为是拼接问题，但是后来我已经给修改成一个sql了，没有拼接，都写在一行里面还是有这样的问题

[layers2323]

上代码。

[Megan2008]

代码已经被我修改得乱七八糟了，大家将就看一下吧，谢谢啦
elseif request("stage1")="radio2" then
sql=""
sql=" select t2.calendar_year,t2.fiscal_week,t2.stngrp,t2.stn,t2.recipe,t2.maxbatch,round(avg(t1.pieces),2) pieces from (select t1.starttime,t1.stngrp,t1.stn,t1.pieces,recipe from (select trunc(starttime)starttime,count(pieces)pieces,maxbatch/25 maxbatch,stn,stngrp,recipe from csmc_short_view@dbre199 group by trunc(starttime),maxbatch,stn,stngrp,recipe )t1, (select trunc(calendar_date)repdate from day_master@dbre where calendar_year='"&request("t1_week_year")&"' and fiscal_week='"&request("t1_week")&"' and day_of_week='1' )t2, (select trunc(calendar_date)repdate from day_master@dbre where calendar_year='"&request("t2_week_year")&"' and fiscal_week='"&request("t2_week")&"' and day_of_week='1' )t3 where t1.starttime>=t2.repdate and t1.starttime<t3.repdate )t1, (select t2.repdate,t2.calendar_year,t2.fiscal_week,t1.recipe,t1.stngrp,t1.stn,t1.maxbatch from (select t1.starttime, t1.stngrp,t1.stn,t1.maxbatch,t1.recipe from (select trunc(starttime)starttime,count(pieces)pieces,maxbatch/25 maxbatch,stn,stngrp, recipe from csmc_short_view@dbre199 group by trunc(starttime),maxbatch,stn,stngrp,recipe )t1, (select trunc(calendar_date)repdate from day_master@dbre where calendar_year='"&request("t1_week_year")&"' and fiscal_week='"&request("t1_week")&"' and day_of_week='1' )t2, (select trunc(calendar_date)repdate from day_master@dbre where calendar_year='"&request("t2_week_year")&"' and fiscal_week='"&request("t2_week")&"' and day_of_week='1' )t3 where ( t1.starttime>=t2.repdate and t1.starttime<t3.repdate )t1, (select trunc(t1.calendar_date)repdate,t1.calendar_year,t1.fiscal_week "&_
" from day_master@dbre t1, (select trunc(calendar_date)repdate from day_master@dbre where calendar_year='"&request("t1_week_year")&"' and fiscal_week='"&request("t1_week")&"' and day_of_week='1' )t2, (select trunc(calendar_date)repdate from day_master@dbre where calendar_year='"&request("t2_week_year")&"' and fiscal_week='"&request("t2_week")&"' and day_of_week='1' )t3 where t1.calendar_date>=t2.repdate and t1.calendar_date<t3.repdate )t2 where t2.repdate=t1.starttime(+) )t2 where t2.repdate=t1.starttime and t2.stngrp=t1.stngrp(+) and t2.stn=t1.stn(+) and t2.recipe=t1.recipe(+) group by t2.calendar_year,t2.fiscal_week,t2.stngrp,t2.stn,t2.maxbatch,t2.recipe order by t2.recipe,t2.stn,t2.stngrp,t2.calendar_year,t2.fiscal_week "



Response.Write sql
Response.End

[layers2323]

我也发觉了。当输出到最后第三行， where t1.calendar_date>=t2.repdate and t1.calendar_date <t3.repdate )t2
这里的<后面的都没了，很奇怪觉得。

然后在这个<后面加了一个空格，就好了。


lz你的sql写的也太乱了，最好用 "sql = sql &"来拼，遇到一个sql关键字就应该重新拼接，这样可读性高很多。

[Megan2008]

我当时就是这么拼接的，后来因为代码出错，就该成这样子了，不好意思，看代码比较累

[layers2323]

可能是浏览器把小于号误认为是html标签了
用response.write (server.HTMLEncode(sql))好了。

[Megan2008]

刚刚又测试了一下，还是有一部分没有输出来，把代码重新贴出来
sql=""
sql=sql & " select t2.calendar_year,t2.fiscal_week,t2.stngrp,t2.stn,t2.recipe,t2.maxbatch,round(avg(t1.pieces),2) pieces "
sql=sql & " from (select t1.starttime,t1.stngrp,t1.stn,t1.pieces,recipe "
sql=sql & " from (select trunc(starttime)starttime,count(pieces)pieces,maxbatch/25 maxbatch,stn,stngrp,recipe "
sql=sql & " from csmc_short_view@dbre199 "
sql=sql & " group by trunc(starttime),maxbatch,stn,stngrp,recipe "
sql=sql & " )t1, "
sql=sql & " (select trunc(calendar_date)repdate from day_master@dbre "
'sql=sql & " where calendar_year='"&request("t1_week_year")&"' "
sql=sql & " where calendar_year='2009' "
'sql=sql & " and fiscal_week='"&request("t1_week")&"' "
sql=sql & " and fiscal_week='1' "
sql=sql & " and day_of_week='1' "
sql=sql & " )t2, "
sql=sql & " (select trunc(calendar_date)repdate from day_master@dbre "
'sql=sql & " where calendar_year='"&request("t2_week_year")&"' "
sql=sql & " where calendar_year='2009' "
'sql=sql & " and fiscal_week='"&request("t2_week")&"' "
sql=sql & " and fiscal_week='4' "
sql=sql & " and day_of_week='1' "
sql=sql & " )t3 "
sql=sql & " where t1.starttime>=t2.repdate and t1.starttime<t3.repdate "
sql=sql & " )t1, "
sql=sql & " (select t2.repdate,t2.calendar_year,t2.fiscal_week,t1.recipe,t1.stngrp,t1.stn,t1.maxbatch "
sql=sql & " from (select t1.starttime, t1.stngrp,t1.stn,t1.maxbatch,t1.recipe "
sql=sql & " from (select trunc(starttime)starttime,count(pieces)pieces,maxbatch/25 maxbatch,stn,stngrp, recipe "
sql=sql & " from csmc_short_view@dbre199 group by trunc(starttime),maxbatch,stn,stngrp,recipe "
sql=sql & " )t1, "
sql=sql & " (select trunc(calendar_date)repdate from day_master@dbre "
'sql=sql & " where calendar_year='"&request("t1_week_year")&"' "
sql=sql & " where calendar_year='2009' "
'sql=sql & " and fiscal_week='"&request("t1_week")&"' "
sql=sql & " and fiscal_week='1' "
sql=sql & " and day_of_week='1' "
sql=sql & " )t2, "
sql=sql & " (select trunc(calendar_date)repdate from day_master@dbre "
'sql=sql & " where calendar_year='"&request("t2_week_year")&"' "
sql=sql & " where calendar_year='2009' "
'sql=sql & " and fiscal_week='"&request("t2_week")&"' "
sql=sql & " and fiscal_week='4' "
sql=sql & " and day_of_week='1' "
sql=sql & " )t3 "
sql=sql & " where t1.starttime>=t2.repdate and t1.starttime<t3.repdate "
sql=sql & " )t1, "
sql=sql & " (select trunc(t1.calendar_date)repdate,t1.calendar_year,t1.fiscal_week "
sql=sql & " from day_master@dbre t1, "
sql=sql & " (select trunc(calendar_date)repdate "
sql11=sql & " from day_master@dbre "
'sql=sql & " where calendar_year='"&request("t1_week_year")&"' "
sql=sql & " where calendar_year='2009' "
sql=sql & " and fiscal_week='"&request("t1_week")&"' "
sql=sql & " and fiscal_week='1' "
sql=sql & " and day_of_week='1' "
sql=sql & " )t2, "
sql=sql & " (select trunc(calendar_date)repdate "
sql=sql & " from day_master@dbre "
'sql=sql & " where calendar_year='"&request("t2_week_year")&"' "
sql=sql & " where calendar_year='2009' "
'sql=sql & " and fiscal_week='"&request("t2_week")&"' "
sql=sql & " and fiscal_week='4' "
sql=sql & " and day_of_week='1' "
sql=sql & " )t3 "




sql=sql & " where t1.calendar_date>=t2.repdate and t1.calendar_date<t3.repdate "




sql=sql & " )t2 "
sql=sql & " where t2.repdate=t1.starttime(+) "
sql=sql & " )t2 "
sql=sql & " where t2.repdate=t1.starttime and t2.stngrp=t1.stngrp(+) "
sql=sql & " and t2.stn=t1.stn(+) and t2.recipe=t1.recipe(+) "
sql=sql & " group by t2.calendar_year,t2.fiscal_week,t2.stngrp,t2.stn,t2.maxbatch,t2.recipe "
sql=sql & " order by t2.recipe,t2.stn,t2.stngrp,t2.calendar_year,t2.fiscal_week "


Response.Write(server.HTMLEncode(sql))
Response.End

[Megan2008]

问题已经解决，谢谢大家