My Question
(Short version)
Can anybody tell me how to capture MySQL error and pass it to end
users?
Is there something like $this->set('db_error', some-built-in-function-
to-get-db-error-msg-as-a-string) in Cake?
PHP has mysql_error function, which returns mysql error msg as a
string. Is there a counterpart in Cake?
Thanks
(Verbose version)
For example, I have two tables
Table 1 (Entry)
id
entry_title
author_id
Table 2 (Author)
id
author_name
I have set referential integrity rule on these two tables.
Obviously, I cannot add an entry that its author_id does not exist in
Author table.
If trying to do this in MySQL, I will get a #1452 error, which tells
me DB cannot add or update a child row because a foreign key
constraint fails.
What I want is :
1) (bottom line) Get this #1452 error, pass the error message to users
or
2) (preferred) Get this $1452 error, rephrase it with the language
that an ordinary user can understand
To do 2), I think I need a dictionary to translate MySQL's built-in
error msg to user friendly language, which seems to be a time
consuming job
So my current expectation is to do 1)
How shall I do?
Thanks,
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
