查询问题求助

日落西山发布于 2010-11-29 13:37， 444 次点击

这句语句可以执行
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm='174';"
换成所需要调用就不行了。请求帮忙修正。。。。
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm="&session("sk_mclass")&";"

2 回复

jansonwang2010-11-29 14:17

给我分

jingjing3162010-11-29 14:24

session（"sk_mclass"）是什么类型，数值还是字符
数值
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm=”&session("sk_mclass")
字符
sql="SELECT SK_customer.*, zhkz.*, zhkz.vest_mm FROM SK_customer INNER JOIN zhkz ON SK_customer.id = zhkz.id WHERE zhkz.vest_mm='”&session("sk_mclass")&"'“