<--- --------------------------------------------------------------------------------------- ----
Blog Entry:
Ask Ben: Building A jQuery And ColdFusion Rating System
Author:
Ben Nadel / Kinky Solutions
Link:
http://www.bennadel.com/index.cfm?dax=blog:1629.view
Date Posted:
Jul 6, 2009 at 3:10 PM
---- --------------------------------------------------------------------------------------- --->
SELECT
i.id,
(
CASE
WHEN
COUNT( r.rating ) > 0
THEN
(
SUM( r.rating ) /
COUNT( r.rating )
)
ELSE
0
END
) AS rating,
COALESCE( er.id, 0 ) AS has_existing_rating
FROM
(
SELECT 1 AS id UNION ALL
SELECT 2 AS id UNION ALL
SELECT 3 AS id
) AS i
LEFT OUTER JOIN
rating r
ON
i.id = r.image_id
LEFT OUTER JOIN
rating er
ON
(
er.image_id = i.id
AND
er.ip_address =
AND
er.user_agent =
)
GROUP BY
i.id,
r.image_id
ORDER BY
i.id ASC
jQuery And ColdFusion Rating System Demo
jQuery And ColdFusion Rating System Demo
-
Rating: #numberFormat(
image.rating,
"0.0"
)#