Jeremy,
I know this has become sort of a joke but... why don't you use stored procedures ?
Yes, MySQL hasn't them, but PostgresSQL has them, and so do many other proprietary
DBMSes.
Regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Jeremy Quinn [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 03, 2003 3:11 PM
> To: [EMAIL PROTECTED]
> Subject: SQL Editor
>
>
> Hi Guys
>
> I am looking into implementing a forms-based editor for a complex set
> of inter-related SQL Tables (with lots of gruesome link tables etc.).
>
> What is currently considered the best technique to be using in Cocoon
> right now?
>
> XMLForm (we don't use Beans)
> OriginalDBActions (obsolete ? )
> ModularDBActions (Actions are not liked by many)
> SQL Inserts/Updates using SQLTransformer (maybe not capable of the job
> due to complexities of the multiple Table updating required ? )
> SQL Inserts/Updates using ESQL TagLib (complex and difficult to
> maintain ? )
> OutputModules+FlowScript (too unknown ? )
>
>
> Out of this list, the ability of ModularDBActions to make multiple
> row/table modifications into a discreet transaction makes it sound the
> most attractive.
>
> As for OutputModules+FlowScript, is that even a reality yet?
>
>
> Thanks for any advice.
>
> regards Jeremy
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
