Thursday, February 17, 2011

Get single record per group in Foxpro

SELECT f.* from (SELECT country, min(id) as MinId FROM mytable GROUP BY country) as X INNER JOIN mytable as f ON f.country = x.country AND f.id = x.MinId order BY f.country

Monday, January 31, 2011

id of selected RadioButton

To get ID of Selected RadioButton using jQuery (change nameOfRadio to actual radio name)
var id = $("input:radio[name=nameOfRadio ]:checked").attr('id');