Hey, thanks for being a member! I'm looking to do a DB update, I was using CFUPDATE, which automatically converts true/false to 1/0. CFUPDATE doesn't seem to work with this table on our database, so I was trying to write the SQL and having T/F in the form variables blows up when it hits our bit field.
>Hey, I'm a PSEA member! Just got certified to teach English, planning >ahead for the day when nobody will hire me as a developer anymore... > >What about creating a UDF that converts a true/false to a 1/0? What >are you doing, inserting the data into a database as individual >values, or are you doing something else with the structure? > >Pete > >On 2/8/06, Smith, Daron [PA] <[EMAIL PROTECTED]> wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231740 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