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
• C++
• Re: refresh parent after closing pop up window
• Dynamic Insertion
• Date and Time function around the world???
• Significant Factors
• Perl array access
• Re: huffman encoding and decoding in C++...
• Perl One Liner: Replace {(
• Re: html including php, accessing the functions


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-2009