How to get components and data from an ItemRenderer of a List in Adobe Flex 3

var tl:TileList = TileList( event.currentTarget );
var thumb:Thumbnail = Thumbnail(tl.indexToItemRenderer(ind));
var img:Image = thumb.image;

Read Full Post »

Sql Server 2000 progressive index or row number select query

SET NOCOUNT ON

CREATE TABLE #RowNumber (
RowNumber int IDENTITY (1, 1),
emp_id char(9) )

INSERT #RowNumber (emp_id)
SELECT emp_id
FROM employee
WHERE job_id = 10
ORDER BY lname

SELECT RowNumber, e.emp_id, lname, fname, job_id
FROM #RowNumber r JOIN employee e
ON r.emp_id = e.emp_id
ORDER BY RowNumber

DROP TABLE #RowNumber

SET NOCOUNT OFF

Read Full Post »