Re: [PERFORM] Volunteer to build a configuration tool

2007-06-18 Thread James Neethling
This is my idea: A JavaScript HTML page that would have some basic questions at the top: 1) How much memory do you have? 2) How many connections will be made to the database? 3) What operating system do you use? 4) Etc… Next the person would press a button, “generate”, found below the que

Re: [PERFORM] column totals

2006-05-26 Thread James Neethling
James Neethling wrote: Hi There, I've got a situation where I need to pull profit information by product category, as well as the totals for each branch. Basically, something like SELECT branch_id, prod_cat_id, sum(prod_profit) as prod_cat_profit FROM () as b1 WHERE x = y GRO

[PERFORM] column totals

2006-05-26 Thread James Neethling
Hi There, I've got a situation where I need to pull profit information by product category, as well as the totals for each branch. Basically, something like SELECT branch_id, prod_cat_id, sum(prod_profit) as prod_cat_profit FROM () as b1 WHERE x = y GROUP BY branch, prod_cat_id Now, I al