Re: How can I get ID number after insert a new record?

[Yves Vindevogel]

Ach, short code ...
short answer then

select * from table1 where table1.Id in (select max(id) from table1)

Gives you the record with the highest ID
Including all the columns and even the ID you just inserted

On 30 Mar 2004, at 19:59, [EMAIL PROTECTED] wrote:

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]

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
<x-tad-smaller>
First they ignore you. Then they laugh at you. Then they fight you. Then you win.
Mahatma Ghandi.</x-tad-smaller>