getInitialDataMultiple does not deal with ') OR (' in $where parameter [message #1139] |
Wed, 24 October 2007 19:22 |
alrobertson
Messages: 9 Registered: October 2007 Location: Vancouver
|
Junior Member |
|
|
I have a LIST2 screen which has a nav button to call ADD4 on another table with the multiple selections from the LIST2 screen.
I then wanted to look up the selected records and use some of that data to make the new records.
if 2 lines are selected on the LIST2 screen, ADD4 gets $where = "( primaryfieldname='X' ) OR ( primaryfieldname='Y' )".
When where2array parses it in getInitialDataMultiple() it messes up.
I realize I can do something in _cm_initialize to grab it first but it would sure be nice if passing the above $where to where2array($where) would create:
array( primaryfieldname => array(X,Y) )
and then calling array2where() would put it to:
"primaryfieldname IN ('X','Y')"
if not, it would at least be good if some form of an array got through to _cm_getInitialDataMultiple($fieldarray).
Let me know if I am missing some other obvious solution. I am using 1.28.0
Thanks
|
|
|