cvboucher
Posts: 191
|
| Posted: 01/23/2013, 10:09 PM |
|
CCS5, VB.Net InMotion/SQL Server
I was working on a report and realized that IN is no longer a Condition option for a Table Parameter. I tried changing the query type to SQL and used IN, but I get an error on the published page.
I'll open a ticket.
Thanks,
Craig
|
 |
 |
Oper
Posts: 1195
|
| Posted: 01/24/2013, 6:34 AM |
|
Confirmed in CCS5.
I did not noticed before because we always use the IN at the BeforeBuild Select Event.
I will wait for your reply on this. Good Catchj.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
cvboucher
Posts: 191
|
| Posted: 01/24/2013, 1:15 PM |
|
Here's the response I got back from Yes.
Quote :the "IN" condition was excluded from CCS 5 for certain reasons. Please switch the Data Type to SQL and you may provide any SQL statement manually. You may also consider using solution from the CCS help article "Retrieve Values From a Multi-Select ListBox"
Craig
|
|
|
|
Oper
Posts: 1195
|
| Posted: 01/24/2013, 1:27 PM |
|
well at least they reply fast:
Really a problem for Project Upgrade i guess
ASP
Function Tasks_DataSource_BeforeBuildSelect(Sender)
' "s_Project" contains the comma delimited string with the selected values
if CCGetParam("s_Project", Empty) <> Empty then
If Tasks.DataSource.Where <> Empty Then _
Tasks.DataSource.Where = Tasks.DataSource.Where & " AND "
Tasks.DataSource.Where = Tasks.DataSource.Where &_
"task_project_id IN ("&CCGetParam("s_Project", Empty) &")"
End if
End Function
PHP
function Tasks_DataSource_BeforeBuildSelect(& $sender) {
global $Tasks;
$s_Project = CCGetParam("s_Project", "");
if (count($s_Project) > 0 AND is_array($s_Project)) {
foreach ($s_Project as $key => $value) {
if ($Projects != "") $Projects = $Projects.",";
$Projects = $Projects.$value;
}
if ($Tasks->DataSource->Where != "")
$Tasks->DataSource->Where .= " AND ";
if ($Projects != "")
$Tasks->DataSource->Where .= " tasks.project_id IN (".$Projects .")";
}
}
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
