You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Jason Lane <ja...@root10.net> on 2004/06/06 17:36:54 UTC

databases and flow [again]

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?

Any pointers appreciated


Hibernate looks interesting though.

Jason Lane

Developer
Root10 developments


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: databases and flow [again]

Posted by Joerg Heinicke <jo...@gmx.de>.
On 06.06.2004 22:36, Jason Lane wrote:

>>> 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 ;(

Don't generate the flow script, but access the values from a class that 
accesses the database.

Joerg

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: databases and flow [again]

Posted by Jason Lane <ja...@root10.net>.
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: users-unsubscribe@cocoon.apache.org
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>
>
Jason Lane

Developer
Root10 developments


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: databases and flow [again]

Posted by Stephan Coboos <cr...@gmx.net>.
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:

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.

Regards
Stephan



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org