Hi all...
I am having a problem with unique key violations in one of my tables.
This is the table structure:
CREATE TABLE `optionaldata` (
`ForeignID` int(10) unsigned NOT NULL default '0',
`FieldID` int(10) unsigned NOT NULL default '0',
`Value` char(200) default NULL,
UNIQUE KEY
() function was irreversible.
Therefore I am left with no choice but to use a deprecated function...
which I really don't want to do...
What do you suggest?
Regards,
Matt Parlane
Modus Consulting
sql,query
-
Before posting
Description:
The password function does not work as intended with latest 4.1 tree
(today's). It returns a string of LENGTH() = 45 starting with a *
(asterisk) and 44 alphanumeric characters /[a-z0-9]/
How-To-Repeat:
Using latest 4.1 BK tree, SELECT PASSWORD('something');
Fix:
Not
~~
If you need any more info, please get back to me.
Thanks,
Matt Parlane
__
_ _
|__ /_ _(_)
/ // _ \ \ / / |
/ /| __/\ V /| |
/\___| \_/ |_|
__
Web: www.zevi.net
Email: [EMAIL PROTECTED]
Phone: 04 902 5777