strange ADODB problem

[tjw2006]

Hi, am using classic ASP and am trying to execute a stored procedure using ADODB. I'm using a command object and assigning parameters to it, however the stored procedure isn't accepting values from the parameters if they're derived from variables, if I key in the value of the parameter directly, then the value gets passed onto the stored procedure. I've tried printing out to the screen the value of the parameters when I've assigned them to variables and they are showing the correct values, it's just the stored procedure won't accept them! Any ideas?

Thanks

 

[Turkbear]

Hi,
Are you reloading the page before calling the procedure - it is possible the variables are not actually populated until the reload action.





To Paraphrase:"The Help you get is proportional to the Help you give.."