Community Questions & Answers

i tried to create local database to test from it my code is functionality. this line of code make to me problem when i changed my database to mysql database ~~~ var myResultSet = coldDB.execute('SELECT Name,Id FROM problems'); while...

Greetings, I am developing for Android. My app uses a database, and of course I query it to get resultsets. At the moment, I convert the resultset to an array which is returned from the database accessor function and this is working fine in...

I´m actually trying to fetch some data from the underlying sqlite database on iPhone platform. This does work pretty well, indeed. This works for simple text only. Multiline (with \n and \r) does not. Does someone know how to solve this, how to make...

in app.js ~~~ Titanium.Database.install('highScores.sqlite','highScoresDB'); ~~~ in scores.js ~~~ var db = Titanium.Database.open('highScoresDB'); var scores = db.execute('select * from scores'); Ti.API.info(scores.rowCount); ~~~ console prints 0! In...

Hi, I'm trying to access the results of a database query that subtracts two values from a table & returns a result based on the simple math. The returned result isn't in any existing tables, it's just a number selected via a bunch of `CASE` statements...

Hello everyone! I'm trying to do some apps that uses SQLite in Android. Recently I had received some handy help but I think that this time I wont have that luck... After making a query to my SQLite database, in iOS works OK so I have no problems. But in...

Hi all, I am trying to write a desktop app in HTML/Javascript which reads some rows from a table an populates an HTML table with the data. However, nothing happens after the db.execute() statement, and no errors messages are reported. Here's the...

Hi all, I have an app that is trying to pull data from a local database. I've connected to the database and can pull data when the SQL query is based on the primary key but I've been trying to run the same query on a different integer column and it...

Is there a way to get the column names and types from a RecordSet object? I need to know so I can create some XSD entries to send a diffgr:diffgram SOAP request to a .Net SOAP service.

I upgraded to 1.3 and now the first 1000 rows from my database are not returned. Is there a tableview limit in 1.3? The SQL statement I am using works just fine in my database manager, returns everything. I put some debug checks to see the row count. Row...

Is there any way to reuse a resultset of a query?? What i have observed is, when resultSet.next() is used to access the result of a query, i cannot use the resultSet again after all the rows fetched are accessed using next(). Is there any way to reuse...

Trying to build an universal database helper class, I noticed two problems with Ti.Database.ResultSet on iPhone (using Ti 1.2.0 SDK, as 1.3.0 makes the app crash upon startup). 1. I had to use rows.getFieldName( int ) instead of rows.fieldName( int ), as...

I am trying to process data returned from a db.execute "SELECT' query within the returned ResultSet object. I have a couple of questions: 1. Does the ResultSET...