15. marts 2004 - 15:16
Der er
3 kommentarer og
1 løsning
Fejl i sql streng
Hej
Jeg har et login script der giver følgende fejl (det er med en MySQL database):
ADODB.Connection.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/test/includes/funktions/login_control.asp, line 41
41: SQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"
Set rs = DataConn.Execute(strSQL)
42: SQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"
Set rs = DataConn.Execute(strSQL)
Jeg synes bare ikke der er en fejl...
15. marts 2004 - 15:45
#2
41: SQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"
Set rs = DataConn.Execute(SQL)
42: SQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"
Set rs = DataConn.Execute(SQL)
eller:
41: strSQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"
Set rs = DataConn.Execute(strSQL)
42: strSQL = "SELECT * FROM users WHERE user_username='" & (username) & "' And user_password='" & (password) & "'"
Set rs = DataConn.Execute(strSQL)
Så vidt jeg kan se er din sql sætnings navn ikke det samme som du exekvere....
/Tubber
