My thought was to write a piece of code that could take the device_id, start, and end dates as arguments, then perform a query something like the one above for each day between start and end, providing the availability number for each day as output. I was having problems seeing how to 1) create variables to pass start/end dates and increment thru the range, and 2) how to provide loop control to execute and enclosed query using the variables.
If I'm missing something here, please feel free to lead the way! Functional examples (to drop into PGAdmin) welcome! Regards, Don -------------------- m2f -------------------- Read this topic online here: http://forums.dartware.com/viewtopic.php?p=2371#2371 ____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected]
