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

[Brian McCallister]

Don't use auto-increment in an insert where you care about having the 
identity of the inserted value. A better solution, most of the time, is 
to use a named sequence and select values off of it, then populate the 
id field yourself:

In postgresql:

select nextval('MySequence'), nextval('MySequence'), 
nextval('MySequence'), nextval('MySequence'), nextval('MySequence');

Will give you the next five values from MySequence. Use these for your 
next five inserts. Most of the time when you set a field to 
autoincrement, or set a default value, or whatever the database you are 
using calls it, if you populate that value it doesn't use the default. 
This allows you to use the default value for batch inserts where you 
don't care about the ids, and lets you specify the id where you do.

-Brian

On Mar 30, 2004, at 11:31 AM, [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]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]