Long subject line.
I've got char datatypes in a MySQL 5 db with data of "Yes" and "No". I'm running an ajax query using jquery and retrieving data from a component method, specifying a return format in the query string for the method as "json". (CF8) Everything is working fine, except for the fact that my "Yes" and "No" is being translated into "true" and "false" when it gets back to the browser. Where along the line of running a query, using cfset to return the query data as part of a struct, and outputting that data via jquery on the calling page can I prevent the change from "Yes" to "true", etc. For my purposes, the data doesn' t need to be Boolean, but does it need to be Boolean for json? Should I change the datatype? I'm just displaying the data on the screen in this manner: Living Room - Yes Dining Room - Yes It's probably the json formatting that's tripping me up here. I know I could run some cfif's. cfif data is "true" then output "yes", but isn't there a better way than a bunch of cfif's? Suggestions? Need to see code? Thanks, Rick ---------------------------------------------------------------------------- ------------------------------------------ "Ninety percent of the politicians give the other ten percent a bad reputation." - Henry Kissinger ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
