expects the parameter '@P2', which was not supplied

Article View: dk.edb.database

Article #17

#17

From: Leif Neland
Date: Thu, 08 Mar 2012 16:01

30 lines
2217 bytes

jeg mener jeg g�r dette efter bogen, men det virker ikke.
Begge parametre (sessid og productID) findes.

set oProd1=Server.CreateObject("ADODB.command")
with oProd1
     .ActiveConnection = Record
     sql="select * from t_basket where basketSession=? and prodID=?"
     .CommandText = sql
     .CommandType = 1 ' adCmdText
     .parameters.Append 
.CreateParameter("ses",adChar,adParamInput,50,sessid)
     .parameters.Append 
.CreateParameter("prod",adInteger,adParamInput,,productID)
     .prepared = true
     set rsSeKurv= .execute
end with

Jeg f�r fejlen.
The parameterized query '(@P1 char(50),@P2 int)select * from t_basket where 
basketSession' expects the parameter '@P2', which was not supplied.

Bytter jeg om p� de to parametre i b�de sql og parameters.Append, er det 
_stadig_ @P2, der mangler.
The parameterized query '(@P1 int,@P2 char(50))select cnt from t_basket 
where prodID=@P1 ' expects the parameter '@P2', which was not supplied.

Jeg mener at fejlen i virkeligheden betyder noget andet end man skulle tro, 
men jeg kan ikke huske det...

Leif

Technical Details

Message-ID: <4f58d7e7$0$295$14726298@news.sunsite.dk>

Path:

arc1-ca.pugleaf.net!h9ni2921pbe.0!nntp.google.com!news2.google.com!news.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fcdf9,6e431ff705133bc8,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid5233a24ee9,domainid0,public,usenet
X-Google-Language: DANISH,ASCII
Received: by 10.68.227.166 with SMTP id sb6mr5671013pbc.4.1331222504426;
        Thu, 08 Mar 2012 08:01:44 -0800 (PST)
MIME-Version: 1.0
Path: arc1-ca.pugleaf.net!h9ni2921pbe.0!nntp.google.com!news2.google.com!news.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
From: "Leif Neland" <leif@neland.dk>
Newsgroups: dk.edb.database
Subject: expects the parameter '@P2', which was not supplied
Date: Thu, 8 Mar 2012 17:01:43 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Original
Lines: 33
Message-ID: <4f58d7e7$0$295$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 83.92.199.126
X-Trace: news.sunsite.dk DXC=U]0P\lV_g5iOHBD=iT>F;gYSB=nbEKnkkJ:BbKlQ?o@l<94hk=?Wd0ekilkTO:]WBc=c\k1Tgl@eh_AIB:^1Fj_lFQniZF161`a
X-Complaints-To: staff@sunsite.dk