2.8w+
社区成员
- 主页
急！！sql语句中的引号怎么匹配？？怎么都看不明白
'set RSLogin = conn.Execute("select * from UserInfo where " & "LoginID = '" & TheUsername & "' and " & "Password = '" & ThePassword & "'")
...全文
请发表友善的回复…
发表回复
mycl3344 2004-04-05
set RSLogin = conn.Execute("select * from UserInfo where " &LoginID &"= '"& TheUsername & "' and " & "Password = '" & ThePassword & "'")
whghwujx 2004-04-05
呵呵，我也晕了
UP
UP
SDQDboy 2004-04-05
ASP中只能用双引号，单引号用注释用的
SQL中只用单引号，慢慢找找就看清楚了
上面的语名去掉ASP中的双引号：
set RSLogin = conn.Execute("select * from UserInfo where LoginID = 'TheUsername ' and Password = 'ThePassword '")
SQL中只用单引号，慢慢找找就看清楚了
上面的语名去掉ASP中的双引号：
set RSLogin = conn.Execute("select * from UserInfo where LoginID = 'TheUsername ' and Password = 'ThePassword '")
kenvinp 2004-04-05
慢慢看就知道的了，引号代表字符串，双引内用单引表示字符串