Community Questions & Answers

DB caching issue

Hi, I have two windows, each opens by it's tabs. Both windows has table views and data is driven by two tables in SQLite Database. Once i go to first window,(default) i need to do some operations and that will effect the data in the window 2. How ever...

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

Storing data as JSON in a file or in a database.

Hey! I'm building an app where I need to store some data fetched from a remote web service. I had planned on storing as json instead of in a sqlite database, but I'm just wondering if this is a good thing to do? There's no real reason to it other than...

Uploading an image from iOS App

I am trying to upload an image from my camera roll to my server. The php code works fine by itself but I can't get to upload the image from my app. I always get a 404 error. PHP Code ~~~ <?php $allowedExts = array("gif", "jpeg",...

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

database.open() sometimes cause app crash

Hi I have strange problem. sometimes 1 of 20 calls when I try to open database in my program it will not open and cause app crash. sometimes same code is working and sometimes it is not working that is werid. problem occurs on android with titanium...

Display data from remote DB

Hi, i'm begineer on titanium's developpement. I have a tableview contains list of persons' name retrieved from remote database. when i click on each row of my tableview, i want to display only one information from remote database associeted for this row...

Unable to alert the distance (km)

Hi, any expert can explain to me why i will getting 'undefined' is not a function (evaluating 'e.toRad( )') ? Below is my code . hope anyone can assist me. Thanks ! ~~~ var lat1, lon1, lat2, lon2; Number.prototype.toDeg = function() { return this * 180...

Alloy - Data Migration

[docs](http://docs.appcelerator.com/titanium/latest/#!/guide/Alloy_Sync_Adapters_and_Migrations) It is confusing. How does Alloy know which version the previous database is? The docs only says Alloy applies mirgrations from the oldest to the newest. If...

Save remote JSON data into SQLite for offline use

Env ====== ~~~ Application type: mobile Titanium SDK: 3.2.1GA Platform & version: iOS 7.0, Android 4.0+ Device: iOS simulator, Android emulator Host Operating System: OSX Mountain Lion Titanium CLI: 3.2.1 ~~~ Problem ====== Only been using Titanium...

Databinding with Groups of Data

Hi, I have a model that features an 'input' column—let's call it a question. Each question is related to a single workspace. A workspace can have multiple questions. I want my app to start up and show a list of all the names workspaces, but not...

Image store and retrieve

Hi, How to store and retrieve image in database through webservice? In database image field type is varchar. I am using alloy framework and titanium sdk version 3.2.2.GA. Please help me. Thanks, Ankita

Alloy Database Model

I'm using Alloy's Model for databases. Is there a standard way to set the database's remoteBackup to false in Alloy? Meaning I don't want it backed up to iCloud.

Alloy Database Migration

[docs](http://docs.appcelerator.com/titanium/latest/#!/guide/Alloy_Sync_Adapters_and_Migrations) For example I have migration files for version 1 to version 7. When installing the app on a device that has version 6 database already, does Alloy apply just...

How to download data from remote database.

Hi, I have a webpage, and in it, a database. I want to download some data from my webpage to an app. Is it possible? How can I achieve this? What im trying to do, is download the information, and populate a TableView with it, I know how to populate it with...

Using databases with CommonJS

Hi, I have a CommonJS module for a text area where the user can input the name of a task. In my app, I am wanting to have multiple windows for different task groups(such as art or design) that include this text area. However, I am wanting to save each...

Login with sqlite

i wanna create a login window with sqlite but it,s error var db = Ti.Database.install('../login.sqlite','users'); var db3 = Ti.Database.open('users'); if (username.value === db.execute('SELECT username FROM users')) { alert('You logged...

Two Dbs in one alloy titanium application

How can i have two dbs in a titanium application which uses alloy framework? Do i have to create two models for each? How are the models and db related? I am new to titanium, and have gone through the docs but didnt really follow everything.

Access DB data

I still have some problem using ALLOY models and collections. this is a part of my alloy.js ~~~ Alloy.Collections.temp = Alloy.createCollection('temp'); ~~~ this part of index.js ~~~ var t = Alloy.Collections.temp; var tm = Alloy.createModel('temp',{ ...

LOCAL DB simple question

First of all, please understand I'm new on Titanium. I've read all documentation and look at many example, but I can't understand the basis: If I have this ALLOY model (temp.js): ~~~ exports.definition = { config: { columns: { "cod":...

Showing 1-50 of 1,210 1 2 3 4 5 625