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

[Jeff Boes]

>
> On Feb 14, 2008, at 1:00 PM, Jeff Boes wrote:
>
>> Specifically, I want to set:
>>
>> UI_DATE_BEGIN
>>
>> 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