This is what i don't get i used this EXACT same code just changed the Request.Form names and the Table names and this is what i get:
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/dev/traderfeedback/post_succ.asp, line 69
Line 69 Would be
rsIU.execute(strSql)
Here is the Full SQL Statement
set rsIU=Server.Createobject("ADODB.Connection")
rsIU.open(strConnString)
Function lString(string)
if string = "" then string = " "
lString = Replace(string, "'", "''")
End Function
'REGISTER SQL
strSql = "INSERT INTO USER ([U_NAME],[UA_IP]) VALUES(" & _
"'" & lString(Request.Form("UA_IP")) & "'," & _
"'" & lString(Request.Form("UNAME")) & "')"
rsIU.execute(strSql)
Response.Write("<h1 align=""center"">Welcome!</h1>")
Response.Write "<h3 align=""center"">Thank you for choosing **************.com you may now log in with your new" & vbNewline & _
"Login ID and Password" & VbNewLine
rsIU.close
set rsIU = nothing
I include the files:
<!--#INCLUDE File="./config.asp" -->
<!--#INCLUDE File="./inc_functions.asp" -->
<!--#INCLUDE FIle="./inc_top.asp" -->
NOTE: I use the final version where Passwords are not encoded because i use the base snitz code for the site... I think it is like 3.0 Final
I don't get the site the same page sometimes i will have to do the rs.open(strConnString) and all of that jubberish. I should only have to do rs.execute(strsql) after the statment or rs.open strsql, my_conn after the statement... I am confused
When i add
Response.Write(strSql)
I get this
INSERT INTO USER ([U_NAME],[UA_IP]) VALUES(' ','0')
Topic Locked
Posted - 04 January 2005 : 19:29:33
