First, a word of advice. Use CFQUERY instead of CFUPDATE. Here's how you handle the 0/1 thing:
<cfquery> INSERT INTO tblMyTable(namedBinaryColumn) VALUES (<cfqueryparam cfsqltype="cf_sql_bit" value="#compareNoCase(FORM.trueFalseField, "false")#">) </cfquery> The compareNoCase() will return a zero or a one. Pete On 2/9/06, dsmith @ psea. org dsmith @ psea. org <[EMAIL PROTECTED]> wrote: > 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:231852 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
