Re: How to insert a space after each Manager Starts.

navinsm2_at_rediffmail.com (Navin) wrote in message news:<5dc7f532.0306302040.575f3f0_at_posting.google.com>...
> hi,
> Guys this not what i want ...
> i do want to run in sql&plus or report or use break command
> i wnat to get the output using normal sql and return into my front end
> ...
> i wnat to return the output using normal sql and return back to my
> front end that asp
> regds,
>
>
> navin
> Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.196a782df32c5cf3989781_at_news.cis.dfn.de>...
> > In article <3722db.0306300833.1104942_at_posting.google.com>,
> > danielroy10junk_at_hotmail.com says...
> > > To display a blank line after each change of manager, use "break on
> > > manager skip 1" before running your report in SQL*Plus. Note that this
> > > eliminates the display of the same manager number when multiple
> > > records have the same manager number. It is only displayed for the
> > > first record.
> > >
> > Seems like we're all agreed on the solution then - that must be 5 or 6
> > virtually identical posts...
> >
> > cheers

Navin,

What you are talking about is _formatting_ in your ASP. Just loop through your ADO recordset sorted by manager, check the manager value, and put a <TR></TR>, or however you are formatting blank lines, if it changes.

Regards,

Steve Received on Tue Jul 01 2003 - 07:29:09 CDT