日期:2014-05-18  浏览次数:20804 次

很奇怪的代码问题,数据库为oracle
b_sql= "select   t4.f_dept_name,t.f_worker_name,t2.f_phone_number,t6.f_item_name,
t2.f_memo,         //--该字段更换成任意其他字段都可以通过,就是这个备注字段不行
nvl(t2.f_account,0),t2.f_account2,t5.f_worker_name,t2.f_agent_date   from   (select   f_work_branch,f_id,f_worker_name   from   t_worker_no     where   "+work_b+ "   )   t,(select   *   from   t_new_service   t3   where   "+deptidsql+ "   and   t3.f_agent_date> =to_date( ' "+form1.F_begin_date.value+ "     00:00:00 ', 'yyyy-mm-dd   hh24:mi:ss ')   and   t3.f_agent_date <=to_date( ' "+form1.F_end_date.value+ "   23:59:59 ', 'yyyy-mm-dd   hh24:mi:ss ')   and   "+cardtypesql+ "   )   t2   ,t_dept   t4   ,t_worker_no   t5,t_sys_new_service   t6   where   t.f_id=t2.f_operator_person(%2B)and   t.f_work_branch=t2.f_station_no(%2B)   and   t.f_work_branch=t4.f_id(%2B)   and   t2.f_agent_person=t5.f_id(%2B)   and   t6.f_id(%2B)=t2.f_newservice_code ";
       
var   url= "new_service_list_query_report.jsp?sql= "+b_sql+ "&enddate= "+form1.F_end_date.value+ "&begindate= "+form1.F_begin_date.value;
//--上处换成其他字段新窗口没有问题,但是若是该备注字段,则数据无法显示,提示缺少对象,但后台查询数据已经读取到客户端数组中
var   newArchives=window.open(url, " ",   "Height=550px,Width=800px,   left=60,top=50,   toolbar=no,   menubar=no,   scrollbars=yes,   resizable=yes,location=no,status=yes,   center=yes ");

------解决方案--------------------
what 's your problem???
------解决方案--------------------
关注