Hi,
I was just reading through the Ajax Carselector Sample at http://localhost:8080/cocoon/samples/blocks/forms/carselector
. In my case, I want to modify the car-db.xml, so that it takes its values from a mysql database. For now, the car-db.xml looks like that:
<?xml version="1.0"?>
<cars>
<make name="Audi">
<type name="A2">
<model name="1.4 75"/>
<model name="1.4 TDI"/>
</type>
<type name="A3">
<model name="1.6 Attration 102"/>
<model name="2.0 FSI Ambition Luxe 150"/>
</type>
</make>
<make name="Volkswagen">
<type name="Golf">
<model name="1.6 Trendline 101"/>
<model name="2.0 FSI Comfortline 150"/>
</type>
<type name="Passat">
<model name="2.0 Turbo FSI Sportline 189"/>
<model name="1.9 TDI Highline 102"/>
</type>
<type name="Bora">
<model name="1.6 Trendline 101"/>
<model name="2.0 FSI Comfortline 150"/>
</type>
</make>
</cars>
Where it now says <make name="Audi"> or <make name="Volkswagen">, I want something like <make name= results from
'select distinct kategorie1 from Objekt'>
where it now says A2, I want 'select distinct kategorie2 from Objekt where
kategorie1='Audi'' and where it says Golf I want 'select distinct kategorie2
from Objekt where kategorie1='Volkswagen''
where it now says '1.4 75' I want 'select distinct kategorie3 from Objekt where kategorie1='Audi' and kategorie2='A2' ......and so on
Does anyone have an idea how I can do that.
Thank you very much
Marco
- Modify AJAX Carselector sample to work with mysql 321 Los
