Community Questions & Answers

Infinite loop in SQLite - why?

I have a simple SQL statement in my iOS app, for SQLite, but it always goes into an infinite loop: genreSQL_TEST_ONLY = "select count(*) AS Counter from Movies_Genres"; rsTest = db.execute(genreSQL_TEST_ONLY); while...

Load data using HTTPClient or SQLite?

I've read [here](http://docs.appcelerator.com/titanium/latest/#!/api/Titanium.Network.HTTPClient) that HTTPClient is intended for a single request. Currently I'm using HTTPClient for multiple requests (getting several xml files from a server to create...

Fetch data from sql, Alloy

Well i just wanted to fetch data from persons table without using Query This is what im doing right now but i have no idea where i am wrong ~~~ function showPerson(event) { var selectedPerson = event.source; var recoverDatabase =...

sqlite troubles

hi im little stucked with a script in db where i select a number: ~~~ SELECT ('%.2f', FPRE_VALOR) as value FROM FIJACION_PRECIO"+ WHERE FPRE_ID ="+id ~~~ this fuction is like toFixed() in javascript for format a number in 2 decimals example:...

sqlite real issue

~~~ CREATE TABLE IF NOT EXISTS FIJACION_PRECIO( FPRE_VALUE REAL ); ~~~ i want store decimals numbers but dont allow me with the following case: '4.00' or 4.00 in field fpre_value but not storing the 2 zeros after dot what im doing wrong?

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 +...

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