ASP & SProc Question...

Results 1 to 2 of 2

Thread: ASP & SProc Question...

  1. #1
    Join Date
    Dec 1969

    Default ASP & SProc Question...

    If I use some ADO code that runs a SQL Stored Procedure that looks like...<BR><BR> SELECT<BR> instid,<BR> relationship<BR> FROM ahadb.dbo.instaha<BR> WHERE instid = @ID<BR><BR> IF @@ROWCOUNT = 0<BR> BEGIN<BR> INSERT INTO ahadb.dbo.instaha<BR> ( <BR> instid,<BR> ahacd,<BR> relationship<BR> )<BR> VALUES<BR> (<BR> @ID, <BR> @AHAID,<BR> @REL<BR> )<BR> END<BR> ELSE<BR> BEGIN<BR> RETURN 1<BR><BR> END<BR><BR>How in my ASP code can I check to see if the SProc returned "1"..?<BR><BR>Or is there a better way to do this..? I&#039;m open for options...<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP & SProc Question...

    You can create an output parameter and return the 1 that way, then read it off the parameters collection.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts