I'm having trouble selecting for a yes/no (boolian) switch in PostgreSQL. Cold Fusion
displays the result as a 1, but it's actually a "t" in the boolian column. I'm trying
to write a
select statment like this:
SELECT * from model, series
WHERE model.seriesID = series.seriesID
AND model.show = Yes
AND series.seriesshow = Yes
ORDER by series.SeriesOrder
Yes doesn't work, yes doesn't work, t, doesn't, true, doesn't, and 1 doesn't. Any
suggestions?
Frank Hilliard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
