Data dodania Pytanie
2016-10-05 12:10 Exception Invalid Limit Clauses - Android »
I am trying to put json object in sqlite database private void addList(String info){ try { JSONObject reader=new JSONObject(info)...
(1) odpowiedzi
2016-10-05 09:10 How to delete rows from recyclerView and sqlite database both? »
I'm creating an app with recycler view and SQLite database. When user enters some data, it is displayed in recycler view and also added to my database...
(2) odpowiedzi
2016-10-01 15:10 Accessing a certain downloaded .sqlite database in external storage from an android app »
I am trying to implement an offline map feature in an android WebView-based app: Using DownloadManager, I download an sqlite database file (of a stru...
(1) odpowiedzi
2016-10-01 08:10 Service hitting in loop using AFNetworking in iOS »
I am working with AFNetworking and it is working fine . Its working fine. But I stuck in one condition when hitting my service in while loop. I have a...
(0) odpowiedzi
2016-09-21 09:09 Can't save my data into sqlite database »
I am trying to implement a Parking Permit application page using ROR. I couldn't get my data saved into the database. The permit database is associate...
(3) odpowiedzi
2016-09-21 08:09 nodejs + sqlite: query execution order »
With Sqlite with nodejs you can't take the call execution order equals to the real db execution order of a query. For example in this pseuso-code you ...
(1) odpowiedzi
2016-09-10 22:09 Kotlin Closable and SQLiteDatabase on Android »
I use such code in my project fun getAllData(): List<Data> = writableDatabase.use { db -> db.query(...) } It executes successfully on ...
(1) odpowiedzi
2016-08-29 14:08 Rails/Sqlite 3 - Displaying table data on page »
I'm very very very new to Rails, and I've got a fast approaching deadline to code my first rail app as part of a challenge. I've so far created the b...
(1) odpowiedzi
2016-08-22 10:08 Insert and read nsdata in swift to make http post »
I'm making an app that connects to a server that manages information in php. Through the app I upload images to the server , which then treatment in ...
(0) odpowiedzi
2016-08-22 10:08 Permission denied @ dir_s_mkdir Error - EDITED »
EDIT #2 I have managed to route the uploaded file to the correct directory, although am getting another routing error: No route matches [GET] "/User...
(0) odpowiedzi
2016-08-15 19:08 How can I import data from a REST call, json feed into a SQLite database on a MAC? »
I have data that's on my server in a SQL Server database. I can access that with a REST call into a C# ASP.Net Web.API that I have control over and it...
(1) odpowiedzi
2016-08-11 11:08 Database is locked while updating data in background »
I'm working on an application where I've to use sqlite and there are lots of data. I want to load data from "residents_status" column of a table named...
(0) odpowiedzi
2016-08-04 09:08 Cannot create entry »
Django version 1.10, python version 3.4 I type and execute this code in manage.py shell: from tweet.models import Tweet tweet = Tweet("Parse JSON li...
(2) odpowiedzi
2016-08-03 21:08 Can I define a DBIx::Class::ResultSource::View after connecting? »
I have a virtual table in DBIx::Class whose definition needs to differ depending on the deployment. If I deploy against sqlite3 I can use group_concat...
(0) odpowiedzi
2016-08-01 17:08 Laravel migration with SQLite »
I have migration in Postgres and SQLite, and I am facing problem with SQLite database. Same migrations are for 2 different databases. Postgres migrati...
(1) odpowiedzi
2016-07-30 11:07 Delete all tables from sqlite database »
I have done a lot of research and was unable to find a suitable method to delete all the tables in an SQLite database. Finally, I did a code to get al...
(2) odpowiedzi
2016-07-29 12:07 How to restrict to open sqlite datbase in Android library project while creating jar file »
I am creating Android library project in android studio and have dependent jar file inside library project. Main idea is that I can distribute that ...
(0) odpowiedzi
2016-07-28 10:07 Merging two branches, one with Postgres and another with SQLite3 »
Like the title says, I am building a rails app and switching over from SQLite3 to Postgres. I believe i have successfully made the switch over as all...
(1) odpowiedzi
2016-07-25 08:07 How to delete Multiple row from one table in sqlite iOS? »
I have a table, MessageTable in sqlite.I want to delete selected rows from it. How can I achieve that. I have searched hard but didn't get any suitabl...
(1) odpowiedzi
2016-07-22 04:07 Works in SQLite but not in PostGreSQL... attribute IS NOT 1 »
I have a statement in my code: RentalItem.last.maintenance_orders.where("status_id IS NOT 2").present? Works fine in development mode, but not in P...
(1) odpowiedzi
2016-07-17 05:07 SQLite Database issue in TextView »
I've been working on an app where the main Activity leads to CalendarActivity, which has a button leading to another Activity where the user creates a...
(2) odpowiedzi
2016-07-15 10:07 Django testing on separate database giving "OperationalError: no such table: auth_user" »
My problem is that I wanted to put up a separate testing database, separate from my development database. App itself is almost identical to Django-Res...
(1) odpowiedzi
2016-07-12 22:07 Referencing Table Entries in Rails »
I'm working on a project in rails where I have a database of products, and I'm looking to use forms to manipulate them. However, I'm having a great d...
(1) odpowiedzi
2016-07-08 21:07 Heroku: Rails 5 deployment - error during migrating db »
So I wanted to deploy my app to heroku, but it doesn't support sqlite3, so I set production to use postgres. I think the problem is that some migratio...
(1) odpowiedzi
2016-07-05 10:07 Efficient sqlite query based on list of primary keys »
For querying an sqlite table based on a list of IDs (i.e. distinct primary keys) I am using following statement (example based on the Chinook Databa...
(3) odpowiedzi
2016-06-18 01:06 How to sort based on two fields »
I have a product model with price and sale_price fields. I want to sort the records according to price in ascending order, but if a product has a sa...
(1) odpowiedzi
2016-06-09 14:06 Upgrading from Django 1.6 to 1.9: python manage.py migrate failure »
I'm running Django 1.6.6 on production and have recently upgraded to 1.9.7 on staging (dev server). This update was performed on the server and I foll...
(1) odpowiedzi
2016-06-02 18:06 Why does django need psycopg2 when I use sqlite? »
The title says all. It sounds like a very weird/impossible bug, but I've spent a couple of hours and still puzzled. My setup: Python 3.4 Django 1.9...
(1) odpowiedzi
2016-05-28 17:05 Query using LIKE isn't working using GreenDAO »
I have a table which a column is a string with three characters, each character has a value 0 or 1. I'd like to select those rows according to the cas...
(0) odpowiedzi
2016-05-15 23:05 Have three different search results using sqlite »
I am wanting to show a set of results based on what it's privacy type is. I am using lavavel 4.2, php, blade and sqlite. I have public, friends, and...
(1) odpowiedzi
2016-05-08 23:05 SQLite LEFT JOIN Usage is Not Working Correctly »
I have 3 TABLES. Costumer, Product and Stats. When user select a user and a product, i increase Stats->count by 1. Stats table has id, cid, pid and co...
(1) odpowiedzi
2016-05-08 19:05 Swift 2 sqlite - library routine called out of sequence »
I am using below code to insert records to sqlite. SQLite DB is already created and sqlite file exists in the right place. However, when i run my test...
(0) odpowiedzi
2016-04-27 19:04 Syncing local and Elastic Beanstalk database? »
I recently deployed a Django web app on Elastic Beanstalk. I have configured it so that I can access the Django admin interface online and add content...
(0) odpowiedzi
2016-04-22 21:04 Using OR operator with 2 placeholders with same value »
I am a newcomer to Android Programming and looking for some help with my query. I am trying to find all fixtures where the id of a selected team is eq...
(2) odpowiedzi
2016-04-18 14:04 App crashes if SQLite cursor has no results »
I have an app that uses a cursor to run an SQlite query. public Cursor totaltrips(){ Cursor cursor = database.rawQuery("SELECT * AS TTotal F...
(3) odpowiedzi