Don, Am 09.03.2010 um 19:04 schrieb drugh10: > > 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! > >> ...so to be clear then: on the client computer, I need to install Postgres >> first, then the Perl modules? I use cpan to install DBI, then ran into the >> issues with DBD::Pg. And Postgres needs to be the same version as IMDC so >> that it works? All this installation on the client side just to pickup a few >> include files? Seems like there should be an easier way -- what tools does >> Dartware usually use to query the database? My goal is to write a query >> based on the one earlier in this thread, but script it such that the start >> and end times encompass a day, and generate an availability number for each >> day for selected (or all) devices across a date range. >
we all use SQL-Queries embedded in a programming language like, PHP, Perl, Ruby or Python. Normally we install this next to the IM-DB-Server and run it via a web-interface. This is the fastest, easiest and most reliable way. If you find a easier way, your results are welcome. Regards Uli____________________________________________________________________ List archives: http://www.mail-archive.com/intermapper-talk%40list.dartware.com/ To unsubscribe: send email to: [email protected]
