Deleting Records

Archived from the Xataface Users forum.

almatesic — Tue Dec 30, 2008 11:17 am

To give a background my i have my column username as the primary key and it being unique. So lets say i have the following usernames…

bigal

bigal.albino

bigal.albino.matesic

tallecreative

dell

Now i would like to only delete the record with the username “bigal”, but what happens is it deletes all that contains bigal in the username. Basically the first 3 usernames would be deleted.

What i think is happening is the query to delete the record contains a LIKE in the statement instead of it containing EQUAL. I can’t seem to locate the delete query. Also I might be wrong too. If so, please correct me.

Thanks in advance,

Al

---

shannah — Tue Dec 30, 2008 12:06 pm

Thanks for posting this. I have added this issue to the issue tracker and released a patch for the problem.

http://bugs.weblite.ca/view.php?id=454

I have also posted an announcement in the news section.

Long story short, you should replace your version of Dataface/DeleteForm.php with the one at

http://weblite.ca/svn/dataface/core/tru … teForm.php

-Steve