var tl:TileList = TileList( event.currentTarget );
var thumb:Thumbnail = Thumbnail(tl.indexToItemRenderer(ind));
var img:Image = thumb.image;
Advertisements
Posted in Actionscript on March 31, 2008| Leave a Comment »
var tl:TileList = TileList( event.currentTarget );
var thumb:Thumbnail = Thumbnail(tl.indexToItemRenderer(ind));
var img:Image = thumb.image;
Posted in SqlServer 2000 on March 7, 2008| Leave a Comment »
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