Sorry I don't know CF and it has been 20 years since I did any Access. But I suspect a data type problem. Exactly what is a "yes/no" field looking for?
Tracy Spratt, Lariat Services, development services available _____ From: [email protected] [mailto:[email protected]] On Behalf Of stinasius Sent: Thursday, November 19, 2009 10:03 AM To: [email protected] Subject: [SPAM] [flexcoders] Re: how to insert checkbox value into database here is were it fails.... in my cfc i have the following <cfargument name="pool" type="boolean" required="no"/> INSERT INTO homes(pool) VALUES("#arguments.pool#") the column in the table is pool and the id of the check box in the flex ui is also pool. in flex i have the following <mx:RemoteObject id="listManager" destination="ColdFusion" source="App.src.cfcs.Maintenance" showBusyCursor="true"> <mx:method name="listProperty" result="handleStringResult(event)" fault="mx.controls.Alert.show(event.fault.faultString)"/> </mx:RemoteObject> private function insertHandler():void{ listManager.listProperty(pool.selected); } when i try to insert it gives "error: cant execute query". any thoughts on what i can do to insert the value of the check box into the database. by the way the datatype of pool in database table is yes/no. am using access. thanks
