> On 8/23/05, Deanna Schneider <[EMAIL PROTECTED]> > wrote: >> So, I just noticed that there isn't a documented >> cf_sql_boolean type >> for use with stored procedures. If you use it, though, it >> doesn't fail >> to compile, and it converts it to a cf_sql_char. But, >> with my stored >> proc in Oracle 10g - it's not going in as a boolean. (I >> get the error >> about wrong number or type of paramaters.) >> >> Does anyone know if there's a workaround that will really >> send a >> boolean to the stored proc, or do I need to alter my >> stored proc to >> not expect a boolean?
> Oracle's PL/SQL Boolean data type does not have an > equivalent in > ColdFusion, I think this may be because "Boolean" is not a > native SQL > data type. So, what I usually end up doing is to change > the data type > of the Boolean argument in my stored procedure to > something like > varchar2(1), accepting values of Y/N or T/F. Seems like it'd make a lot more sense to use a bit or int column and the values 0 or 1 since these are commonly used as boolean values in config files and most databases around the world when a boolean datatype isn't available or isn't used. Plus CF can evaluate a 0 or 1 value in a query column on its own without the need to determine if it's using Y/N or T/F. I've seen people use Y/N or T/F or "Yes" and "No" in db columns and I LOATHE them all. I'd accept a boolean datatype if the db has one, although I'm not likely to create a column with that data type myself. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
