Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: SQL::Statement confusing literals and identifiers

by Thilosophy (Curate)
on Mar 11, 2008 at 06:32 UTC ( #673415=note: print w/ replies, xml ) Need Help??


in reply to SQL::Statement confusing literals and identifiers

Does anyone have any workarounds for this?

Does DBD::CSV support select * from Print? That might work (if you do not mind getting columns you do not need), although I cannot test it, your sample fails for me with a rather cryptic error:

DBD::CSV::st execute failed: Error while reading file /tmp/c/Print.csv +: Bad file descriptor at /usr/share/perl5/DBD/CSV.pm line 210, <GEN0> + chunk 1.
:-(


Comment on Re: SQL::Statement confusing literals and identifiers
Select or Download Code
Re^2: SQL::Statement confusing literals and identifiers
by ikegami (Pope) on Mar 11, 2008 at 07:22 UTC

    The error you are getting is due to an unrelated bug I fixed locally. It will probably stop manifesting itself if you installed Text::CSV_XS.

    Silly me, of course SELECT * will work, especially since I use fetchrow_hashref. The queries that use WHERE clauses are only done on the "real database" which has no problems with the quotes.

    Update: s/It will probably manifesting/It will probably stop manifesting/

      The error you are getting is due to an unrelated bug I fixed locally. It will probably manifesting itself if you installed Text::CSV_XS.

      Ahh, that would explain it. I installed everything using Ubuntu's apt-get, and yes, that gave me Text::CSV_XS, too.

        That should have been "It will probably stop manifesting". The word "stop" was missing. I didn't expect the XS version to fail.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2014-09-21 07:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (167 votes), past polls