Community Questions & Answers

Database Select not working

Hi, This is my Titanium studio version : Version: 3.4.0.201409261227-827bFA2FF7cLVuUtuFNtX8GB189I I created a simple database with SQLite manager and exported it to the ../app/assets/android folder and try to install it and query it from the code of my...

A problem with my database

var db = Ti.Database.open('plandb'); createDatabase(); function createDatabase() { db.execute('CREATE TABLE IF NOT EXISTS plan(title TEXT, image1 TEXT, image2 TEXT, description TEXT, reps TEXT, sets TEXT)'); var result = db.execute('SELECT * FROM...

app database

hello everyone, I want to make an app for iOS and android. I have titanium version 3.4.0.201409261227. I have mac osx 10.9.5. I want to make an app where people can meat each other so i need to make something where they can log in ,login with Facebook and...

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

Data Storing

I need to save my data i.e name,address in a database..I gone through Sqlite database but i cant find my solution.I have planned to go for parse.Is it correct?suggest me a idea

list-view problems

Hi I've found the problem project My project includes a book with a great list of titles and each title contains the following But I find it difficult to carry out the project and the database link is Manually coding the project after project until I'd...

Copy data from local DB to MySQL DB

Hi, I have a local database were the user can store data, but in some cases I would like to copy data from the local database to a MYSQL database that I have. Is this possible to do? So I would like to: mysqli_connect to my mysql database and copy...

Database issue

Application type:mobile,Titanium sdk:3.3.0 GA,Titanium studio:3.3,platform:android and ios,OS:Mac OSX 10.9.3 Hi, When I am trying to access the database for the first time its saying no such table exists but after it works fine: Any wrong in my...

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

External database choice MsSQL or MySQL

Hi all, i'm starting the design of a mobile app that will be connected to an external DB. In this stage i'm projecting the DB and looking forward an hosting virtual server service. In your experience do you think that shoukd be better a Ms Windows Server...

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

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

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