On 6 Jun 2004, at 18:32, Stephan Coboos wrote:

Jason Lane wrote:

Hi list,

OK I have the requirement for a dynamic select list, similar to the County Selector example (cocoon/samples/woody/countryselector ). My requirement is that both selects are database generated, so this will obviously require that the flow.js be generated.

I have looked on the mailing list and the wiki, the message I pick up is Hibernate, Flow, Woody/Cforms? This seems overkill to me as I'm not performing any inserts or deletes? Is there a simpler way to do this? Am I missing the point?

Couldn't I just generate the flow with the TextSerializer?

H�? I don't understand. Why generating flow with TextSerializer?

I think SQLTransformer or ESQL-Logicsheet will be your friend:

Yes that is good, but if I want to generate a flow.js from a DB? Surely I need to out put to a text format, which .js is.


So for example in my flow.js:

var $0 = [
    //these values from db
    { key: "$1", value: "$2" },
];

Where $0-2 are results of DB query.

Sorry I'm sure I'm totally missing the point here ;(


http://cocoon.apache.org/2.1/userdocs/transformers/sql-transformer.html
http://cocoon.apache.org/2.1/userdocs/xsp/esql.html
Another way - and my favourite way - is to create a own avalon component which connects to a database and retrieving the content via flowscript,
store it into a scope and reading it out via JXTemplate. But it's not the simplest way.



Thanks Stephan

Regards
Stephan



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Jason Lane

Developer
Root10 developments


--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to