Re: SQL Query Error

Replies are listed 'Best First'.
Re^2: SQL Query Error by jZed (Prior) on Sep 09, 2005 at 17:29 UTC
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.	[reply]
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`	[reply]
Re^4: SQL Query Error by diotalevi (Canon) on Sep 09, 2005 at 19:33 UTC
See Why doesn't % interpolate?.	[reply]
Re^4: SQL Query Error by jZed (Prior) on Sep 09, 2005 at 19:08 UTC
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;` [download]	[reply] [d/l]
Re^2: SQL Query Error by DrAxeman (Scribe) on Sep 09, 2005 at 17:24 UTC
That's what it looks like. Not sure how to work around it. '\%Secure Path\%' gives the same error.	[reply]