[EMAIL PROTECTED] wrote:
>>> my @new_values = ();
>>> my @place_holders =
>>> map {
>>> if (/^CURRENT TIMESTAMP$/) {
>>> $_;
>>> } else {
>>> push @new_values => $_;
>>> "?";
>>> }
>>> } @args
>>> ;
>>
>
>SQL::Statement can do this?
>
Yes. The snippet I sent before will automatically turn #1 into #2.
#1 INSERT INTO MyTbl (col1,CURRENT_TIMESTAMP,col2)
VALUES (7,'o''brian') };
#2 INSERT INTO MYTBL (COL1,CURRENT_TIMESTAMP,COL2)
VALUES (?,?)
And return (7,q{o'brian}) as @vals.
--
Jeff
