DAVID
|
| Posted: 01/17/2003, 7:01 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')
|
|
|
 |
DAVID
|
| Posted: 01/20/2003, 4:22 AM |
|
I see that absolutely no one is interested.
"DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
news:b095sj$r1c$1@news.codecharge.com...
> 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')
>
>
>
>
>
|
|
|
|
Doru Apostolescu
|
| Posted: 01/21/2003, 2:20 AM |
|
Please refer your proposed feature (bug) to CodeCharge support, at
http://support.codecharge.com
--
Doru APOSTOLESCU
Certified NT Admin
TEHNOPLUS Ltd.
doru@tehnoplus.com
"DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
news:b0gpm9$1mf$1@news.codecharge.com...
> I see that absolutely no one is interested.
>
>
> "DAVID" <codecharge_newsfeed@stridetech.com> wrote in message
>news:b095sj$r1c$1@news.codecharge.com...
> > 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')
> >
> >
> >
> >
> >
>
>
|
|
|
|
|
