in reply to Re: SQL Query Error
in thread SQL Query Error

No that isn't what is happening. The % sigils are correctly interpreted as SQL wildcards. See my answer below for what is really going on.

Replies are listed 'Best First'.
Re^3: SQL Query Error
by thor (Priest) on Sep 09, 2005 at 18:56 UTC
    Not that I don't believe you, but how is that not being interpretted as a hash? It's in a double quoted string which should make it try to interpolate.

    thor

    Feel the white light, the light within
    Be your own disciple, fan the sparks of will
    For all of us waiting, your kingdom will come

      Well, try the code below. If %bar were being interpolated as a hash, it would produce an error. Hash values are interpolated, but not entire hashes, at least not in strings that look like these.
      #!/usr/bin/perl -w use strict; my $str = "this has %bar that looks like a hash"; print $str;