Wrong Update

grstad · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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..?