很奇怪的代码问题,数据库为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???
------解决方案--------------------关注