高考问答欢喜来逗阵第一部地5集:asp 数据比较问题
来源：百度文库 编辑：高考问答 时间：2024/05/03 09:14:10
.....*****.........
<%
dim uname
uname=session("MM_Username")
%>
.....*****........
rs1.Source = "SELECT Num, Name, psw, Sex, Photo, Birth, National, School, College, Prof, Grade, Class, FlatNum, Positon, Tel, Address, Note FROM sinfo WHERE Name = '" + Replace(uname, "'", "''") + "'"
这样的话就能正确，要是改成下面的就不正确了
rs1.Source = "SELECT Num, Name, psw, Sex, Photo, Birth, National, School, College, Prof, Grade, Class, FlatNum, Positon, Tel, Address, Note FROM sinfo WHERE Name = uname"
或者为
rs1.Source = "SELECT Num, Name, psw, Sex, Photo, Birth, National, School, College, Prof, Grade, Class, FlatNum, Positon, Tel, Address, Note FROM sinfo WHERE Name ='uname'"
倒底是什么原因呢？？？
第二种和第三种加单引号的区别又是什么呢？？
<%
dim uname
uname=session("MM_Username")
%>
.....*****........
rs1.Source = "SELECT Num, Name, psw, Sex, Photo, Birth, National, School, College, Prof, Grade, Class, FlatNum, Positon, Tel, Address, Note FROM sinfo WHERE Name = '" + Replace(uname, "'", "''") + "'"
这样的话就能正确，要是改成下面的就不正确了
rs1.Source = "SELECT Num, Name, psw, Sex, Photo, Birth, National, School, College, Prof, Grade, Class, FlatNum, Positon, Tel, Address, Note FROM sinfo WHERE Name = uname"
或者为
rs1.Source = "SELECT Num, Name, psw, Sex, Photo, Birth, National, School, College, Prof, Grade, Class, FlatNum, Positon, Tel, Address, Note FROM sinfo WHERE Name ='uname'"
倒底是什么原因呢？？？
第二种和第三种加单引号的区别又是什么呢？？
你用 "&uname&"
uname是一个变量,所以必须在两边+ &&