Database Grouping (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


macvsog -> Database Grouping (3/15/2001 21:23:00)

I request data from an access database using FP2000 asp page that will return to requestor the company name and below all employees for that company directly under company name.

Currently I get the company name and employee (1)
Next field repeats company name and next employee and so on.

How can I get a database output that provides

(1st field)
Company name #1
Employee #1
Employee #2
Employee #3

(2nd Field)
Company Name #2
Employee #1
Employee #2
Employee #3

Any help really appreciated





Spooky -> RE: Database Grouping (3/17/2001 20:49:00)

Not easily, you could achieve the output :

Employee #1
Employee #2
Employee #3
Employee #1
Employee #2
Employee #3

To go a step further would require a little asp and some field checking.

eg

Start DRW row stuff

<%
sColVar = FPFieldVal(fp_rs("GroupName")
If sColVar <> sColVar OR sColVar= "" then Response.write sColVar
%>

Do other row stuff

------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!





macvsog -> RE: Database Grouping (3/17/2001 23:38:00)

Spooky:

Thank You, Thank You, we'll give it a shot Monday... It's now coming together in this ole grey matter :> )

Thanks again
Rod





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625