Skip to main content
Known Participant
December 21, 2006
Question

Prepared statement Error

  • December 21, 2006
  • 2 replies
  • 335 views
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,
This topic is closed to new replies. Start a new post to keep the conversation going.

2 replies

Feras_86Author
Known Participant
January 5, 2007
thx again :)
Inspiring
January 2, 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,
>
>