[thelist] Transversing a RecordSet from Multiple Tables
Wade Armstrong
wade_lists at runstrong.com
Sat Jun 15 16:35:00 CDT 2002
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>
More information about the thelist
mailing list