I might have worked without the outputs as well.

>>I will admit that I am a lot more familiar with Sql Anywhere then Sql Server but I would call the sp this way
>>=mySQLExec("execute dbo.siriussp_rsGetBlocks @TemplateID = ?m.nTemplateID,?@nBlockCount, ?@nSeatsCount , 'rsTSBlocks'",program())
>>
>>Seems to me that if you pass a variable by reference then the value would be returned by the SP. I thought "output" was part of the parameter statement of the SP. Anyway, the above is how I would do this is Sql Anywhere.
>>
>This worked. Strange, but my original way (using named parameters) worked fine in one DB and didn't work in another. I tested it right now in working DB and after I made all parameters to be non-named, it worked.