Hello, I have got this to work in the past using a variable of data type BIT in the SP. This is data type that has the BOOL values of 0 or 1.
You should be able to access this as a output parameter variable in CF of type BIT. <cfprocparam cfsqltype="cf_sql_bit" dbvarname="@myvar" type="out" variable="i"> Hope that helps, Stephen -----Original Message----- From: Erik Britt-Webb [mailto:ebrittwebb@;attbi.com] Sent: 22 October 2002 04:06 To: SQL Subject: Passing booleans from SQL Server SP's to CF? MessageCan't figure out how to pass boolean variables through a SQL Server stored procedure (SP), so right now I pass 1/0 integers and the calling CF module converts the integers to booleans. Is there a way to pass booleans from SP back to CF? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/sql Get the mailserver that powers this list at http://www.coolfusion.com
