search for: dateid

I have hourly data for approximately 21 days in the following format DateID HourID Metrics 20060920 0 xxxxxx 20060920 1 xxxxxx The hour ids correspond to one hour windows starting 00:00 to 23:59. I have never dealt with TS data before. What is the best way to handle this data? TS objects or use the Zoo package? Thank...

...like : SELECT ID FROM my_table WHERE client=clientID AND set=yes and this query results in several rows and thus several ID's like "2 5 7 11 13 14 17"... How can I iterate over these values ?? Something like : for each item in ARRAY { SELECT asterisk_syntax FROM other_table WHERE dateID=$item } This query would result in something like *|*|7|may. How to iterate over an array of results ??? Jonas. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20090909/23ff5dd1/attachment.htm