Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Interpolating subroutine call in SQL INSERT INTO SELECT statement

by KurtSchwind (Chaplain)
on Aug 26, 2015 at 12:34 UTC ( [id://1140013]=note: print w/replies, xml ) Need Help??


in reply to Interpolating subroutine call in SQL INSERT INTO SELECT statement

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
  • Comment on Re: Interpolating subroutine call in SQL INSERT INTO SELECT statement

Replies are listed 'Best First'.
Re^2: Interpolating subroutine call in SQL INSERT INTO SELECT statement
by shadowsong (Pilgrim) on Aug 26, 2015 at 12:56 UTC
    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.

    That is what I suspected, but I'm very new to Perl and still far from sure of what is and isn't possible.

    Thanks again for the advice. I appreciate it.

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://1140013]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others wandering the Monastery: (8)
As of 2024-04-18 10:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found