[FONT=Calibri][SIZE=3]Hello everyone,[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]I am fairly new to Flash and I have a bit of a problem. I have made a Highscores board for a simple flash game, the board works in Safari and Firefox, but it doesn’t work the way it is supposed in IE.The problem is that once I want to repopulate my data grid with data from my sql database the table doesn’t update, it updates only the first time.I’ve went trough the code many times and cant find any mistakes. Reloading the web page doesn’t help, but if I wait some time(like 30-60 seconds) and refresh then the updated data shows, perhaps the problem is somewhere in the IE browser sessions? I’ve tested it in IE8 64bit,IE6 64 bit, IE6 32 bit on different PCs and still it doesn’t work. Bellow you can see my code it is in AS3:[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]import fl.controls.dataGridClasses.DataGridColumn;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]import fl.controls.DataGrid;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]import fl.data.DataProvider;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]hsGui.toMenu.addEventListener(MouseEvent.CLICK, showMenu);[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]var myDataGrid:DataGrid = new DataGrid();[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]getMyData();[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]function getMyData()[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]{[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]var variablesX:URLVariables = new URLVariables();[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]var request:URLRequest = new URLRequest();[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]////insert in the location of the php script ////////////////[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]request.url = “http://www.sf-net.eu/gRum.php”;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]//////////////////////////////////////////////////////////////[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]request.data = variablesX;[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]var loader:URLLoader = new URLLoader();[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]loader.load(request); //sends the request [/SIZE][/FONT]
[FONT=Calibri][SIZE=3]loader.addEventListener(Event.COMPLETE, showBoard);[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]}[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]function showBoard(event:Event):void {[/SIZE][/FONT]
[SIZE=3][FONT=Calibri]myDataGrid.removeAll();[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]var myXML:XML = XML(event.target.data);[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]//put the xml data into a DataProvider variable[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]var dp:DataProvider = new DataProvider(myXML);[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]//initialize an empty array[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]var columnArray = [];[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]//initializes the columns of the data table[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]for (var x:Number = 0; x < myXML.children()[0].children().length();x++){[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]columnArray[x] = new DataGridColumn[/FONT][/SIZE]
[SIZE=3]FONT=Calibri;[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]}[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]//sets the width of each column[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]columnArray[0].width = 30; //rank[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]columnArray[1].width = 75; //name[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]columnArray[2].width = 50; //score[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]//adds the columns to the data grid[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]for (x = 0; x < myXML.children()[0].children().length(); x++) {[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]myDataGrid.addColumn( columnArray[x] );[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]}[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]//populates the datagrid with the xml data[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]myDataGrid.dataProvider = dp;[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]myDataGrid.width = 370;[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]myDataGrid.rowCount = 8;//dp.length;[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]myDataGrid.move(103, 109);[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]myDataGrid.sortableColumns = false;[/FONT][/SIZE]
[SIZE=3][FONT=Calibri]addChild(myDataGrid);[/FONT][/SIZE]
[FONT=Calibri][SIZE=3]}[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]function showMenu(evtObj:MouseEvent)[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]{[/SIZE][/FONT]
[SIZE=3][FONT=Calibri]removeChild(myDataGrid); [/FONT][/SIZE]
[SIZE=3][FONT=Calibri]gotoAndStop(3); [/FONT][/SIZE]
[FONT=Calibri][SIZE=3]}[/SIZE][/FONT]
[FONT=Calibri][SIZE=3]If anyone knows what the problem is please help, I’ve been trying to figure it out for almost two weeks and I feel like trashing my PC with a hammer.[/SIZE][/FONT]