i Have these code ' Prepare the SQ

[fireburner69]

i Have these code
' Prepare the SQL insert command
cmdSQLinsert = "insert into books (name, info, link, price, weight, pid, category) values ('" & strname & "','" & strinfo & "','" & strlink & "','" & strprice & "','" & strweight & "','" & strpid & "','" & strcategory & "')"

' Execute the SQL insert command
objConn.Execute cmdSQLinsert

' Close and clean up
Set objConn = Nothing

and when i run the script and enter submit these error comes up!


Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/sales/admin/bupdate.asp, line 61



line 61 is objConn.Execute cmdSQLinsert


why these is? and what can i do to fix it?

I use win2000 Adv. Server! with updated ado!

 

[Herminio]

try this

' Execute the SQL insert command
objConn.Execute(cmdSQLinsert)


hope it helps

 

[fireburner69]

The same problem! my worries are that when i had win98 and pws it was working! what happened now!
do i do soimething wrong!

 

[Tarwn]

Print out your SQL string to the browser without executing it to make sure everything is coming out ok. If that looks fine than try doing a select fro mthe ame table to see if that works. I apologize, but I know I have seen that exact error before, I just haven't managed to remember the circumstances. If I wake up a little more and remember I will post it.
-Tarwn The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea
-computer saying (Wiz Biz - Rick Cook)