search

codegooglecom / easyasp

Automatically exported from code.google.com/p/easyasp
0 stars 0 forks source link

关于GetRecord的用法 #28

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
GetRecord的例子是：
Set rs = Easp.db.GetRecord("TestTable:fId,fName,fAge","fSex='男'","fName 
Asc")   
如果男是这样得到的怎么写？
xingbie=request.form("xingbie")
下面的是我写的
Set rs = Easp.db.GetRecord
("TestTable:fId,fName,fAge","fSex="&xingbie,"fName Asc") 
但这样写出错了，说是rs关闭不允许操作。
而用数组Array("fSex"&xingbie)就正确。

Original issue reported on code.google.com by allwebma...@126.com on 1 May 2009 at 7:28

GoogleCodeExporter commented 9 years ago 
如果不用数组的话，就要加单引号：
xingbie = Easp.R("xingbie",0)
Set rs = Easp.db.GR("TestTable:fId,fName,fAge","fSex='"&xingbie&"'","fName Asc")

Original comment by Tainray@gmail.com on 2 May 2009 at 1:56