logo

Previous Thread
Next Thread
Print Thread
problem when execute code #189610 04/23/05 08:36 AM
Joined: Apr 2005
Posts: 1
N
NooRPal Offline OP
Newbie
OP Offline
Newbie
N
Joined: Apr 2005
Posts: 1
i have this connection and event whos should be done in asp

[color:"red"]
<%@ Language=VBScript CodePage = "1256"%>

<!--#include file="connection.txt" -->

<%
name = request.form ("name")
email = request.form ("email")
country = request.form ("country")
cFound = request.form ("cFound")
instit = request.form ("instit")
subject = request.form ("subject")
comments = request.form ("comments")

addSQL= " insert into feedback (name,email,country,cFound,instit,subject,comments) values ('"&name&"','"&email&"','"&country&"','"&cFound&"','"&instit&"','"&subject&"','"&comments&"') "
ADO.execute(addSQL)

response.redirect "feedback.asp"

ADO.close

%>
[/color]

i get this error
[color:"red"]
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/multaqa/add_to_feedback.asp, line 15
[/color]

Re: problem when execute code #189611 04/25/05 07:32 PM
Joined: Jan 2004
Posts: 22,776
Lisa LowCarb Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
Offline
BellaOnline Editor
Highest Posting Power Known to Humanity
Joined: Jan 2004
Posts: 22,776
You don't give ANY information there <img src="/images/graemlins/smile.gif" alt="" /> All you give is the SQL text line, and then an execute statement. You don't say at all how you set up the ADO object which is what the error is saying. It's saying that you are not setting up the object properly to do an update style statement on your database.

Also, just what is the key of that table??? I don't see anything in there that could be a key, unless you have a Unique ID field on that table?


Lisa Shea, Low Carb and Video Games Editor
Low Carb Forum

Moderated by  Lisa LowCarb 

Brand New Posts
Astro Advent 2020
by Mona - Astronomy - 12/01/20 12:08 AM
When does Christmas Season End?
by Angie - 11/30/20 11:54 PM
2020: On this day . . .
by Mona - Astronomy - 11/30/20 01:50 PM
Container Gardening TIP OF THE DAY
by Lestie4containergardens - 11/30/20 05:59 AM
Advent 2020
by Angie - 11/29/20 05:23 PM
Native American Heritage Month
by Angela - Drama Movies - 11/29/20 01:25 AM
Thanksgiving and Gratitude
by Angie - 11/28/20 01:36 PM
Meanwhile in Canada
by Angie - 11/28/20 01:34 PM
Thanksgiving in Space
by Angie - 11/28/20 01:30 PM
The Solar System - for Kids & Others
by Mona - Astronomy - 11/28/20 12:39 PM
Privacy
This forum uses cookies to ensure smooth navigation from page to page of a thread. If you choose to register and provide your email, that email is solely used to get your password to you and updates on any topics you choose to watch. Nothing else. Ask with any questions!
Channel List
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies
Safety
We take forum safety very seriously here at BellaOnline. Please be sure to read through our Forum Guidelines. Let us know if you have any questions or comments!
Sponsor


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2020 Minerva WebWorks LLC. All rights reserved.


Powered by UBB.threads™ PHP Forum Software 7.7.3