杨勇的夫人:str4="select * from yiyuan where g='1' and id=&idd order by data desc"

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 15:08:39
str4="select * from yiyuan where g='1' and id=&idd order by data desc"

这一句不对该怎么写啊其中idd为变量, 就是这错了

如果是asp的话应该这样写:
str4="select * from yiyuan where g='1' and [id]='"&idd&"' order by data desc"
id是保留自,要加[]加以区分。

如果是VB的话应该这么写str4 = "select * from ylyuan where g = '1' and [id] = '" & idd & "'order by data desc"。