[thelist] SQL INSERT Trouble...
Adam Slesinger
bread_man at hotmail.com
Sun Feb 24 08:35:00 CST 2002
Hi All. I'm seting up my first database and am having trouble with
inserting a new row into my table. I'm using asp on IIS with a msaccess db.
I've grabbed and displayed records in my page just fine, but when i try
and update the table with a new row, I get this error message from IE6:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/registration.asp, line 58
Here is the syntax I used:
SQL="INSERT INTO register (Name, Email, Handle, Clan, Age, Region, Agree,
Game01, Game02, Game03, Quote, Secured) VALUES ("
SQL=SQL & "'" & strName & "', "
SQL=SQL & "'" & strEmail & "', "
SQL=SQL & "'" & strHandle & "', "
SQL=SQL & "'" & strClan & "', "
SQL=SQL & "'" & strAge & "', "
SQL=SQL & "'" & strRegion & "', "
SQL=SQL & "'" & strAgree & "', "
SQL=SQL & "'" & strGame01 & "', "
SQL=SQL & "'" & strGame02 & "', "
SQL=SQL & "'" & strGame03 & "', "
SQL=SQL & "'" & strQuote & "', "
SQL=SQL & "'" & strSecured & "')"
set conn = server.createobject("ADODB.Connection")
conn.open "register"
set signedup=conn.execute(SQL)
I thought the syntax loooked OK - can anyone figure out what I'm doing
wrong? I'm still new to this and the error messages can be a little
cryptic.
Thanks so much!!
ada aka bread_man
http://www.thebadlans.net
_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
More information about the thelist
mailing list