Displaying Boolean data

Probably something silly I'm doing or not doing.

I'm using Yes/No data from an Access db and I was expecting it to display
true/false on the Dreamweaver generated web page BUT instead I get one or zero
(1/0). Any suggestions, much appreciated

I found a very ugly way of getting the output I wanted. Basically two if
statements (coldfusion) that test the 'exerciseReqd' field (true/false) and
display Yes or No (or whatever I want).

<cfif rs_tourDetail.exerciseReqd><cfoutput>Yes</cfoutput></cfif>
<cfif NOT rs_tourDetail.exerciseReqd><cfoutput>No</cfoutput></cfif>

This still doesn't explain why the book I'm following (Jeff Bardzell's
Dreamweaver MX 2004 with ASP, coldfusion and PHP) shows the page displaying
true/false with the following code:

<cfoutput>#rs_tourDetail.exerciseReqd#</fcoutput>

As I said I get one or zero with the above code. But enough time wasted, time
to move on.

oilovlam,

Not knowing your full set-up I can't be sure, but this is most likely a
function of your database. Access treats true/false values differently than
most databases. It's OK for a teaching tool and desktop applications, but not
really intended for web applications.

Can you tell me what chapter in Jeffrey's book this comes from? I believe it
was updated in the latest version and I might be able to tell you how it was
handled. It could be that I changed the database so that it was no longer a
true/false field. Like I said, Access is not really up to serious web
application use.Others will differ with that, but I stand by it. I would
recommend using MySQL for the exercises instead. There are quick and easy MySQL
installers for (WAMP5 for Windows and MAMP for Mac) that will have you up and
running in no time.

Just a quick note to optimize your CF code a bit. You only need cfoutput if
you are outputting a variable. You can also combine your cfifs. See below.

<cfif rs_tourDetail.exerciseReqd>Yes<cfelseif NOT
rs_tourDetail.exerciseReqd>No</cfif>

Best of luck,

Bob
http://bobflynn.info/