ASP Code Problem

Have you tried pulling data out of the database? I don't see anything here, but....

Maybe try this and see if you get a different result:

Replace these lines in your code:
-------------------------------------
Set rs = server.createobject("adodb.recordset")

rs.open "user",cn
rs.addnew
rs("email") = Email
rs("fname") = FName
rs("lname") = LName
rs.update

rs.close
Set rs = nothing

With:
-------------------------------------
DIM strSQL
Set rs = Server.CreateObject("ADODB.Connection")
rs.Open conn

strSQL = ""
strSQL = strSQL & "INSERT INTO user "
strSQL = strSQL & "(fname, lname, email) " & vbCrLf
strSQL = strSQL & "VALUES ("
strSQL = strSQL & "'" & fname & "'"
strSQL = strSQL & ", "
strSQL = strSQL & "'" & lname & "'"
strSQL = strSQL & ", "
strSQL = strSQL & "'" & email & "'"
strSQL = strSQL & ");"

rs.Execute strSQL, adCmdText Or adExecuteNoRecords

rs.Close
Set rs = Nothing

 

I inserted your code and at least it's throwing a different error message

Error Type:
ADODB.Connection (0x800A0E79)
Operation is not allowed when the object is open.

I hope this means we are getting close

 

fixed that error, but now getting

Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'user'.
/mine/testsignup.asp, line 67

line 67 is
rs.Execute strSQL, adCmdText Or adExecuteNoRecords

 

got it... your code worked perfectly!

I owe you many thanks and a six pack of your favorite beer!

 

any guesses as to why the original code didn't work? I am VERY happy with code that works but knowing where I made the initial mistake is helpful to the learning process.

Once again THANK YOU!!!!!!!

 

I don't know. As far as code goes, I exhausted all my knowledge on the ideas that didn't work.

 

try to use conn.execute("sql commands")