“参数不足,期待是1”是什么意思?
有一段sql,在数据窗口中查询的时候,结果一切正常,但到asp里查询,却总报错说“参数不足,期待是1”?很郁闷,asp真他妈的破。
SELECT job_will.job_will_no, job_will.resu_no,
job_will.will_sal_star_no,
job_will.will_sal_end_no, job_will.self_judge,
job_will.will_mon_kind_no,
job_will.work_kind_no,
job_will_co_prop.co_prop_no,
co_prop.co_prop_dsc, job_will_position.pos_no,
position.pos_dsc,
job_will_work_area.job_will_city_id,
city.city_name FROM job_will,
job_will_co_prop, job_will_position,
job_will_work_area, co_prop, position,
city WHERE ( job_will.job_will_no =
job_will_work_area.job_will_no ) and (
job_will_co_prop.job_will_no =
job_will.job_will_no ) and (
job_will_position.job_will_no =
job_will.job_will_no ) and (
job_will_co_prop.co_prop_no = co_prop.co_prop_no
) and ( job_will_position.pos_no =
position.pos_no ) and (
job_will_work_area.job_will_city_id =
city.city_id ) and ( job_will.job_will_no =
22 )