Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^4: SQL::Statement confusing literals and identifiers (now with workaround!)

by ikegami (Pope)
on Mar 11, 2008 at 19:29 UTC ( #673590=note: print w/ replies, xml ) Need Help??


in reply to Re^3: SQL::Statement confusing literals and identifiers (now with workaround!)
in thread SQL::Statement confusing literals and identifiers

That would surely fix the problem in my case, but it's a very incomplete fix. Simply removing the quotes is too minimalistic. That fix would remove some (maybe all) false negatives, but would introduce false positives. Specifically, the following name column pairs become indistinguishable:

  • "foo.bar".baz and foo."bar.baz"
  • "foo.bar" and foo.bar
  • "*" and *

The simplest solution might be to *add* quotes everywhere internally.

That said, I'll use the previously suggested SELECT * rather than applying this incomplete patch.


Comment on Re^4: SQL::Statement confusing literals and identifiers (now with workaround!)
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (12)
As of 2014-12-18 21:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (66 votes), past polls