[thelist] SQL INSERT Trouble...

bread_man bread_man at hotmail.com
Sun Feb 24 08:40:01 CST 2002


Doh. I'm a moron.  The database didn't have correct read / write
permissions.  Sorry to waste your time!
adam

----- Original Message -----
From: "Adam Slesinger" <bread_man at hotmail.com>
To: <thelist at lists.evolt.org>
Sent: Sunday, February 24, 2002 2:35 PM
Subject: [thelist] SQL INSERT Trouble...


> 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 world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !
>



More information about the thelist mailing list