Just found the answer. Show appears to be a reserved word in PostgreSQL because
"seriesshow" worked fine selecting for true. The correct way to right this is:
SELECT * from model, series
WHERE model.seriesID = series.seriesID
AND model.modelshow = true
AND series.seriesshow = true
ORDER by series.SeriesOrder
There's the morning gone. :)
Frank Hilliard
Frank Hilliard wrote:
> 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.
