67,515
社区成员
发帖
与我相关
我的任务
分享
//TODO:灵异事件,select 前加个空格有的会出错。
strSQL="select *,substring(convert(varchar(12),r_usetime,120),1,10) r_usetime," +
"(select fu_name from z_factory_user where fu_id=r.user_id) fu_name," +
"(select servername from server_info where server_code=r.server_id) servername," +
"(select zd_zmc from t_init_data_table_mark where table_id = 'RepeaterInfo' and zd_zbh = r.repeater_type and zd_id='repeater_type') repeater_type2," +
"(select k.StationName from RepeaterInfo k where k.StationID=r.Host_id and k.host_id='') dev_name," +
"(select zd_zmc from t_init_data_table_mark where table_id = 'RepeaterInfo' and zd_zbh = r.protype and zd_id='protype') protype2" +
" from RepeaterInfo r where 1=1 and repeaterid= " +
"'"+repeaterid+"'" ;
strSQL=" select *,
多了个空格!!!!" from RepeaterInfo r where 1=1 and repeaterid= " +
"'"+repeaterid+"'" ;
这个from前面多加个空格,也可以查询出来,如果没加又是查询不出来。