codetoad.com
  ASP Shopping CartForum & BBS
  - all for $20 from CodeToad Plus!
  
  Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM 
Search Site:
Search Forums:
  help try to update parameters in sql server with Stored Procedure in ASP  Rachel at 11:20 on Wednesday, June 20, 2007
 

I try to update parameters of type int that can be null in DB but if the field is empty in asp I get an error when I send it to Stored Procedure if I remove this parameter its working fine
but the problem is when I send int with no value
please help I am stuck


Set param = cmd.CreateParameter("access_id", 3, 1,4, Request("access_id"))
cmd.Parameters.Append param



  Re: help try to update parameters in sql server with Stored Procedure in ASP  partha at 01:23 on Tuesday, February 24, 2009
 

You can use default parameter value in SP to avoid this error. To read more go to
http://shawpnendu.blogspot.com/2009/02/how-to-read-data-from-sql-server-stored.html








CodeToad Experts

Can't find the answer?
Our Site experts are answering questions for free in the CodeToad forums








Recent Forum Threads
•  converting JAVA code to JSP
•  image and form fieild upload problem
•  Multiplying currency
•  Java Garbage Collection Boot Camp
•  validations fo form fields
•  Setting page size at which scroll bars appear in browser window (javascript)
•  before executing a function
•  how to write a code in asp.net to create a glossary .
•  I am trying to run a programme which is using PGPLOT.When I call it from browser I get following error message.


Recent Articles
ASP GetTempName
Decode and Encode UTF-8
ASP GetFile
ASP FolderExists
ASP FileExists
ASP OpenTextFile
ASP FilesystemObject
ASP CreateFolder
ASP CreateTextFile
Javascript Get Selected Text


© Copyright codetoad.com 2001-2010