|
| |
|
|
macvsog
Posts: 19
From: Orange, Ca. US
Status: offline
 |
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
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
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
Posts: 19
From: Orange, Ca. US
Status: offline
|
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
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
