|
 |
asp_databases thread: 0x80004005 operation must use an updatable query
Message #1 by "Pathik Thakkar" <pathikthakkar1@n...> on Fri, 23 Nov 2001 09:33:13 +0530
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0157_01C17401.DF7942E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi friends,
when i try to insert a record in the access table using the following
syntax, it gives me the error:
0x80004005 Operation Must be an updatable query!!
this is the syntax...
dim con
dim sqlText
set con =3D Server.createObject ("Adodb.connection")
con.open "ksschool"
set userset =3D server.createobject ("adodb.recordset")
userset.open "select * from feedback",con,,3
sqlText =3D "insert into feedback"
sqlText =3D sqlText & " values ('" & request.form("cmpname") & "','"
sqlText =3D sqlText & request.form ("persname") & "','" & request.form
("emailaddr")
sqlText =3D sqlText & "','" & request.form ("designation") & "','"
sqlText =3D sqlText & request.form ("feedback") & "')"
set resp =3D con.execute(sqlText)
Thanx for the help in advance!!!
Pathik Thakkar
Message #2 by David Cameron <dcameron@i...> on Mon, 26 Nov 2001 09:11:50 +1100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C175FE.2FF6CDF2
Content-Type: text/plain;
charset="iso-8859-1"
Replace
set resp = con.execute(sqlText)
with
con.execute sqlText
regards
David Cameron
nOw.b2b
dcameron@i...
> -----Original Message-----
> From: Pathik Thakkar [mailto:pathikthakkar1@n...]
> Sent: Friday, 23 November 2001 2:03 PM
> To: ASP Databases
> Subject: [asp_databases] 0x80004005 operation must use an updatable
query
>
> Hi friends,
>
> when i try to insert a record in the access table using the following
syntax, it gives me the error:
>
> 0x80004005 Operation Must be an updatable query!!
>
> this is the syntax...
>
> dim con
> dim sqlText
> set con = Server.createObject ("Adodb.connection")
> con.open "ksschool"
>
> set userset = server.createobject ("adodb.recordset")
> userset.open "select * from feedback",con,,3
>
> sqlText = "insert into feedback"
> sqlText = sqlText & " values ('" & request.form("cmpname") & "','"
> sqlText = sqlText & request.form ("persname") & "','" & request.form
("emailaddr")
> sqlText = sqlText & "','" & request.form ("designation") & "','"
> sqlText = sqlText & request.form ("feedback") & "')"
>
> set resp = con.execute(sqlText)
>
>
> Thanx for the help in advance!!!
> Pathik Thakkar
>
>
$subst('Email.Unsub')
>
Message #3 by "Drew, Ron" <RDrew@B...> on Mon, 26 Nov 2001 13:41:41 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C176A9.FD8F1D90
Content-Type: text/plain
I would be explicit as to the columns being updated ie. insert into
feedback (column1, column2 etc) values (1,2,3,4)
Also comment out the execute line and add a response.write sqlText just
before the execute to see what the statement looks like then if OK just
uncomment the execute and let it rock and roll
-----Original Message-----
From: Pathik Thakkar [mailto:pathikthakkar1@n...]
Sent: Thursday, November 22, 2001 11:03 PM
To: ASP Databases
Subject: [asp_databases] 0x80004005 operation must use an updatable query
Hi friends,
when i try to insert a record in the access table using the following
syntax, it gives me the error:
0x80004005 Operation Must be an updatable query!!
this is the syntax...
dim con
dim sqlText
set con = Server.createObject ("Adodb.connection")
con.open "ksschool"
set userset = server.createobject ("adodb.recordset")
userset.open "select * from feedback",con,,3
sqlText = "insert into feedback"
sqlText = sqlText & " values ('" & request.form("cmpname") & "','"
sqlText = sqlText & request.form ("persname") & "','" & request.form
("emailaddr")
sqlText = sqlText & "','" & request.form ("designation") & "','"
sqlText = sqlText & request.form ("feedback") & "')"
set resp = con.execute(sqlText)
Thanx for the help in advance!!!
Pathik Thakkar
$subst('Email.Unsub')
Message #4 by "Tomm Matthis" <matthis@b...> on Mon, 26 Nov 2001 15:49:49 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0018_01C17691.FB097100
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
MessageAlso, you don't need a recordset object to do a SQL insert...
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: Monday, November 26, 2001 1:42 PM
To: ASP Databases
Subject: [asp_databases] RE: 0x80004005 operation must use an updatable qu
ery
I would be explicit as to the columns being updated ie. insert into
feedback (column1, column2 etc) values (1,2,3,4)
Also comment out the execute line and add a response.write sqlText just
before the execute to see what the statement looks like then if OK just
uncomment the execute and let it rock and roll
-----Original Message-----
From: Pathik Thakkar [mailto:pathikthakkar1@n...]
Sent: Thursday, November 22, 2001 11:03 PM
To: ASP Databases
Subject: [asp_databases] 0x80004005 operation must use an updatable
query
Hi friends,
when i try to insert a record in the access table using the following
syntax, it gives me the error:
0x80004005 Operation Must be an updatable query!!
this is the syntax...
dim con
dim sqlText
set con = Server.createObject ("Adodb.connection")
con.open "ksschool"
set userset = server.createobject ("adodb.recordset")
userset.open "select * from feedback",con,,3
sqlText = "insert into feedback"
sqlText = sqlText & " values ('" & request.form("cmpname") & "','"
sqlText = sqlText & request.form ("persname") & "','" & request.form
("emailaddr")
sqlText = sqlText & "','" & request.form ("designation") & "','"
sqlText = sqlText & request.form ("feedback") & "')"
set resp = con.execute(sqlText)
Thanx for the help in advance!!!
Pathik Thakkar
$subst('Email.Unsub')
$subst('Email.Unsub')
|
|
|
View Cart
