Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manu
Starting Member
41 Posts |
 Posted - 2005-10-19 : 02:28:51
|
| hello sir,i am having problem in passing input parameter(integer) to stored proceedure in asp.Pls help me |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-19 : 02:32:37
|
| What error message you getting when calling the stored procudure through ASP?RegardsSachin Samuel |
 |
|
|
manu
Starting Member
41 Posts |
Posted - 2005-10-19 : 02:38:22
|
| Dear Sir,i am sending the code for just one parameter.in sql stored proceedure, i have defined parameter as @ agentid intand check sntax is ok.set parvalue=cmd.Createparameter ("@agentid",adInt, adparaminput,4,"&userid&") cmd.parameters.append parvalueerrorApplication uses a value of the wrong type for the current operation. |
|
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-10-19 : 03:06:31
|
| I think you have forgot to include "adovbs.inc" file in your page. Please include by giving virtual or physical path in the asp page.RegardsSachin Samuel |
|
|
|
manu
Starting Member
41 Posts |
Posted - 2005-10-19 : 03:13:25
|
| i have included the file adovbs.inc |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
manu
Starting Member
41 Posts |
Posted - 2005-10-19 : 03:44:33
|
| ok sir,i have got my problem. it was just syntax error.Thanks a lot for your help.Munish Gupta |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
problem in passing input parameter(integer) to sto