wespvp@xxxxxxxxxxxx wrote:
On 7/16/04 11:11 AM, "Edmund Bacon" <ebacon@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
|
