more useful options | |
PerlMonks |
Re: Interpolating subroutine call in SQL INSERT INTO SELECT statementby KurtSchwind (Chaplain) |
on Aug 26, 2015 at 12:34 UTC ( [id://1140013]=note: print w/replies, xml ) | Need Help?? |
You might be able to do simple interpolation using nothing but SQL inline with a few subqueries and some trivial math. If you truley need a perl function to do the job, you'll have to do a select in one call. And then prep an insert data set for a second call.
-- “For the Present is the point at which time touches eternity.” - CS Lewis
In Section
Seekers of Perl Wisdom
|
|