Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Re: Dynamic SQL Bind values

by blogical (Pilgrim)
on Apr 23, 2006 at 01:48 UTC ( [id://545109]=note: print w/replies, xml ) Need Help??


in reply to Dynamic SQL Bind values

my @columns       = @{ shift };
doesn't work, use
my @columns       = @{ $_[0] };
(or don't bother with the temps, they were thrown in for clarity. My bad. )

"One is enough. If you are acquainted with the principle, what do you care for the myriad instances and applications?"
- Henry David Thoreau, Walden

Replies are listed 'Best First'.
Re^2: Dynamic SQL Bind values
by ChemBoy (Priest) on Apr 23, 2006 at 18:09 UTC

    Actually, it can be made to work by adding a + to the beginning: @{shift} treats "shift" as a string, and looks for a variable named @shift (which would—obligatory plug—be caught by use strict 'vars'), but @{+shift} forces it to use the keyword shift, which is what you were expecting it to do.



    If God had meant us to fly, he would *never* have given us the railroads.
        --Michael Flanders

      Danke chemboy.

      "One is enough. If you are acquainted with the principle, what do you care for the myriad instances and applications?"
      - Henry David Thoreau, Walden

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://545109]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others cooling their heels in the Monastery: (7)
As of 2024-04-16 11:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found