Identify Last Record

[Scott]

I'm returning a SQL recordset that uses "With Rollup" to render totals as
the last record. Normally I simply loop through recordset and response.write
each record adding HTML tags. However, I'd like to make the last record bold
to show it's a total.

How can I determine that a particular record is the last one?

My usual syntax is
Do While Not objRS.EOF
... Loop through records

[Aaron Bertrand [MVP]]

When you reach the rollup row, aren't there NULL values in columns to the
left of the sum?

For example, with the following query against the pubs database:

select discount, avg(discount) from discounts
group by discount with rollup

The last row has NULL for discount. If this doesn't help, can you show your
query?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Scott" <sbailey@mileslumber.com> wrote in message
news:#in8JFFwDHA.2080@TK2MSFTNGP10.phx.gbl...

> I'm returning a SQL recordset that uses "With Rollup" to render totals as
> the last record. Normally I simply loop through recordset and

response.write

> each record adding HTML tags. However, I'd like to make the last record

bold

> to show it's a total.
>
> How can I determine that a particular record is the last one?
>
> My usual syntax is
> Do While Not objRS.EOF
> ... Loop through records
>
>

[Scott]

I have it rendering "Total" and just realized I can test for that word.
Thanks again.

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:eL9XApFwDHA.3220@tk2msftngp13.phx.gbl...

> When you reach the rollup row, aren't there NULL values in columns to the
> left of the sum?
>
> For example, with the following query against the pubs database:
>
> select discount, avg(discount) from discounts
> group by discount with rollup
>
> The last row has NULL for discount. If this doesn't help, can you show

your

> query?
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
> "Scott" <sbailey@mileslumber.com> wrote in message
> news:#in8JFFwDHA.2080@TK2MSFTNGP10.phx.gbl...

> > I'm returning a SQL recordset that uses "With Rollup" to render totals

as

> > the last record. Normally I simply loop through recordset and

> response.write

> > each record adding HTML tags. However, I'd like to make the last record

> bold

> > to show it's a total.
> >
> > How can I determine that a particular record is the last one?
> >
> > My usual syntax is
> > Do While Not objRS.EOF
> > ... Loop through records
> >
> >

>
>