CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Proposed feature for the new version of CCS (multiple select)

Print topic Send  topic

Author Message
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')




   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.