DAVID
|
Posted: 01/17/2003, 6:55 AM |
|
Area: Search grid
Problem: When using ListBox with 'multiple' attribute, CodeCharge Studio
Ignores Multiple entries and uses only the first array element.
Solution: add Integer,Float,Text,Date array (multiple) types
ccsmInteger
ccsmFloat
ccsmText
ccsmDate
...
change function Operation to allow SQL IN operation:
a) based on Mtype gbquote strings and dates
b) build a SQL IN statement. E.G.
} elsif ($Operation eq $opIn ){
$Result = $FieldName . " IN ( ". $SQLValue
.." )";
}
to look like
WHERE
...
SOMECOLUMN IN (1,2,4,6,8,)
e.g.
SELECT * FROM PRODUCTS
WHERE CATEGORY_ID IN ( 1,5,7,322,4)
AND LAST_UPDATE IN
('2002-12-12','2002-12-14','2002-12-21')
|
|
|
|