Am Mon, 5 Nov 2007 18:08:06 +0100
schrieb "Diez B. Roggisch" <diez.roggisch@...>:
> On Monday 05 November 2007 15:25:13 cmhofer@... wrote:
> > Hi,
> > i have 2 questions.
> > 1) is there a possibiliti' to start my own (complex) sql update
> > script. example
> > insert into webstats (uname,tipoctr)
> > (Select
> > cbl.codice,
> > 1+IFNULL((select 1 from collab2 where cbl.codice =
> > collab2.codice),0)
> > from collab cbl);
> > 2) How can i start procedures from sqlobject.
> Obtain a connection to your DB, which you should be able to using
> and then just proceed as if you were using the DB API itself.
> There is no support for more in SO because calling procedures &
> running hand-tailored SQL somewhat defeats the purpose of introducing
> an ORM layer in the first place.
> Be also aware of synchronisation-caveats when your procedures update
> the DB but the SO-cache doesn't reflect the changes.
i know it is not the best to use hand-tailored SQL but in some
"complicated" cases it's the only solution,
i need this to create a statistic table.