急！！sql语句中的引号怎么匹配？？怎么都看不明白

[xlzhang66]

'set RSLogin = conn.Execute("select * from UserInfo where " & "LoginID = '" & TheUsername & "' and " & "Password = '" & ThePassword & "'")

[kenvinp]

慢慢看就知道的了，引号代表字符串，双引内用单引表示字符串

[SDQDboy]

ASP中只能用双引号，单引号用注释用的
SQL中只用单引号，慢慢找找就看清楚了
上面的语名去掉ASP中的双引号：
set RSLogin = conn.Execute("select * from UserInfo where LoginID = 'TheUsername ' and Password = 'ThePassword '")

[whghwujx]

呵呵，我也晕了
UP

[mycl3344]

set RSLogin = conn.Execute("select * from UserInfo where " &LoginID &"= '"& TheUsername & "' and " & "Password = '" & ThePassword & "'")