Marco
2006/5/25, Simone Gianni <[EMAIL PROTECTED]>:
Hi Marco,
as you can see, the form loads the selection lists with cocoon:/cars
pipelines. You can simply change this pipelines so that they does not
generate from a static XML file, but from a query on the DB using the
SQLTransformer followed by an XSL to transform the SQL XML output to
what you need.
Hope this helps,
Simone
321 Los wrote:
> Hi,
>
> I was just reading through the Ajax Carselector Sample at
> http://localhost:8080/cocoon/samples/blocks/forms/carselector
> < 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
--
Simone Gianni
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
