var categoryArray = [];
var catRows = [];

// populate category array from database
if (categoryArray.length == 0) {
	var db = Titanium.Database.open('contentDB');
	var dbrows = db.execute('select category_id, category_name from categories order by category_name asc');
	while (dbrows.isValidRow()) {
	    categoryArray.push({
	    	catid:dbrows.fieldByName('category_id'),
	    	title:dbrows.fieldByName('category_name')
	    });
	    Ti.API.info("Found category: "+dbrows.fieldByName('category_name')+" ["+dbrows.fieldByName('category_id')+"]");
	    dbrows.next();
	}
	dbrows.close();
	db.close();
}

// category table view
for (var c=0;c<categoryArray.length;c++) {
	var row = Ti.UI.createTableViewRow({height:40,backgroundColor:'#ffffff',selectedBackgroundColor:'#eeee33',hasChild:true});
	var item = categoryArray[c];

	row.catname = item.title;
	row.catid = item.catid;

	var catName = Ti.UI.createLabel({
		text: item.title,
		color: '#334499',
		textAlign:'left',
		left:4,
		top:8,
		height:'auto',
		font:{fontWeight:'bold',fontSize:20}
	});

	row.add(catName);
	catRows[c] = row;
}


var search = Titanium.UI.createSearchBar({
    barColor:'#000',
    showCancel:true
	//autocapitalization:Titanium.UI.TEXT_AUTOCAPITALIZATION_ALL
});


var categoryTableView = Titanium.UI.createTableView({
	data:catRows,
	search:search,
	searchHidden:false
});

Titanium.UI.currentWindow.add(categoryTableView);