Fejlvisende fejlbesked ved parameterized query

Thread View: dk.edb.internet.webdesign.serverside.asp

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Leif Neland Mon, 05 Dec 2011 13:10

#145

Author: Leif Neland
Date: Mon, 05 Dec 2011 13:10

25 lines
2039 bytes

    set oOrdre=Server.CreateObject("ADODB.command")
    oOrdre.ActiveConnection = conn
    with oOrdre
     Sql = "Update ordrer set ordretotal=?, betaling=? where id=?"
     .CommandText = sql
     .CommandType = adCmdText
     .parameters.Append 
.CreateParameter("ordretotal",adCurrency,adParamInput,,orderTotal)
     .parameters.Append 
.CreateParameter("betaling",adInteger,adParamInput,,intBetaling)
     .parameters.Append 
.CreateParameter("id",adInteger,adParamInput,,OrdreId)
     .prepared = true
     .execute
    end with

Hvis intBetaling er null f�s denne fejlbesked:

The parameterized query '(@P1 money,@P2 int,@P3 int)Update t_ordrer set 
ordretotal=@P1, b' expects the parameter '@P3', which was not supplied.

Hvorfor P3?! Det er P2, der mangler. Eller bliver der bare fyldt ud fra 
begyndelsen indtil input slipper op?

Leif

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads