[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


Reply via email to