28,391
社区成员
发帖
与我相关
我的任务
分享問一個非常簡單的問題﹐快來搶分呀
我想問下下
mac_state=request.form("search")
mac_product=request.form("search1")
sql="select MAC_STATE,MAC_PRODUCT FROM SPLPRODUCT where MAC_PRODUCT='"&mac_product&"' and MAC_STATE LIKE 就是這里我要怎樣寫成%變量%
mac_state=request.form("search")
mac_product=request.form("search1")
sql="select MAC_STATE,MAC_PRODUCT FROM SPLPRODUCT where MAC_PRODUCT='"&mac_product&"' and MAC_STATE LIKE 就是這里我要怎樣寫成%變量%
...全文
请发表友善的回复…
发表回复
jlcanoe 2004-09-27
- 打赏
- 举报
sql="select MAC_STATE,MAC_PRODUCT FROM SPLPRODUCT where MAC_PRODUCT='"&mac_product&"' and MAC_STATE LIKE '%" & 变量 "%'"
zzznzzzz 2004-09-27
- 打赏
- 举报
一二楼是对的
dicklee1214 2004-09-27
- 打赏
- 举报
一二楼是对的
panzi667 2004-09-27
- 打赏
- 举报
抢分
香椿炒鸡蛋 2004-09-27
- 打赏
- 举报
sql="select MAC_STATE,MAC_PRODUCT FROM SPLPRODUCT where MAC_PRODUCT='"&mac_product&"' and MAC_STATE LIKE '%" & 变量 &"%' " 呵呵 这样把
zhf8203 2004-09-27
- 打赏
- 举报
注意过滤非法字符
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
零点网络 www.cnse.cn 大量WEB技术资料免费查阅
包括ASP、.NET、JSP、PHP、数据库、服务器等技术
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
零点网络 www.cnse.cn 大量WEB技术资料免费查阅
包括ASP、.NET、JSP、PHP、数据库、服务器等技术
＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊
zltostem 2004-09-27
- 打赏
- 举报
sql="select MAC_STATE,MAC_PRODUCT FROM SPLPRODUCT where MAC_PRODUCT='"&mac_product&"' and MAC_STATE LIKE '%" & 变量 "%'"
上面少了一个引号~~~
上面少了一个引号~~~
zltostem 2004-09-27
- 打赏
- 举报
sql="select MAC_STATE,MAC_PRODUCT FROM SPLPRODUCT where MAC_PRODUCT='"&mac_product&"' and MAC_STATE LIKE '%" & 变量 "%'
