sql执行过程中出现的有关问题
sql执行过程中出现的问题
SQL is:select a.rec_ctrl_id, a.book_barcode, a.book_search_no, a.access_no, a.de
partment_id, a.circul_status, b.v_905, b.note, a.book_status, convert(char(11),a
.date_due,111) date_due from manager.v_ct_Z a , manager.ct_2_A b where rec_ctrl
_id='01h0022362 and a.rec_ctrl_id = b.rec_ctrl_id
opac_sql.executeQuery:Unclosed quote before the character string '01h0022362 and
a.rec_ctrl_id = b.rec_ctrl_id '.
这是在dos命令行中提示的错误 以及运行的语句。哪位大大 有过经验的 麻烦提点下！！
------解决方案--------------------
select a.rec_ctrl_id, a.book_barcode, a.book_search_no, a.access_no, a.de
partment_id, a.circul_status, b.v_905, b.note, a.book_status, convert(char(11),a
.date_due,111) date_due from manager.v_ct_Z a , manager.ct_2_A b where rec_ctrl
_id='01h0022362‘ and a.rec_ctrl_id = b.rec_ctrl_id
少了个引号
------解决方案--------------------
where 的第一个rec_ctrl_id没有用别名，优化器不清楚
SQL is:select a.rec_ctrl_id, a.book_barcode, a.book_search_no, a.access_no, a.de
partment_id, a.circul_status, b.v_905, b.note, a.book_status, convert(char(11),a
.date_due,111) date_due from manager.v_ct_Z a , manager.ct_2_A b where rec_ctrl
_id='01h0022362 and a.rec_ctrl_id = b.rec_ctrl_id
opac_sql.executeQuery:Unclosed quote before the character string '01h0022362 and
a.rec_ctrl_id = b.rec_ctrl_id '.
这是在dos命令行中提示的错误 以及运行的语句。哪位大大 有过经验的 麻烦提点下！！
------解决方案--------------------
select a.rec_ctrl_id, a.book_barcode, a.book_search_no, a.access_no, a.de
partment_id, a.circul_status, b.v_905, b.note, a.book_status, convert(char(11),a
.date_due,111) date_due from manager.v_ct_Z a , manager.ct_2_A b where rec_ctrl
_id='01h0022362‘ and a.rec_ctrl_id = b.rec_ctrl_id
少了个引号
------解决方案--------------------
where 的第一个rec_ctrl_id没有用别名，优化器不清楚