Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#41900 - 17/10/2001 13:07 Count in Emplode 2.0
phaigh
addict

Registered: 04/11/1999
Posts: 649
Loc: Reading, UK
It would be nice to have a count of the number of items under the current one in the 'soup' views, especially Genres and Years.

Just a thought.

Paul.

Paul Haigh, Reg. 4120
(mk1) 6GB, Blue, 00254
(mk2) 12GB, Red, 00357
_________________________
Paul Haigh, Reg. 4120 (mk1) 6GB, Blue, 00254 (mk2) 12GB, Red, 00357

Top
#41901 - 19/10/2001 06:28 Re: Count in Emplode 2.0 [Re: phaigh]
Roger
carpal tunnel

Registered: 18/01/2000
Posts: 5680
Loc: London, UK
Unfortunately, that'll require actually running the query. This is generally deferred until you actually click on the item in question.


-- roger
_________________________
-- roger

Top
#41902 - 19/10/2001 14:35 Re: Count in Emplode 2.0 [Re: Roger]
phaigh
addict

Registered: 04/11/1999
Posts: 649
Loc: Reading, UK
Could do it as a second pass, i suppose, similar to how encspot does the block counting for mp3 files.

Anyway, this is a wish list ..... .

Paul.

Paul Haigh, Reg. 4120
(mk1) 6GB, Blue, 00254
(mk2) 12GB, Red, 00357
_________________________
Paul Haigh, Reg. 4120 (mk1) 6GB, Blue, 00254 (mk2) 12GB, Red, 00357

Top
#41903 - 22/10/2001 02:55 Re: Count in Emplode 2.0 [Re: Roger]
peter
carpal tunnel

Registered: 13/07/2000
Posts: 4172
Loc: Cambridge, England
Unfortunately, that'll require actually running the query. This is generally deferred until you actually click on the item in question.

So how do you generate the list of genres? Couldn't that query also tell you the count of each? (er, SELECT genre, COUNT(fid) FROM * GROUP BY genre, or something)

Peter



Top
#41904 - 22/10/2001 03:29 Re: Count in Emplode 2.0 [Re: peter]
Roger
carpal tunnel

Registered: 18/01/2000
Posts: 5680
Loc: London, UK
Yeah, yeah. Whatever.


-- roger
_________________________
-- roger

Top
#41905 - 22/10/2001 03:32 Re: Count in Emplode 2.0 [Re: Roger]
Roger
carpal tunnel

Registered: 18/01/2000
Posts: 5680
Loc: London, UK
Ah, except that it proves to be impossible to keep the counts up-to-date without running the query every 5 seconds, and I'm not doing that unless I can make the queries go faster.


-- roger
_________________________
-- roger

Top
#41906 - 22/10/2001 05:52 Re: Count in Emplode 2.0 [Re: Roger]
phaigh
addict

Registered: 04/11/1999
Posts: 649
Loc: Reading, UK
They don't need to be re-run, just have them refresh on screen entry/redraw.

Then to refresh the counts, just click on 'genre' (or whatever) again.

That'd would be groovy, cool and most of all, really, really useful.

Cheers,

Paul.

Paul Haigh, Reg. 4120
(mk1) 6GB, Blue, 00254
(mk2) 12GB, Red, 00357
_________________________
Paul Haigh, Reg. 4120 (mk1) 6GB, Blue, 00254 (mk2) 12GB, Red, 00357

Top