When accessing MySQL 5 from Java (i.e. when using JDBC) all TINYINT(1) fields are converted to Boolean values.
Documented here: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html You can prevent this behavior by adding a "Connection String" to your ColdFusion datasource (in Advanced Settings): tinyInt1isBit=false This will cause the JDBC driver to treat TINYINT(1) the way you want it to - as tiny little integers instead of boolean true/false values. -tom- Rick Faircloth wrote: > Hi, all. > > Here's the query: > > <cfquery name="get_days" datasource="#dsn#"> > > select distinct event_days from weekly schedule order by event_day > > </cfquery> > > The data that should be returned if the query is looped is > > 1, 1, 1, 1, 2, 4, 6 > > However, when I run. > > <cfloop query="get_days"> > > <cfoutput>#event_days#</cfoutput> > > </cfloop> > > .. all I get is 1, 1, 1, 1.four ones, and that's it. > > What could I be doing wrong? I knew transitioning from CF 4.5 to CF 8 > would present some issues, but gee whiz. > > Rick > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291132 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
