|
|
Posted by .:[ ikciu ]:. on 10/18/06 14:42
Hmm Steve <no.one@example.com> wrote:
>> try to understand...i'll explain one more time. i think you've missed
> the following two points simply because you HAVEN'T listened to the
> op or anyone else here. that, or you just don't understand the
> english.
i understand but primary key on varchar2 is for me not good solution, it
should be ID
> if i submit a new records for php to insert into a db, neither php
> NOR the db have an id for the record. the record has NOT been created
OFC
> yet. auto-increment does not prevent us from submitting that same
> data again and again, each time getting a new id for each record
> being inserted. however, EVER submission after the FIRST is a
> DUPLICATION.
it will be inpossible if this field in db is unique or it is a primary key -
do you get it?
> second, if i have an auto-incrementing field, it's use is to merely
> be a record identifier. if i'm creating records with product
> codes/id's or users with user names, each can be OVERWRITTEN without
> effecting the record's id IN THE LEAST. if jblow is a user defined in
> a users table and i change the user name of jrancher to jblow, i have
> effectively overwritten the data of jblow. i have compromised both
> the integrity of data AND potentially opened a wide security hole in
> the system. auto-incrementing id's has done NOTHING to prevent it.
omg ... you still think about autoincrement as a solution - this is only
part of changes:
1 add numeric id as a PK
2. make unique on codeID
> had you actually read or understood my code example, you'd have
> quickly seen that BOTH of these issues were handled. you knit-picked
> every part of that example (even though the 'problems' reloved around
> your lack of understanding) yet missed that KEY FUNCTIONALITY. as you
> say, 'for me, that won't do'.
hehe
> when you grow up, perhaps you'll learn to read something more
> substancial than 'dick-and-jane' level code. if you think you are
> STILL solving anything, then POST YOUR SOLUTION HERE.
i posted it below linda post ealry
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ikciu | gg: 718845 | yahoo: ikciu_irsa | www: www.e-irsa.pl
2be || !2be $this => mysql_query();
Navigation:
[Reply to this message]
|