yeah yeah ben, i take it u wont be at the meeting tonight?
i guess i forgot to point out that this ISNT the main ID field its a
secondary field.
ok its like this.
what im doing is making steps showing how to make something.
the field i am trying to get (which btw, i got to work) is named ParentID.
so that as i add steps to the process it keeps under the parentID. But on
this 1st step it needs to get the last parentID so I can 1 up it, u get
what i am saying?
the actual ID is ok, lol
> Dude. If you have multiple records with an ID of 56, then either a) we
> don't agree on the definition of an ID or b) you've screwed something
> up.
>
> The easiest way is to set up the column as an auto-increment. That way,
> you never have to worry about this scenario (or race conditions).
>
> --Ben Doom
>
> [EMAIL PROTECTED] wrote:
>
>> whats the "proper" way to get the last inserted id out, u cant use
>> max(id) i dont believe. however say the last number was 56, there
>> could be 20 or so 56's i just need to have the next one insert as 57.
>> i know i can so some things with the query but it behaves odd
>> sometimes
>>
>> ty
>>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
