Record set

Results 1 to 2 of 2

Thread: Record set

  1. #1
    IT LOVER Guest

    Default Record set

    I need to have different record set for different cases eg when all parameters passed are o the record set should be:<BR><BR> "select count(*) from employees" , conn, 1,2<BR>it works fine without if loop but once I put it in if condition<BR>i get this error :<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>/employees/asp/emp.asp, line 257 <BR><BR>This is the code that give me problem.<BR>&#060;% if dept=0 and location=0 and months=0 then<BR> "select count(*) from employees" , conn, 1,2<BR>end if %&#062;<BR><BR><BR>Please help<BR><BR><BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Record set

    show more code<BR><BR>the RELEVANT code when you open a recordset in a loop<BR><BR>

Posting Permissions

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