quote: after installing one of the MOD's ( sorry i don't remember which one now) i am not able to get to user profile i am getting this message: Syntax error (missing operator) in query expression 'M_NAME = 'test' WHERE M_NAME = 'test' AND M_PASSWORD = 'test''. /axg/pop_profile.asp, line 637 [/red]
Seem it's an SQL error, send us Line 632 to 642 of pop_profile.asp
got it guys i was trying to add the e_notification.asp and it and replaceed if strAuthType = "db" then strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.Form("Password"),"password") & "'" end if
With
if strAuthType = "db" then if Request.Form("Name")<>"" then strSql = strSql & " WHERE M_NAME = '" & ChkString(Request.Form("Name"),"name") & "' " strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.Form("Password"),"password") & "'" else strSql = strSql & " WHERE M_NAME = '" & ChkString(Request.querystring("Name"),"name") & "' " strSql = strSql & " AND M_PASSWORD = '" & ChkString(Request.querystring("Password"),"password") & "'" end if end if
Topic Locked
Posted - 26 April 2001 : 09:39:37
