![]() |
Suppress Database Error
vB results an error, when I try to delete a non existing row. DELETE FROM same_table AS a WHERE EXISTS (SELECT * FROM same_table AS b...) or @ before are not working. Any idea how to supress this error?
|
Will look at. Thank you so far.
|
Sorry I read column, not row. What is the goal of your sql-statement.
|
DELETE FROM database.table WHERE userid =$ LIMIT 1
So instead of updating, I prefer to delete and recreate this entry in this case, because I doesn't know, if this entry already is created. |
Delete all from table? Or is generation the condition "=$" your problem?
|
Quote:
|
It is a question of your error handling style.
You can use "Select count(userId) as userCount from table where userId=$", check if >0 and then delete. Or you can use directly "Delete form table where userId=$" But in the same way of my first (deleted) answer - I advice using vBulletin-Api (if your table is in the vB-DB). vB_dB_Query and the following classes (also for delete, insert, update) includes an property error for handling it |
All times are GMT. The time now is 10:48 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|