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
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
I have a flash form with checkboxes, I need the value of the check box
to be 1 or 0, Flash forms return true or false. I know that the form
scope is stored as a structure, so I should be able to reset all True
values in the form structure to 1 and likewise with false. I'm not
sure exactly how to
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
4 matches
Mail list logo