The Exported XML

 If you have Microsoft Office Access 2007, download the zip file and open up the .accdb file.  I didn't use a .mdb file but that can also be used to export XML.  All you really need to know is that XML has to be used instead of an actual database file.  If you're using MySQL just use php to show the database as XML.  

Back to the .accdb file, once opened you'll see how to constrain the Options field to certain values.  This is what MSAccess2007 exports.

    
        6
        Nissan
        Maxima
        2009
        
            4 Wheel Disc Brakes
        
        
            Power Doorlocks
        
        
            Power Windows
        
        
            Sun roof
        
        290
    
    
        1
        Toyota
        Celica GT-S
        2000
        
            4 Wheel Disc Brakes
        
        
            Power Doorlocks
        
        
            Power Windows
        
        
            Sun roof
        
        180
    
    
        2
        Toyota
        Celica ST
        1996
        
            Power Doorlocks
        
        
            Power Windows
        
        105
    
    
        3
        Nissan
        350Z
        2009
        
            4 Wheel Disc Brakes
        
        
            Power Doorlocks
        
        
            Power Windows
        
        
            Sun roof
        
        306
    
    
        4
        Honda
        Civic Si
        2000
        
            4 Wheel Disc Brakes
        
        
            Power Doorlocks
        
        
            Power Windows
        
        
            Sun roof
        
        160
    
    
        5
        Honda
        S2000
        2009
        
            4 Wheel Disc Brakes
        
        
            Power Doorlocks
        
        
            Power Windows
        
        237
    

Comments

Add New Search

Datagrid Houndawg (67.49.2.xxx) 2009-01-12 18:51:52 Great Job. This is exactly what I was looking for. I hope it works for me like it does in the example. Question: How would you go about adding a image and/or a movie to this example. Reply | Quote 2   0

CellRenderer drooza (SAdministrator) 2009-01-17 22:18:47 Use CellRenderer http://www.sephiroth.it/tutorials/flashPHP/cell... Reply | Quote 0   0

Errerem carnt read Anonymous (82.42.145.xxx) 2009-02-05 08:28:30 this is just what I want but i carnt read how to do kt because am a starter in the flash 8 fingy Reply | Quote 2   0

dynamic grid... renzo (125.163.76.xxx) 2009-03-15 01:35:32 does anyone know how to edit the value at grid... Reply | Quote 0   0

how to play video when cell is clicked? Jason (86.29.128.xxx) 2009-05-02 22:15:43 how would you make a video play in flash when a cell is clicked in the datagrid? im guessing a function but would you know the exact code and where it gets placed in the AS?? thanks Reply | Quote 0   0

Anonymous (82.75.150.xxx) 2009-06-16 07:19:54 Is there a way to work with several xml- files; here for instance one for cars, one for truck, one for motorbikes. Depending on what the visitor is looking for, the data inside the xml-files in question should be read into the datagrid and the queries set for All. The visitor can 'jump' between each of the sections (eg by using a combobox and the grid gets filled up with the new data from the other xml-file immediately. I realy would like to have seperate xml-files for each of the needs of the visitor... Thank you very much in advance Reply | Quote 1   0

change data provider drooza (SAdministrator) 2009-06-18 19:24:09 What you can do is just change the dataprovider of the datagrid to another xml file. check out how it's filtered. since the dataprovider is changed to an array for filtering, you can just filter a different dataprovider. Reply | Quote 0   0

atul singh (61.16.244.xxx) 2009-07-02 00:09:56 very nice thanks for lot of work Regards Atul singh Reply | Quote 0   0

Anonymous (74.103.209.xxx) 2010-02-05 01:46:17 Nicely done. I am trying to figure how can I insert URL and get it to work. Reply | Quote 0   0

Question James (95.17.50.xxx) 2010-03-14 07:57:02 Really top notch tutorial, congratulations. I'm trying to take it a bit further but I need a bit of help. How can I use the filter to load a corresponding image into a UIloader - I think the problem I'm having is that logically the image can only appear when the user has filtered down to only one unique result in the data grid, but I can't see what the value of the result would be in action script, or what to set an event listener for. then I suppose it is a simple question of: -loader.source=that value+".png" If you don't think this is the way please tell me what you think Thanks in advance and keep up the good work - we need you! Reply | Quote 0   0

Write comment
Name:
Email:	do not notifynotify
Title:
UBBCode:	-color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge
Please input the anti-spam code that you can read in the image.

Powered by !JoomlaComment 3.26

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."