kwhinnery/localDBPicker.html

## localDBPicker.html
<html>
<head>
	<script>
	window.onload = function() {
		var db = Titanium.Database.open('mydb');

		//Create an populate database
		db.execute('CREATE TABLE IF NOT EXISTS DATABASETEST  (ID INTEGER, NAME TEXT)');
		db.execute('DELETE FROM DATABASETEST');

		db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',1,'Name 1');
		db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',2,'Name 2');
		db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',3,'Name 3');
		db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',4,'Name 4');

		//Fetch Database rows and put them into a picker data set
		var rows = db.execute('SELECT * FROM DATABASETEST');
		var col1 = {
			width:120,
			data:[]
		};
		var col2 = {
			width:120,
			data:[]
		};
		while (rows.isValidRow()) {
			col1.data.push({
				title: rows.fieldByName('id'),
				fontSize:20
			});
			col2.data.push({
				title: rows.fieldByName('name'),
				fontSize:20
			});
			rows.next();
		}
		// close database
		rows.close();

		//Create picker
		var picker = Titanium.UI.createPicker({id:'picker',data:[col1,col2],selectionIndicator:true});

		//Show current picker values
		picker.addEventListener('change', function(e) {
			document.getElementById('value').innerHTML = 'column ' + e.column + '<br/> row ' + e.row + '  value[1] ' + e.selectedValue[0] + ' value[2] ' + e.selectedValue[1];
		});

	};

	</script>

</head>
<body style="margin:0;padding:0;font-family:Helvetica Neue;background-color:#fff">
	<h2>Picker/DB Demo</h2>
	<div>
		Value: <span id="value"></span>
	</div>
	<div id="picker" style="position:absolute;bottom:0;height:217px;"></div>
</body>
</html>
	<html>
	<head>
	<script>
	window.onload = function() {
	var db = Titanium.Database.open('mydb');

	//Create an populate database
	db.execute('CREATE TABLE IF NOT EXISTS DATABASETEST (ID INTEGER, NAME TEXT)');
	db.execute('DELETE FROM DATABASETEST');

	db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',1,'Name 1');
	db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',2,'Name 2');
	db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',3,'Name 3');
	db.execute('INSERT INTO DATABASETEST (ID, NAME ) VALUES(?,?)',4,'Name 4');

	//Fetch Database rows and put them into a picker data set
	var rows = db.execute('SELECT * FROM DATABASETEST');
	var col1 = {
	width:120,
	data:[]
	};
	var col2 = {
	width:120,
	data:[]
	};
	while (rows.isValidRow()) {
	col1.data.push({
	title: rows.fieldByName('id'),
	fontSize:20
	});
	col2.data.push({
	title: rows.fieldByName('name'),
	fontSize:20
	});
	rows.next();
	}
	// close database
	rows.close();

	//Create picker
	var picker = Titanium.UI.createPicker({id:'picker',data:[col1,col2],selectionIndicator:true});

	//Show current picker values
	picker.addEventListener('change', function(e) {
	document.getElementById('value').innerHTML = 'column ' + e.column + '<br/> row ' + e.row + ' value[1] ' + e.selectedValue[0] + ' value[2] ' + e.selectedValue[1];
	});

	};

	</script>

	</head>
	<body style="margin:0;padding:0;font-family:Helvetica Neue;background-color:#fff">
	<h2>Picker/DB Demo</h2>
	<div>
	Value: <span id="value"></span>
	</div>
	<div id="picker" style="position:absolute;bottom:0;height:217px;"></div>
	</body>
	</html>