i dont know but this code make cocoon give to answer
<esql:connection>
<esql:pool>hotpoints</esql:pool>
<esql:execute-query>
<esql:query>select max(id_Elements) from tblElements </esql:query>
<esql:results>
<elements>
<esql:row-results>
<element>
<esql:get-columns/>
</element>
</esql:row-results>
</elements>
</esql:results>
</esql:execute-query>
</esql:connection>
On Tue, 30 Mar 2004, Yves Vindevogel wrote:
> Why are you unable to make a select max(myfield) from mytable query ?
> I don't understand the problem. Please explain.
>
> On 30 Mar 2004, at 19:26, [EMAIL PROTECTED] wrote:
>
> >
> > yves
> > thnx for your answer
> >
> >
> > i'm using eslq to make queries and it was unable to run a select
> > max(id)
> > .. querie...
> >
> >
> > is it possible to write java code to make my queries. if yes how can i
> > get
> > access to connection pool configured in xconf?
> >
> >
> > thnx
> >
> >
> > --stavros
> > On Tue, 30 Mar 2004, Yves Vindevogel wrote:
> >
> >> Not possible in one shot .... IMHO
> >> You'll need to do the Insert and in the same page, run a second query
> >> to get the Max(id).
> >> If you're afraid of getting the wrong one (because somebody is doing
> >> the same thing on the same table), use a where clause (like adding the
> >> name of the company you just inserted)
> >>
> >> On 30 Mar 2004, at 19:08, [EMAIL PROTECTED] wrote:
> >>
> >>>
> >>>
> >>> oh sorry
> >>>
> >>> i use msAccess throgh ODBC
> >>>
> >>> -- stavro
> >>>
> >>> On Tue, 30 Mar 2004, Yves Vindevogel wrote:
> >>>
> >>>> What database ?
> >>>>
> >>>> I generally do this by using a function in postgresql.
> >>>> You execute the function and in the function you get the new id.
> >>>> That ID is returned as value (and 0 for failure)
> >>>>
> >>>> Same for MS Sql. You can use a stored procedure there.
> >>>> That's kind of the same as a postgresql function
> >>>>
> >>>>
> >>>> On 30 Mar 2004, at 18:31, [EMAIL PROTECTED] wrote:
> >>>>
> >>>>> i'm executing an Insert SQL statement using a custom xsp action
> >>>>>
> >>>>> is it possible to get the new id number (auto increment) inside the
> >>>>> action
> >>>>> or inside the my pipeline's match?
> >>>>>
> >>>>>
> >>>>> any idea ?
> >>>>>
> >>>>> --stavros
> >>>>>
> >>>>>
> >>>>> -------------------------------------------------------------------
> >>>>> --
> >>>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >>>>> For additional commands, e-mail: [EMAIL PROTECTED]
> >>>>>
> >>>>>
> >>>>>
> >>>> Met vriendelijke groeten,
> >>>> Bien ~{&.!c~} vous,
> >>>> Kind regards,
> >>>>
> >>>> Yves Vindevogel
> >>>> Implements
> >>>>
> >>>> Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91
> >>>>
> >>>> Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
> >>>> Markt 18c - 9700 Oudenaarde - Tel: +32 (55) 30 55 76
> >>>>
> >>>> Web: http://www.implements.be
> >>>>
> >>>> First they ignore you. Then they laugh at you. Then they fight
> >>>> you.
> >>>> Then you win.
> >>>> Mahatma Ghandi.
> >>>>
> >>>
> >>>
> >>> ---------------------------------------------------------------------
> >>> To unsubscribe, e-mail: [EMAIL PROTECTED]
> >>> For additional commands, e-mail: [EMAIL PROTECTED]
> >>>
> >>>
> >>>
> >> Met vriendelijke groeten,
> >> Bien ~{&#~} vous,
> >> Kind regards,
> >>
> >> Yves Vindevogel
> >> Implements
> >>
> >> Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91
> >>
> >> Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
> >> Markt 18c - 9700 Oudenaarde - Tel: +32 (55) 30 55 76
> >>
> >> Web: http://www.implements.be
> >>
> >> First they ignore you. Then they laugh at you. Then they fight you.
> >> Then you win.
> >> Mahatma Ghandi.
> >>
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> Met vriendelijke groeten,
> Bien ~{($~} vous,
> Kind regards,
>
> Yves Vindevogel
> Implements
>
> Mail: [EMAIL PROTECTED] - Mobile: +32 (478) 80 82 91
>
> Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76
> Markt 18c - 9700 Oudenaarde - Tel: +32 (55) 30 55 76
>
> Web: http://www.implements.be
>
> First they ignore you. Then they laugh at you. Then they fight you.
> Then you win.
> Mahatma Ghandi.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
