Wrong Update

grstad · #1 (**permalink**) March 4th, 2006, 08:56 AM

Hei igjen!

What is wrong widt my update?

Teknisk informasjon (for kundestøttepersonell)

Feiltype:
Microsoft VBScript-kompileringsfeil (0x800A0401)
Forventet slutt på setning (expected end)

objComm.CommandText = "UPDATE Produkter SET hoyde = 'hoyde', haar = 'haar', oye = 'oye', vekt = 'vekt' " & "WHERE e_post LIKE 'session("epost")'"
---------------------------------------------------------------------------------------------------------------------------------------^

adam_kahtava · #2 (**permalink**) March 4th, 2006, 09:39 AM

Try these changes...

objComm.CommandText = "UPDATE Produkter SET hoyde = 'hoyde', haar = 'haar', oye = 'oye', vekt = 'vekt' WHERE e_post LIKE '" & session("epost") & "';"

If that doesn't help take a look at this link: http://www.adopenstatic.com/faq/80040e10.asp

- A.Kahtava

grstad · #3 (**permalink**) March 4th, 2006, 11:13 AM

Hei A. Kahtava

Thank you for answering.

Your suggestion braught me a bit further down the road, but an error msg. says;

Feiltype:
Microsoft VBScript-kjøretidsfeil (0x800A01B6)
Objektet støtter ikke angitt egenskap eller metode: 'CommandText'
(The object do not support the property or method: 'CommandText')

The lines of script (UPDATE) is taken from the book ASP 3.0 (Wrox)
page 580.

Do I have the right ADO-stuff on my disk? Does ADO have anything to do width this. As you understand I have a great deal to learn.

Mvh grstad

adam_kahtava · #4 (**permalink**) March 4th, 2006, 09:09 PM

ADO is associated with this error.
Could you please post the source code that is causing the error, I don't have the ASP 3.0 book on hand.

Here's a previous posting with a similar error: http://p2p.wrox.com/topic.asp?TOPIC_ID=10024

- A.Kahtava

grstad · #5 (**permalink**) March 7th, 2006, 07:26 AM

<% option explicit
dim kobling
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
    <title>registrering_2_mann_sjekk</title>
</head>

<body>

<%

'Why does this code not update the record in my access db?

If Request.QueryString("snekker") = "on" Then 'checkbox

        dim objComm
        set objComm = server.createobject("ADODB.Command")

    objComm.ActiveConnection = kobling
    objComm.CommandText = "UPDATE Produkt SET ProduktSnekker = 'snekker' WHERE ProduktNavn LIKE '" & session("innsjekknavn") & "';"

    Set objComm = Nothing

    Else

end if

response.redirect "registrering_3_mann.asp"

%>

</body>

</html>

grstad · #6 (**permalink**) March 10th, 2006, 07:04 AM

Hallo!

I am wondering; is it not possible to update an excisting record
in an Access-db by making use of ASP? Or can it be the OleDB-thing?

I have tryed by the book 3.0, (also the objRs("something").value = "something")

But is INSERT INTO with a WHERE worth trying?

Med vennlig hilsen
grstad

ChrisScott · #7 (**permalink**) March 10th, 2006, 10:23 AM

It is possible to update access dbs from asp.

Can you post your code and any errors you are getting, please?

Cheers,

Chris

grstad · #8 (**permalink**) March 10th, 2006, 01:55 PM

Hallo Chris!

Thank you for your willingness!

This is the code in question, followed by the error-msg;

<% option explicit
dim kobling
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
    <title>registrering_2_mann_sjekk</title>
</head>

<body>

<%

dim objRs

set objrs = server.createobject("ADODB.recordset")

objrs.open "select * from Produkt where ProduktNavn = " & session("ProduktNavn"), kobling, adopenforwardonly, adLockpessimistic, adCmdText

        objrs("ProduktSnekker").value = Request.form ("snekker")
        objrs("ProduktMale").value = Request.form("male")

        objrs.Update

    objrs.close

    set objrs = nothing

    response.redirect "registrering_3_mann.asp"
%>

</body>

</html>

HTTP 500.100 - Intern serverfeil – ASP-feil
Internet Information Services

--------------------------------------------------------------------------------

Teknisk informasjon (for kundestøttepersonell)

Feiltype:
Microsoft JET Database Engine (0x80040E10)
Det er ikke angitt verdi for en eller flere nødvendige parametere.
/innsjekk/registrering_2_mann_sjekk.asp, linje 21

Med vennlig hilsen

grstad

ChrisScott · #9 (**permalink**) March 10th, 2006, 02:11 PM

Hi grstad,

It looks like you have your browser set to return friendly error messages, can you turn this off & then post the error message you get.

In IE this can be found at Tools -> Internet Options -> Advanced -> Browsing -> Show friendly HTTP error messages

Thanks,

Chris

grstad · #10 (**permalink**) March 10th, 2006, 02:29 PM

...it seems to be the only error I have. Does the
.value be recognized when there is no method attached to
objRs..?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
update multiple columns in an update statement	debbiecoates	SQL Server 2000	1	August 17th, 2008 04:01 AM
Update link doesn't update in FormsView	shaly	ASP.NET 2.0 Basics	0	December 6th, 2006 04:33 PM
What's wrong with Update	grstad	Classic ASP Databases	4	March 8th, 2006 04:30 AM
Datagrid.update() and DataAdapter.Update	aarunlal	ASP.NET 2.0 Professional	2	February 23rd, 2006 11:41 PM
What is wrong with this update statment ?	method	SQL Server 2000	2	April 23rd, 2005 04:45 AM