Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

Re^2: Dynamic SQL Bind values

by ChemBoy (Priest)
on Apr 23, 2006 at 18:09 UTC ( [id://545143] : note . print w/replies, xml ) Need Help??

in reply to Re: Dynamic SQL Bind values
in thread Dynamic SQL Bind values

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

Replies are listed 'Best First'.
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