Re: NULLs in ecpg

wespvp(at)syntegra(dot)com wrote:
> On 7/16/04 11:11 AM, "Edmund Bacon" <ebacon(at)onesystem(dot)com> wrote:
>
>
>>Indicators works as expected. e.g.:
>>
>>EXEC SQL INSERT INTO sometable
>> VALUES (:v1 :v1_ind, 'foo', :v2 :v2_ind);
>
>
> Hmm. I tried that. Just tried it again and it worked. Must have had a
> typo before. Sorry.
>
> What about if I have something like:
>
> ... VALUES (TO_TIMESTAMP(:expirationDate, 'YYYYMMDDHH24MISS'), 'foo', :v2)
>
> How can I insert NULLS for expirationDate when there's a function in the
> way? Using
>
> ... VALUES (TO_TIMESTAMP(:expirationDate, 'YYYYMMDDHH24MISS') :ind1, ...
>
> won't work.

No, but
... VALUES (TO_TIMESTAMP(:expirationDate :ind1, 'YYYYMMDDHH24MISS'), ..
should

--
Edmund Bacon <ebacon(at)onesystem(dot)com>