Community Questions & Answers

Save on db with Alloy

Titanium Studio, build: 3.3.0.201407100905 Mac OSX Mavericks 10.9.5 Titanium SDK 3.3.0 Platform: Android Device with 4.3.1, iOS Device (versions 7 and 8) I've got a problem in my controller when I try to save on internal sqlite db. I create the model...

SQLite update query

Hello all. I am new to Titanium Alloy development but not new to Javascript. I have been trying to work with SQLite in a Titanium Alloy application. The SQLite insert and create DB queries work fine. However my update query is not working at all....

opening sqlite db on external storage

Hi experts, Does Titanium really support opening sqlite database on the external storage ? Very simple code as below makes 'File appdata:///test.db contains a path separator' run time error. ~~~ hdbImp = Ti.Database.open(...

The usage of Alloy.Collections

Hi everyone, I was wondering about the usage of Alloy.Collections. I just started my first app using sqlite. I installed my sqlite DB, saved my data on one of the tables, and everything worked fine. Then, I wanted to know more about the usage of sqlite...

Sql no such table?

Titanium Studio: 3.2.3 ios: 7 I created an app with a pre-populated sql file. This is working fine and is now in the appstore in fact. The problem is I forgot to add a version table. So, I added a 'version' table in the next update. The way I plan of...

Using Backbone.js query in fetch

Hi, I have the following code to query name and date columns in my db. The dates are stored as strings. However, when I query for a date no result set is returned. But if I run the same query in SQLite Professional I get a result set: ~~~ curPage =...

Titanium Database Confusion

I'm fairly new to Titanium development (but not Javascript) and unfortunately inherited a very complex application right before another contractor was let go. This is an iOS application. My question, and confusion, stems with how the databases in this...

SQLite SELECT with LIKE condition help

Hi, Im trying to filter my sqlite database, but I get an error when I try to filter using LIKE conditions. **SQL sentence:** var resultSet = conn.execute("SELECT DISTINCT(nombre) FROM elementos WHERE nombre LIKE '%?%' ORDER BY nombre ASC",...

order by date

i am saving created date as TEXT in DB,.HOw can i display items from table order by date like SELECT * from seting order by date i more query like select * from setting where date=="" (condition here)..How can i implement in titanium plez...

How to attach SQLite databases?

I am trying to create a separate db to save favorites, so that when I update the main database that it the favorites are not written over. Also, I want to save favorites and notes to cloud. I have been trying the following along with several variations...

Upgrade sqlite database

Hello, I have an alloy application with a preloaded sqlite database inside. Is there a way to upgrade this database with a newer one when the user who has installed my app is online? Do i have to update the whole app (uploading a new version on play...

sqlite possible to call row by variable?

wondering if its possible to use a variable string to declare a row in an sqlite statement. for example ~~~ ('UPDATE measurements SET row1=?', row1.value); ~~~ so row1 would be a value saved from a labels text, and it also refers to the row name in my...

Alloy SQLite DB

Hello, I am just trying to select only one field from table. Below code works and it returns whole row. ~~~ var subscribers = Alloy.Collections.subscriber; subscribers.fetch({query:'SELECT * from subscriber where id="' + args.id +...

sqlite adding a batch of rows to a db by date

Hi, I'm trying to run a function that: 1. when called it inserts or replaces new rows into a sqlite db, all it has to do for now is add the row by date. I'm trying to write a loop function that does this but seem to be running into some confusion about...

SQL Alloy translation

~~~This seems simple but... where titledb is the column name. Classic: var db = Ti.Database.open('myDB'); var grabData = db.execute('SELECT titledb FROM myTableInDb'); To Alloy sync adpater: var library =...

Autocomplete with AJAX?

Hi guys, I googled a bit around and I saw that jquery was supported in Titanium Mobile in the past and of course still is inside a Webview, which would also work for my problem, but maybe there is another solution for this task: I have a database which...

invalid number of rows error at TableView

Hi Guys, I m facing strange problem .I m using Titanium 3.2.3 and developing for ios 7 .I have sqlite database. I m taking photo and storing path to sqlite database. after that I m adding this photo to tableview.But the problem is When I load app first...

Sqlite select send parameter

I m working Titanium 3.2.3 and developing for ios 7.My problem is ~~~ // its working var query=db.execute("Select * from photos order by tarih desc limit 5 offset 0"); // When I do this its cannot work .Where I missing? var...

Showing 1-50 of 831 1 2 3 4 5 617