what i am doing is my customer has a flyfishing shop and we have a section
where he can show how he makes his flies. so when he goes to add a fly it
needs to pull the last ParentID out to that it can add 1 to it.
the main db fields are ID=auto, ParentID=number, fstep=number.
then when he adds the next step to the process it pulls the parentID out
and adds it. really it has nothing to do with the ID field, i could care
less about that field, Just use it for the pics. But do u see where the
ParentID field can have several repeats but the ID fields arent the same,
so its all good
> 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
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
