Question

ASP中Replace将字符串中逗号转成','

dim sname
dim zh
sname = Request("name")
zh= Replace("&sname&",",","','")
sql="select * from minxi where CPH in('"&zh&"')"

看来看去好像就是在 replace这个转换的时候将逗号左右两边多加一个单引号，想半天没想出来如何加，请大家帮帮忙，谢谢！~

Answer 1

zh= Replace("&sname&",",","','")
这一句明显不对sname两边怎么会有引号，改为下面的再试试

dim sname
dim zh
sname = Request("name")
zh= Replace(""&sname,",","','")
sql="select * from minxi where CPH in('"&zh&"')"