[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