|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
November 8th, 2003, 02:55 PM
|
|||
|
|||
|
List query results in groups
I'm running a query to list manufacturers and product names, order by mfg ASC, productname ASC. Currently I have my display as such...
MFG 1 product 1 MFG 1 product 2 MFG 1 product 3 MFG 2 product 1 MFG 2 product 2 What i would like is this... MFG 1 product 1 product 2 product 3 MFG 2 product 1 product 2 Any suggestions?
|
|
#2
November 9th, 2003, 11:05 AM
|
|||
|
|||
|
RE: List query results in groups
how about the logic something like...
select all from mfg foreach mfg record print mfg record select all from items where mfg_mfgid = item_mfgid foreach item record print item record endforeach endforeach Pryce
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > List query results in groups |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
