Try this too.

    Ots.MoveFirst
    do while not ots.EOF
      blah
      blah
ors.MoveFirst
       do while not ors.eof
          blah
          blah
       ors.movenext
       loop
    ots.movenext
    loop


-----Original Message-----
From: Matthew L. Empringham [mailto:perlmaker@y...]
Sent: Tuesday, June 12, 2001 6:40 PM
To: Interdev_Programming
Subject: [interdev_programming] Re: do loops with only one record in
recordset

Martha you can do a:

If ots.eof Then
do exit
End if

Or you can use a for loop within a range and then use
logic to do a ots.movenext

I have a calendar with two for loops, I just tell it
when the days match the database, change color then I
wrap an if not end of file, movenext.

I don't know what your working with but hope this
helps.

Matt

--- martha j sayers <marthaj@r...> wrote:
> hi folks,
>
>   I know this is a very basic question, but I am
> having a problem with
> getting this resolved.
>
>   I have a query that returns 1 record.in my coding
> I have an outer loop
> and a inner loop.
> the problem is that it won't work if the recordet
> has only one record and
> I cann't remember for the life me how we use to get
> around it.
>
> here's what i have
>
>    do while not ots.EOF
>      blah
>      blah
>       do while not ors.eof
>          blah
>          blah
>       ors.movenext
>       loop
>    ots.movenext
>    loop
>
> With there only being one record, it is at the EOF
> of the recordset.
> HOw do I get around this ??
> thank you so much :-)
>
---
http://www.asptoday.com - the leading site for timely,
in-depth information for ASP developers everywhere.
danielsds@n...
$subst('Email.Unsub')