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

[Yves Vindevogel]

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 � 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>