in reply to DBI execute() args in array format (or similar) possible?
The "1=1" part enables you to add a dynamic number of "And " clauses without any problems...$sql = "select clli, traffic_date, count(distinct(traffic_hour)) from gvc_traffic30 where 1=1 "; $sql .= " and traffic_Date in ($date_ref_args) " if ( $date_ref_args ) +; ...etc...
|
---|