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