unique login id enforcement?

[tom wible]

my user table id field is specified as unique, natch, but entering an existing value results in the unhelpful message

Duplicate entry in table 'users'

as there is more than 1 field and the user has no idea where the error is...any way to fix this?

[Steve Hannah]

You can add your own custom validator and supply your own error message if it fails.

http://xataface.com/wiki/fieldname__validate

[tom wible]

thanx, where do get the database unique error status? i assume

function myfield__validate(&$record, $value, &$params)

is called before the insert is attempted...

[Steve Hannah]

You'll need to check the uniqueness using an SQL query inside your validate method.  The database error is thrown by MySQL and it doesn't provide specifics as to which constraint was violated, just that it was a uniqueness constraint.

Steve

--
Steve Hannah

Web Lite Solutions Corp.

[tom wible]

Steve Hannah wrote:
> You'll need to check the uniqueness using an SQL query inside your validate
> method. The database error is thrown by MySQL and it doesn't provide specifics
> as to which constraint was violated, just that it was a uniqueness constraint.

thanx, steve, i'll go that way...just wondering: where is the sql error caught?

[Steve Hannah]

The SQL error is caught when the SQL is executed in MySQL.  Xataface attempts to run the INSERT statement, and when it receives the "DUPLICATE" error code, it propagates the error up.  It actually occurs here

https://github.com/shannah/xataface/blob/master/Dataface/IO.php#L684

Steve