[ic] Set variable to query result at start-up?
lists at gmnet.net
Fri Feb 15 20:01:04 EST 2008
On Thu, 2008-02-14 at 13:00 -0500, Jeff Boes wrote:
> I'm curious if anyone's done this before, and if there are any clever or
> canned approaches:
> I would like to initialize an Interchange variable to the result of a
> SQL query, at IC startup (because the query could be a bit costly to run
> per page or even per session). Specifically, I want to set:
> to the first year represented by transactions.order_date, e.g.,
> select min(to_date(order_date,'YYYY')) from transactions;
> The only approach I've thought up (which I haven't tried yet) would be
> to define a module with a BEGIN block, and "Require" it in the
> interchange.cfg or catalog.cfg. Are there other approaches?
>  I'm not entirely sure this would run at the appropriate point, i.e.,
> after the database connection is established.
Take a look at [timed-build]....
More information about the interchange-users