[thelist] Transversing a RecordSet from Multiple Tables

[Wade Armstrong]

on 6/15/02 1:37 PM, Rob Smith at rob.smith at thermon.com wrote:
> I've got a search across multiple tables for specific records and I'm
> getting an Object Required " response back from the browser. My guess is
> that the object I'm referencing wasn't returned in the RecordSet. For
> example:
>
> if NOT states.EOF then
>  states.movefirst
>  if SBU.SBUName <> NULL then   <------------------<<<
>    while (SBU.SBUName <> NULL OR NOT states.EOF)
>      response.write("<strong>" & SBU.SBUName & "</strong><br>" & vbCLRF)
> states.movenext
>    wend
>  end if
> end if
>

Where is the SBU object instantiated, and how are its properties populated?

Wade

<tip type="Active Server Pages" author="Wade">
Do you create a recordset for your database query results and then .MoveNext
and .Loop? Stop that! It's slow and resource-intensive. Instead, use
.GetRows - it's faster, (http://www.learnasp.com/learn/speedtablesall.asp)
and the syntax is quite easy
(http://www.learnasp.com/advice/whygetrows.asp).
</tip>