Date index for Nov 2003

Hi,

Jeroen van Wissen wrote:

> But i'm using the $hoursnode object to call the recordList.
> The same way as the original code.

That's what I was trying to explain.

The hoursnode expects fields like 'activity_id', 'phase_id' etc, whereas 
your query returns columns with different names.

So either your query should be adapted to be compatible with the default 
hoursnode, or you should create a small node which reflects the query 
you do.

> The only difference is that my $data variable is generated with the $g_db->getrows() function,
> and the original $data variable is generated with the $hoursnode->selectDb() function.

Another difference between selectDb and getrows is that getrows returns 
'raw' database values, whereas selectDb converts them a bit. For 
example, using activity_id in getrows will result in just the number, 
using activity_id in selectDb will result in an array with all info 
about the activity, including it's name etc.

If you want to make use of this functionality in your own reports, the 
query method may not be the way for you.

But again, have a look at hoursurvey.inc, it does almost what you want, 
just the grouping is different. Perhaps you can modify that one to suit 
your needs.

Greetings,
Ivo