ricardoalcocer

Ti.Database.install('/dbname.sqlite','dbname');
var mydb = Ti.Database.open('dbname');
	
var sql="SELECT ..... ";
var RS=mydb.execute(sql);
        
var data='';
while(RS.isValidRow()){
    data += RS.fieldByName('fieldname') + ' - ';
    RS.next();

ricardoalcocer

Based on Alloy
==============================

index.js
==============================
var h=require('http').HTTP;
var http=new h();

http.get('http://div1.ceepur.org/REYDI_NocheDelEvento/data/GOBERNADOR_ISLA.xml',function(data){
	try{

ricardoalcocer

var http = require('http');

var options = {
  host: 'query.yahooapis.com',
  port: 80,
  path: '/v1/public/yql?q=select%20*%20from%20html%20where%20url%3D%22http%3A%2F%2Fclasificadosonline.com%2Fm%2FMiscellaneosSearchM.asp%22%20and%0A%20%20%20%20%20%20xpath%3D%27%2Fhtml%2Fbody%2Fdiv%2Fdiv%2Fdiv%2Fform%2Fselect%27&format=json&diagnostics=true&callback=',
  method: 'GET'
};

var req = http.get(options, function(httpObj) {

ricardoalcocer

function showWin1(e) {  
    var w=Alloy.createController('win2').getView();
    w.open();
}

$.index.open();

ricardoalcocer

function showItems(e) {  
    Ti.API.info(e.rowData.itemName);
}

$.win.open();

ricardoalcocer

function showItems(e) {  
    Ti.API.info(e.rowData.itemName);
}

var rowData=[];
for(var i=1;i<=10;i++){
	var payload={
		rowId:i,
		itemName:'Test' + i
	}

ricardoalcocer

var args = arguments[0] || {};

$.rowId.text=args.rowId;
$.itemName.text=args.itemName;

function closeme(){
	$.win.close();
}

ricardoalcocer

function doClick(e) {  
    alert($.label.text);
}

function showmenu(e){
	$.main.animate({left:200,duration:100});
}

function hidemenu(e){
	$.main.animate({left:0,duration:100});

ricardoalcocer

{block:Title}<a href="{Permalink}" title="{Title}">{Title}</a>{/block:Title}

ricardoalcocer

<?xml version="1.0" encoding="UTF-8"?>
<ti:app xmlns:ti="http://ti.appcelerator.org">
  <id>ti.hackpr1</id>
	<name>hackpr1</name>
	<version>1.0</version>
	<publisher>not specified</publisher>
	<url>not specified</url>
	<description>not specified</description>
	<copyright>not specified</copyright>
	<icon>appicon.png</icon>