Re: Return value from Stored Procedure

Hi Bob,

That does it, but why?

Thanks a billion, you just save my life:).

Bob Barrows [MVP] wrote:
Light wrote:

CREATE Procedure NewCompany
(
@varCompanyName varchar (50) = null,


@RETURN_VALUE int OUTPUT
)
As


You need to add "SET NOCOUNT ON" to this procedure - right here as a matter of fact.
.

Relevant Pages

  • Re: Component with XML island
    ... MVP .Net France ... "Bob Barrows " wrote: ... so the .asp groups deal with server-side code. ... > on a scripting newsgroup, or one of the groups in the .xml hierarchy. ...
    (microsoft.public.inetserver.asp.general)
  • Re: value of checked box!?
    ... Bob Barrows wrote: ... was one of the major computer news sites -- ZDNet perhaps? ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: value of checked box!?
    ... Bob Barrows wrote: ... was one of the major computer news sites -- ZDNet perhaps? ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Component with XML island
    ... MVP .Net France "Bob Barrows " wrote:> As you are talking about client-side components and functionality, ... > still off-topic on an ASP newsgroup, which is mainly focused on server-side> technology. ... The email account listed in my From>>> header is my spam trap, so I don't check it very often. ...
    (microsoft.public.inetserver.asp.general)
  • Re: dynamic table content?
    ... Bob Barrows wrote:> I suppose you could open the specified file using fso and> response.write its contents: ... > CONST ForReading = 1 ... > pagename = request.quesrystring> ... Microsoft MVP -- ASP/ASP.NET ...
    (microsoft.public.inetserver.asp.general)