I am not a programmer. I solved my OBCD problem.
I am getting all your e-mails and I do not have a clue as to how to stop
them.
I would love to help, but I do not have a clue about programming. I was
looking for a way to fake out a microsoft upgrade into thinking I had a
product that it was looking for, however, I managed to get the product and
the upgrading is working.
If you want a programmer, contact roygreen.com.
How do I get off the mailing list.
Thank you for your kindness.
Sonya
----- Original Message -----
From: "Jeff Eckermann" <[EMAIL PROTECTED]>
To: "Guru Prasad" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 10, 2001 1:37 PM
Subject: RE: How to Access AutoIncrement Value ?
> From your description, you are apparently using the PostgreSQL "SERIAL"
type
> for your primary key field.
> SELECT currval('sequence-name') will get you the value of the last
sequence
> value used during the current user session (regardless of other users),
> which is what you want.
> Be aware that nextval() will reset the sequence to its next value, which
> will be returned. Some people like to call nextval() before each insert,
> and supply the sequence value explicitly when making the insert.
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, August 10, 2001 12:15 PM
> > To: Guru Prasad
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: How to Access AutoIncrement Value ?
> >
> >
> >
> > I don't know of a database independent way to do this. If you find one
> > let me
> > know! :-)
> >
> > You can get the value with Postgresql's nextval() function; the docs
have
> > examples.
> >
> >
> >
> >
> > Guru Prasad <[EMAIL PROTECTED]> on 08/10/2001
> > 12:18:09 PM
> >
> > To: [EMAIL PROTECTED]
> > cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
> > Subject: How to Access AutoIncrement Value ?
> >
> >
> >
> > Dear All,
> >
> > I have a field which is a primary key and an auto-incrementing one. Is
> > there a way to get this value through DBI (!DBD) once an insert sql
> > command is fired. I know it is possible in DBD::Mysql (through
> > $sth->{'mysql_insertid'}, you can get it). But i am using DBD::Pg and it
> > is always good if it is not Database Specific.
> >
> >
> > Is there a possible way ?
> >
> > Thanx in advance.
> > guru prasad.
> > bk SYSTEMS (P) Ltd.
> > P . N . G U R U P R
A
> > S A D
>
> --------------------------------------------------------------------------
> > -----
> >
> >
> >
> >
> >
> >
> >
>
