What is wrong with this datagrid not sending back data to mysql

Posted on 2011-04-29
Last Modified: 2012-05-11
I am brand new to flashbuilder and looking over everything, I cannot figure out what I am missing to make this grid send data back to the mysql database.
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="" 
			   xmlns:mx="library://" minWidth="955" minHeight="600" xmlns:pricingservice="services.pricingservice.*">
			import mx.controls.Alert;
			protected function dataGrid_creationCompleteHandler(event:FlexEvent):void
				getAllpricingResult.token = pricingService.getAllpricing();

			protected function dataGrid_itemEditEndHandler(event:DataGridEvent):void

		<s:CallResponder id="updatepricingResult"/>
		<pricingservice:PricingService id="pricingService" fault=" + '\n' + event.fault.faultDetail)" showBusyCursor="true"/>
		<s:CallResponder id="getAllpricingResult"/>
		<!-- Place non-visual elements (e.g., services, value objects) here -->
	<mx:DataGrid id="dataGrid" creationComplete="dataGrid_creationCompleteHandler(event)" dataProvider="{getAllpricingResult.lastResult}" editable="true" itemEditEnd="dataGrid_itemEditEndHandler(event)" change="dataGrid_changeHandler(event)" enabled="true" horizontalCenter="124" verticalCenter="-77">
			<mx:DataGridColumn headerText="idPricing" dataField="idPricing"/>
			<mx:DataGridColumn headerText="PieceType" dataField="PieceType"/>
			<mx:DataGridColumn headerText="PrintPrice" dataField="PrintPrice"/>
			<mx:DataGridColumn headerText="DBPostage" dataField="DBPostage"/>
			<mx:DataGridColumn headerText="SatPostage" dataField="SatPostage"/>
			<mx:DataGridColumn headerText="SatList" dataField="SatList"/>
			<mx:DataGridColumn headerText="TradAddressing" dataField="TradAddressing"/>
			<mx:DataGridColumn headerText="VariableAddressing" dataField="VariableAddressing"/>
			<mx:DataGridColumn headerText="ShippingMailOnly" dataField="ShippingMailOnly"/>
			<mx:DataGridColumn headerText="TradDBTotal" dataField="TradDBTotal"/>
			<mx:DataGridColumn headerText="VariableDBTotal" dataField="VariableDBTotal"/>
			<mx:DataGridColumn headerText="TradSatTotal" dataField="TradSatTotal"/>
			<mx:DataGridColumn headerText="VariableSatTotal" dataField="VariableSatTotal"/>

Open in new window

Question by:blitzone
    1 Comment
    LVL 10

    Accepted Solution


    I know absolutely nothing about Adobe Flex so my comment is only on the database side. I think you just need to do some basic checks:

    Does the column listing match with the column on the database table that you are trying to write to? Check every single column and make sure they exist on the table in the correct order as listed on your flex script.

    If you have an auto number or sequence which is used for the ID, remember that you cannot insert that data from your application. The database auto-increments this number, so do not try posting the auto sequence number from your script.

    If you are sure you have accounted for every column, the next thing to check, is that the data type.

    Also check for every column that has been defined on your table as mandatory because this cannot be null. One way to avoid posting null value to your table, is to debug the values on your application to make sure they are present before you post them. Is there a way to turn error reporting on in Adobe Flex?

    see also:

    Debugging with the web-tier compiler @

    Configuring the debugger version of Flash Player @

    Working with the debugger versions of Flash Player and AIR @

    Debuging Error in AdobeFlex Builder (Windows-7) @

    Good luck

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    First things first - Preparation We need all the part for this install and it's much nicer to have them all on hand when you need them so here's what's required. Download Eclipse 3.5 32 bit (I like the Classic flavour) from here. (http://www.e…
    It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now