Jeff Swanson
|
| Posted: 07/24/2002, 1:41 PM |
|
CC 2.x, PHP, mySQL
I have noticed that I cannot "Allow Sorting" if I use custom SQL statements. Any way around this? The SQL statements I use, get the data the way that I want, but I also want the user to be able to click on the top of a column to resort by that column. Here is my SQL statement:
SELECT `rookies`.`yes_no`,
`race_stats`.`kart_no`,
`drivers`.`name`,
SUM( `race_stats`.`final_points` ) AS total_points
FROM `race_stats`
INNER JOIN `rookies` ON (`race_stats`.`rookie` = `rookies`.`rookie`)
INNER JOIN `drivers` ON (`race_stats`.`racer_id` = `drivers`.`racer_id`)
WHERE
(
(`drivers`.`class_id` = 1)
)
GROUP BY `rookies`.`yes_no`, `race_stats`.`kart_no`, `drivers`.`name`
Anything?
|
|
|
 |
Nicole
|
| Posted: 07/26/2002, 4:50 AM |
|
Jeff,
as far as you use custom sql, you add custom code to form Open event to be able to sort on the table columns. The code is similar to one that is generated by CC. You can take it as sample one from any generated grid form.
|
|
|
|
|
