Originally Posted by Fou-Lu
The same way as you would with the surrogate.
There's nothing wrong with surrogates per se, but I typically reserve them only for when it becomes more of a management task to juggle large composite keys. My threshold seems to sit at about 3, where anything over that bothers me enough to actually create a surrogate.
I agree. Played around with it, but ABCD_123.45 does not work in the URL
Right now it's like update.php?entry=123
update.php?entry=ABCD12345 would be best, but I have to store it as ABCD_123.45 in the DB
I tried to use regex with GET but could not figure it out.
For now, it is at least working well using the AI column, so perhaps I can work on that change later.
edit: trying to mark this thread as resolved but.. how? can no longer edit OP