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 |
|
Shaun McGuile
Starting Member
3 Posts |
 Posted - 2007-09-13 : 10:56:34
|
| Hi,just wodered if anybody else ecer had this issue....I have used javascript to build an ADODB connection and command objects (correctly as they work fine on two out of three sites).When I try to use the following codeproductId = 918; //previouly declared variablecmdTemp.Parameters.Append(cmdTemp.CreateParameter("@Id", adInteger, adParamInput, 4, productId));The code fails.It works on two out three websites where it has been deployed.I have checked SQL Server in all three cases and the databases are all the same content and metadata wise.Is there anything else I might have missed?regards,Fix the problem, not the blame! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-13 : 11:06:28
|
| and the error you get is?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Shaun McGuile
Starting Member
3 Posts |
Posted - 2007-09-13 : 11:16:49
|
| Doh! its wrapped in try...catch to stop error messaging on the third platform.Give me some time and I'll get it.Sorry for bothering you with this.Fix the problem, not the blame! |
|
|
|
|
|
|
Parameter.Append fails