Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Prepared statement Error

New Here ,
Dec 21, 2006 Dec 21, 2006
Hello

i have a register form , and it's working normaly. but sometimes i get this error :
Prepared statement '(@FName varchar(50),@LName nvarchar(50),@PrefixID tinyint,@DOB d' expects parameter @Picture, which was not supplied.

i'm using ASP.NET( vb) and SQL SErver 2000
thx guys
Feras,
TOPICS
Server side applications
327
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 02, 2007 Jan 02, 2007
Your Stored Procedure is expecting a variable to be passed called @Picture
which is not in the your input form. You need to modify the Procedure if the
field is not required or supply a value from the page.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"Feras_86" <webforumsuser@macromedia.com> wrote in message
news:emf5ng$ath$1@forums.macromedia.com...
> Hello
>
> i have a register form , and it's working normaly. but sometimes i get
> this
> error :
> Prepared statement '(@FName varchar(50),@LName nvarchar(50),@PrefixID
> tinyint,@DOB d' expects parameter @Picture, which was not supplied.
>
> i'm using ASP.NET( vb) and SQL SErver 2000
> thx guys
> Feras,
>
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jan 04, 2007 Jan 04, 2007
LATEST
thx again :)
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines