Cassin ronan
|
Posted: 03/30/2001, 1:26 AM |
|
It's possible to : "Get the id generated from the previous INSERT operation
" with Php and Mysql and Code Charge
Please
R.
|
|
|
CodeCharge
|
Posted: 03/31/2001, 1:52 PM |
|
For MySQL and PHP, you may try this "After Insert" Event:
-------------------------------------------------------------------------
$db->query("SELECT LAST_INSERT_ID()");
$db->next_record();
$insert_id = $db->f(0);
-----------------------------------------------------------------
Variable $insert_id will contain the id created by the last INSERT
operation.
"Cassin ronan" <ronan@conceptcom.net> wrote in message
news:9a1jfl$3g2$1@mail.tankhill.com...
> It's possible to : "Get the id generated from the previous INSERT
operation
> " with Php and Mysql and Code Charge
> Please
>
> R.
>
>
|
|
|
a
|
Posted: 03/31/2001, 7:21 PM |
|
Ditto that question for Access/ASP - with one added Q - what happens when
multiple users are adding records, can you be sure last record added id is
the right one?
- Andy
"Cassin ronan" <ronan@conceptcom.net> wrote in message
news:9a1jfl$3g2$1@mail.tankhill.com...
> It's possible to : "Get the id generated from the previous INSERT
operation
> " with Php and Mysql and Code Charge
> Please
>
> R.
>
>
|
|
|
Alexey Alexapolsky
|
Posted: 04/04/2001, 8:44 AM |
|
Nothing happens. This is thread-specific function.
--
Regards,
Alexey
CodeCharge Support
a <andy@bla.com> wrote in messagenews:9a66s9$heb$1@mail.tankhill.com...
> Ditto that question for Access/ASP - with one added Q - what happens when
> multiple users are adding records, can you be sure last record added id is
> the right one?
>
> - Andy
>
> "Cassin ronan" <ronan@conceptcom.net> wrote in message
>news:9a1jfl$3g2$1@mail.tankhill.com...
> > It's possible to : "Get the id generated from the previous INSERT
> operation
> > " with Php and Mysql and Code Charge
> > Please
> >
> > R.
> >
> >
>
>
|
|
|
Andy Farrell
|
Posted: 04/05/2001, 6:44 AM |
|
Thanks. That makes sense. So what would the code be for ASP?
Regards,
Andy
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9affh3$hqh$1@mail.tankhill.com...
> Nothing happens. This is thread-specific function.
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
> a <andy@bla.com> wrote in messagenews:9a66s9$heb$1@mail.tankhill.com...
> > Ditto that question for Access/ASP - with one added Q - what happens
when
> > multiple users are adding records, can you be sure last record added id
is
> > the right one?
> >
> > - Andy
> >
> > "Cassin ronan" <ronan@conceptcom.net> wrote in message
> >news:9a1jfl$3g2$1@mail.tankhill.com...
> > > It's possible to : "Get the id generated from the previous INSERT
> > operation
> > > " with Php and Mysql and Code Charge
> > > Please
> > >
> > > R.
> > >
> > >
> >
> >
>
>
|
|
|