Re: 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

Comment on Re: Dynamic SQL Bind values Select or Download Code

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	[reply] [d/l] [select]
Re^3: Dynamic SQL Bind values by blogical (Pilgrim) on Apr 23, 2006 at 23:25 UTC
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	[reply]