Re: Flash forms checkbox question
First, a word of advice. Use CFQUERY instead of CFUPDATE. Here's how you handle the 0/1 thing: INSERT INTO tblMyTable(namedBinaryColumn) VALUES () 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
Re: Flash forms checkbox question
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
Re: Flash forms checkbox question
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: > 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 go about this, does anyone have an example of > something similar? > > Thanks, > Daron Smith > PSEA > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231684 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
Flash forms checkbox question
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 go about this, does anyone have an example of something similar? Thanks, Daron Smith PSEA ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231676 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