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]
