[ic] Set variable to query result at start-up?

Jeff Boes jeff at endpoint.com
Thu Feb 14 14:13:50 EST 2008

> On Feb 14, 2008, at 1:00 PM, Jeff Boes wrote:
>> 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[1], and "Require" it in the
>> interchange.cfg or catalog.cfg. Are there other approaches?

I've determined this won't work, because the database connection isn't
established at the time I need it to be in order to run the query. I
really have to do this inside the catalog.cfg somehow, and after the
point where the Database directives have been processed.

Jeffery Boes  <><
jeff at endpoint.com

More information about the interchange-users mailing list