924Board.org

[924RACR]

Peter, a suggestion. I'm thinking it could be more efficient that we reorder the discussions to deal with the issue of the 931 and 924S groups dropping off the bottom of the screen. Move the 931 discussion and tech and the 924S discussion sections right below the General Discussion section, and keep everything together.

The Old Board can stay at the bottom. Maybe move About the Board to the bottom. Should probably move Body and Interior up below Performance Upgrades. Essentially end up ordering by activity levels.

Sound good? Makes sense to me...

Gee, I gotta put a new picture up top... I like the blue car, real sweet, but time for a change... got a picture in mind...

_________________
Vaughan Scott
Webmeister
'79 924 #77 SCCA H Prod racecar
'82 931 Plat. Silver
#25 Hidari Firefly P2 sports prototype

[924RACR]

BUMP

Peter (B), please read and give feedback...

_________________
Vaughan Scott
Webmeister
'79 924 #77 SCCA H Prod racecar
'82 931 Plat. Silver
#25 Hidari Firefly P2 sports prototype

[Peter_in_AU]

OK, you got my attention

I've moved some of the topics around. Can't set the order of the topics within the categories. I'll put a change into the software to do that.

[Peter_in_AU]

how does that look?

[John H]

Looks good - I was reading a section then went back and you'd done it.

[wdb]

I think I interupted your reordering, tried to view pages got this message;
Unable to get categories from database
SELECT c.* FROM catagories c, forums f WHERE f.cat_id=c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order f.forum_order

[924RACR]

Cool...

_________________
Vaughan Scott
Webmeister
'79 924 #77 SCCA H Prod racecar
'82 931 Plat. Silver
#25 Hidari Firefly P2 sports prototype

[jcope]

I like the reorganization a lot. But I was hoping the 924S discussion would end up a little higher. Maybe just at the very top?

[Rick MacLaren]

Looks to me like a bad SQL statement:

SELECT c.* FROM catagories c, forums f WHERE f.cat_id=c.cat_id GROUP BY c.cat_id, c.cat_title, c.cat_order ORDER BY c.cat_order f.forum_order

Dunno what DB drives your system, but, hey, that's never stopped me from commenting on anything before! Still, SQL is SQL. So I'm guessing, but here's some possible errors:

1. Why did you group by cat_order and then try to order by cat_order while NOT including f.forum_order in the GROUP BY clause?

2. If 'catagories' is a table name, it's spelled wrong - that can cause trouble because the DB doesn't likely have a spell checker, unless of course the table really and truly is spelled 'catagories'.

3. Also, the 'c.*' is a bit dangerous. I'd just spell out the column names that you want. Explicit naming helps a lot. * is a timesaver but that 'c.*' is wierd.

4. Shouldn't the ORDER BY clause have a ',' between 'c.cat_order' and 'f.forum_order'?


[ This Message was edited by: Rick MacLaren on 2002-06-29 14:41 ]

[Peter_in_AU]

alright I admit it. I made an error in the SQL when I was adding forum ordering to the software.

Yes Rick, you get the bonus point for picking the missing comma.

I always try to make any changes in the morning (Sydney time) when most of us are asleep dreaming of Carrera GTs.

My error was fixed 1 minute later. wdb must have been having a restless night

[teo]

from the Interesting Board Stats topic:

"Yeah that Sybase guy is very mouthy!"
Rick MacLaren

I wonder who can that be...