Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Problem with _cm_filterwhere, how can do this?
Re: Problem with _cm_filterwhere, how can do this? [message #1697 is a reply to message #1696] Tue, 23 September 2008 04:26 Go to previous messageGo to previous message
AJM is currently offline  AJM
Messages: 2367
Registered: April 2006
Location: Surrey, UK
Senior Member
If you are deleting records from the 'part_ent_xref' table then it is the 'part_ent_xref' object that should be the subject of the DELETE task. This means that the $where clause which is passed to the DELETE task will contain the primary key of each selected entry in the format:
field1='value1' AND field2='value2'


If there are multiple selections each primary key will be enclosed in parentheses and separated by ' OR ', as in:
(field1='v1' AND field2='v2') OR (...) OR (...)


I have similar tables (PERSON and PERS_OPT_XREF) in the XAMPLE prototype which is included in the Radicore download, and I do not have an problem in deleting selected entries.


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Force a PDF page break
Next Topic: _cm_listview_total() problem
Goto Forum:
  


Current Time: Mon Nov 18 20:47:07 EST 2024

Total time taken to generate the page: 0.01474 seconds