Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Prepared query not accepting || instruction at execution

by seattlejohn (Deacon)
on Dec 28, 2002 at 20:11 UTC ( #222783=note: print w/replies, xml ) Need Help??


in reply to Prepared query not accepting || instruction at execution

Part of the problem isn't the DBI, it's that the SQL query you're trying to construct really isn't valid -- or at least won't give you the results you expected. In your final example:
SELECT name FROM catagories WHERE catagories.workrelated = ('Y' || 'N') ORDER BY name

MySQL is going to perform a logical-OR on 'Y' and 'N' and come up with a 0. So your query is logically equivalent to this:
SELECT name FROM catagories WHERE catagories.workrelated = 0 ORDER BY name

Remember that logical OR is going to take two arguments that are either true or false (or nonzero-but-numeric and zero in MySQL's case) and return a true or false (1 or 0) result. You could rewrite the query like this:
SELECT name FROM catagories WHERE catagories.workrelated = 'Y' || catagories.workrelated='N' ORDER BY name

Or better yet do as bart describes and use IN('Y','N') instead.

By the way, for the sake of programmers who may follow you, I would suggest spelling your table name categories.

        $perlmonks{seattlejohn} = 'John Clyman';

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (5)
As of 2023-02-05 23:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer not to run the latest version of Perl because:







    Results (33 votes). Check out past polls.

    Notices?