Article View: dk.edb.database
Article #21Re: expects the parameter '@P2', which was not supplied
From: Leif Neland
Date: Thu, 08 Mar 2012 20:56
Date: Thu, 08 Mar 2012 20:56
24 lines
2017 bytes
2017 bytes
Den 08-03-2012 21:27, Arne Vajh�j skrev:
>
> Hvorfor ikke pr�ve:
>
> sql="select * from t_basket where basketSession=@ses and prodID=@id"
> .CreateParameter("@ses",adChar,adParamInput,50,sessid)
> .CreateParameter("@prod",adInteger,adParamInput,,productID)
>
> om ikke andet s� er koden da nemmere at l�se!
S�dan virker det ikke med ADODB og vbscript/classic asp
Must declare the scalar variable "@ses".
Det _skal_ v�re ?
> Og pr�v evt. at create parametre uden v�rdi og s� s�tte v�rdi senere.
>
G�r ingen forskel.
Det fungerer, hvis jeg kun bruger een parameter, men det er nok ikke s�
smart at alle kunder bruger den samme kurv :-(
Leif
Technical Details
Message-ID:
<4f591cf1$0$291$14726298@news.sunsite.dk>Path:
arc1-ca.pugleaf.net!h9ni3692pbe.0!nntp.google.com!news2.google.com!news.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mailReferences:
<4f58d7e7$0$295$14726298@news.sunsite.dk> <4f58e007$0$282$14726298@news.sunsite.dk> <4f590a23$0$293$14726298@news.sunsite.dk> <4f591651$0$294$14726298@news.sunsite.dk>Show Full Headers
Complete Article Headers
X-Google-Thread: fcdf9,6e431ff705133bc8
X-Google-NewGroupId: yes
X-Google-Attributes: gid5233a24ee9,domainid0,public,usenet
X-Google-Language: DANISH,ASCII
Received: by 10.68.135.231 with SMTP id pv7mr282807pbb.8.1331240178208;
Thu, 08 Mar 2012 12:56:18 -0800 (PST)
Path: arc1-ca.pugleaf.net!h9ni3692pbe.0!nntp.google.com!news2.google.com!news.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Thu, 08 Mar 2012 21:56:21 +0100
From: Leif Neland <leif@neland.dk>
User-Agent: Mozilla/5.0 (Windows NT 6.0; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: dk.edb.database
Subject: Re: expects the parameter '@P2', which was not supplied
References: <4f58d7e7$0$295$14726298@news.sunsite.dk> <4f58e007$0$282$14726298@news.sunsite.dk> <4f590a23$0$293$14726298@news.sunsite.dk> <4f591651$0$294$14726298@news.sunsite.dk>
In-Reply-To: <4f591651$0$294$14726298@news.sunsite.dk>
Lines: 24
Message-ID: <4f591cf1$0$291$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 94.18.45.10
X-Trace: news.sunsite.dk DXC=akC7RVgIIkEhAD6WOTE2YEYSB=nbEKnkKR3J>`Eg\V_G<94hk=?Wd0ER1jl;eGK1KCmIOfX9Af6NGBUGeAg>L3[M
X-Complaints-To: staff@sunsite.dk
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit