[thelist] returning output from MSSQL to vbscript

Ian Anderson ian at zstudio.co.uk
Tue Apr 18 14:14:09 CDT 2006


Canfield, Joel wrote:
> Is it obvious to anyone why this
> 
>   strQuery = strDeclarations & "EXEC @RC = spAddTask '(" & strColumns &
> ")', '" & strValues & "', @WorkOrderNumber OUTPUT"
>   Set NewWorkOrder = cnxW.Execute(strQuery)
>   intNewWO_NUM = NewWorkOrder("@WorkOrderNumber")
> 

Just a guess, but surely the column name in the recordset should be 
"WorkOrderNumber"  - i.e., no "@"?


-- 
zStudio - Web development and accessibility
- http://zStudio.co.uk
Snippetz.net - Your personal, private code library
- http://snippetz.net




More information about the thelist mailing list