On 19/12/2007, at 12:59 AM, Rajesh nair wrote:
This code crashes when I do a ns_db select with SQL = “Exec procedure> @params”.
Crash is such a harsh word, don't you mean "throws an error"? I bet
the error is "... is not a statement returning rows" or similar.
I can do a ns_db exec “exec @pa
-Original Message-
From: AOLserver Discussion [mailto:[EMAIL PROTECTED] On Behalf Of
Bas Scheffers
Sent: Tuesday, December 18, 2007 8:26 AM
To: AOLSERVER@LISTSERV.AOL.COM
Subject: Re: [AOLSERVER] ns_db sp_* API not working with MS SQL server 2005
I don't know the ns_db sp_* functi
I don't know the ns_db sp_* functions, but you can get return values
in other ways.
First of all, there is nothing stopping you from executing a big chunk
of T-SQL in "ns_db select". You could easily execute the stored proc
using exec and the trick to getting the output values is to not use
Hi,
I am trying to use the ns_db sp_* API in AOLServer 4.0 with nsfreetds driver
against MS SQL Server 2005.
I can tell that the driver are all set fine as I can execute Select SQLs
correctly from ADP
But I am unable to call a stored procedure passing in a paramater and
retrieveing the result f