SQL Stored Procedure Question

Results 1 to 2 of 2

Thread: SQL Stored Procedure Question

  1. #1
    Join Date
    Dec 1969

    Default SQL Stored Procedure Question

    Do recordsets populated by a Stored Procedure(SQL 7) have the same properties and methods as any other recordset? <BR><BR> I am asking because I just moved a select statement to a stored procedure and now I get the followin error on my page. I have checked several times to insure that all the fields from my old statement are included in the stored procedure. Just thought that since I am referenceing several fields by their index <BR>rs(6) as opposed to rs("cataname") this might have something to do with my error. <BR>Any ideas?? <BR><BR>ADODB.Recordset error &#039;800a0cc1&#039; <BR><BR>Item cannot be found in the collection corresponding to the requested name or ordinal. <BR><BR>/Includes/incHome.asp, line 25

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Stored Procedure Question

    yea they act the same, only thing if you are refering them as rs(6) or so, just remember that the count starts from 0<BR><BR>your problem may be *as far as i can guess*<BR>rs(0), rs(1), rs(2), rs(3), rs(4), rs(5) (*NO* rs(6))

Posting Permissions

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