Community Questions & Answers

Database not installing

I am trying to install a sqlist database in my app but for some reason, the database isn't being copied over as far as I can tell. I'm reusing code that works in another app but everything I try doesn't work. Can someone take a look and tell me what I'm...

Sync database on app start

Hello, I'm fetching the content for my app via an external source. This content is stored in a local database. Now I want the sync function (this function is checking for new content and saving it to the local database) to be executed on app start. I want...

Undefined when looping trough object

I'm querying all the records from a table in the database, like: ~~~ var news_arr = Alloy.createCollection('news'); var table = news_arr.config.adapter.collection_name; news_arr.fetch({query:'SELECT * from ' + table + '...

Re-populate picker

Application type: mobile Titanium SDK: 3.2.3 Platform & version: iOS 7 Device: iOS simulator Host Operating System: OSX 10.9.3 Hi guys, I have this app-on-the-way that has textfield with picker, along with buttons on its toolbar. It allows me to add...

Android SQL adaptor

Just trying to develop my iOS app into an Android app, unfortunately getting halted at installing the database. I am getting the following error: ~~~ [ERROR] V8Exception: Exception occurred at alloy/sync/sql.js:290: Uncaught config.adapter.idAttribute...

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

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.

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

How can I save website visited by Webview?

How can i save the whole webpage (I mean all css, images, e.g.) to access when the device goes offline? I have been searching for all morning but i found something i thought it would be helpful. - someone told to use the HTML5 manifest // yes, but it can...

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

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