One of the practices I've been using in Flex development using CF is to build a function test page that can be used to test functions in the CFC's that your Flex app will be calling. This makes it easier when debugging to verify if everything on the CF side is good and get the detailed CF diagnostics when the function fails.
Though SQL wise there could be a lot of things that could cause the stuff below to bomb. Eg if brand_id is an integer field the '#arguments.brandToAdd.brand_id#' is trying to pass a string to that field. Likewise with created_by, and modified_by. Tracy Spratt wrote: >I don't do CF, but that error does not sound like it is related to flex. > >Can you get your cfquery to display in a normal browser page? Or a cf >generated test page? > >Tracy > >-----Original Message----- >From: [email protected] [mailto:[EMAIL PROTECTED] On >Behalf Of vmlr123 >Sent: Monday, December 26, 2005 8:05 AM >To: [email protected] >Subject: [flexcoders] Error executing database querry > >Can any body just tell me why "Error executing database querry" . >Im new to flex and just trying to connect my db2 database with flex >using coldfusion. > >I dont find any error in the sql querry im using. > ><cfquery datasource="DSFORCF"> > INSERT INTO SPFLEX.M_BRAND_DETAILS >(brand_id,brand_name,created_by,modified_by) > VALUES >('#arguments.brandToAdd.brand_id#','#arguments.brandToAdd.brand_name#', >'#arguments.brandToAdd.created_by#','#arguments.brandToAdd.modified_by# >') > </cfquery> > > >Is it some thing related to the datasource settings..? > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/WpTY2A/izNLAA/yQLSAA/nhFolB/TM --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
