Data dodania Pytanie
2017-10-06 13:10 Why is Rails returning a different float value when using a different database? »
I have an app running Rails 4.2 with this migration create_table "nutrient_amounts", force: :cascade do |t| t.integer "nutrient_id", limit: 4 t.i...
(1) odpowiedzi
2017-10-04 10:10 'This is the 'bait'. You probably need to add one of the SQLitePCLRaw.bundle_* nuget packages »
I am using Entity Framework Core 2 in my application using SQLite as my database provider. I have added references to the following in my project: ...
(1) odpowiedzi
2017-09-28 17:09 Rails' ActiveRecord doesn't see tables in SQLite3 database after migration »
I did rake db:drop rake db:create and rake db:migrate. When I run sqlite console, I get the following: sqlite> .tables ar_internal_metadata grou...
(0) odpowiedzi
2017-09-28 15:09 errors replacing development.sqlite3 with another development.sqlite3 on rails »
I am trying out an example from a book head first rails, i get to chapter 2 and i have issues following the instructions maybe because they used an ol...
(0) odpowiedzi
2017-09-28 12:09 SQLITE order by numeric and not alphabetic »
When I order my database SQLITE by Classement I have this : Classement | Nom 1 | clem 10 | caro 11 | flo 12 | raph 2...
(2) odpowiedzi
2017-09-17 14:09 Select the row number X in SQLITE when order by desc »
I'm using SQLITE (so no row_number) Here is my database call : tableau ID | Nom | Score ---|------|------ 1 | Clem | 50 2 | Caro | 60 3 | Flo |...
(1) odpowiedzi
2017-09-10 23:09 Error when running cmd <rake db:migrate> - "No connection pool with 'primary' found" »
I'm trying to set up a SQLite Db for my sinatra app and am running into an error I can't figure out. I've looked up related questions but none of them...
(0) odpowiedzi
2017-09-07 19:09 SQL Combining Multiple SELECT Statements »
I am trying to build an SQLite query that will collect statistics from a single table. The table holds a log, of sorts, with several entries per day....
(3) odpowiedzi
2017-08-20 06:08 Update values of a specific column of a specific row. Android SQLite »
I have a recyclerview cardholder that inflates using the values of 'NAME' from the table 'ORDERTABLE'. The cardholder also have an EditText which disp...
(2) odpowiedzi
2017-08-18 19:08 Working with Scotty and Sqlite and having some trouble with the Monads »
Hi I a pretty new to Haskell and I have been working on a small web application with Scotty and Sqlite. I am having trouble performing Sqlite operati...
(1) odpowiedzi
2017-08-15 20:08 Does it matter in SQL whether conditions are grouped in case of a join? »
I do join 2 tables via SQL and add where clauses. The join is done by a condition in the where clause. I wonder if it makes a difference whether the w...
(3) odpowiedzi
2017-08-05 05:08 Saving to Core Data "The left hand side for an ALL or ANY operator must be either an NSArray or an NSSet »
When I try to save a relationship to core data it throws the above error in the title. I'm basically creating a messaging app and data model is attach...
(1) odpowiedzi
2017-08-05 01:08 SQLite Data Adapter not displaying data »
I'm trying to fill a data grid view in my windows form application but nothing is being returned from the database when I execute the select query. I'...
(2) odpowiedzi
2017-07-01 18:07 How to connect rails development.sqlite3 database for the single ruby file? »
I have a main.rb for Telegram bot. For creating Admin panel of the bot I have used the Rails. So now I want to connect from main.rb file to the datab...
(2) odpowiedzi
2017-06-24 13:06 Context Related Problems inside MVP presenter »
I am new to android MVP pattern and working on my project i have some basic problem related to Android Context in the presenter. Although there are ma...
(1) odpowiedzi
2017-06-17 11:06 Generating PHP Passwords for a database without PHP »
PHP includes a pair of functions to generate and validate passwords, using, I believe, BCrypt. This makes it easy to use password hashes stored in a d...
(2) odpowiedzi
2017-06-14 15:06 SQLite - Get records which is not start with alphabet - IOS - Objective C »
IOS - Objective C - SQLite Query. I want records from user table which is name start with a special character or digit or else (Not start with alphab...
(1) odpowiedzi
2017-06-10 22:06 Spatialite SQL query to find the nearest node for the given lat/lon »
I want to find the nearest node to a given coordinate. I checked this https://gis.stackexchange.com/questions/186783/how-to-get-the-long-lat-informati...
(1) odpowiedzi
2017-06-04 20:06 Android Java SQLite database: The database does not take 2 String inputs »
I am learing to code and made a stopwatch that saves the laptimes in a String and gets the date as a String as well. I want to put those in a SQLite d...
(2) odpowiedzi
2017-06-04 04:06 Is performing .ToList() more than once is a bad idea? »
I've written the below function to query the SQLite DB in my Xamarin forms app. But, since I have to call .ToList() twice, I'm not very confident abou...
(2) odpowiedzi
2017-06-03 21:06 Overwriting SQLlite Database on IOS »
So, i have a database.sqlite file, i used NSlog to know where is the file located, hopefully i got the location and the question is , i want to ove...
(2) odpowiedzi
2017-06-03 17:06 How to properly add custom database support to Laravel 5? »
Suppose you want to add custom database support in Laravel 5. Whether it is MongoDB, Oracle or sqlite mod (SQLCipher). How would you go about it? Wha...
(0) odpowiedzi
2017-06-01 13:06 How to change Rails database sqlite to mongodb »
Just started to make simple Rails apps. The default database is SQLite3 now, but I would like to switch to mongodb. Is there any simple way to expor...
(2) odpowiedzi
2017-05-26 07:05 Android 6.0 and above not clearing sqlite data from the phone after uninstalling the application »
In android 6.0 and above when you uninstall the application and install again the same application(same package) then it showing the old sqlite data, ...
(3) odpowiedzi
2017-05-19 18:05 Rails InvalidForeignKey »
I am developing a portfolio for my website, I decided to add skills to each portfolio item. class PortfolioSkill < ApplicationRecord belongs_to...
(1) odpowiedzi
2017-05-18 13:05 How to import Room Persistence Library to an Android project »
I recently saw the new feature announced on Google I/O Room Persistence Library to work with Sqlite databases on Android. I have been looking to the o...
(5) odpowiedzi
2017-04-25 03:04 Is it possible to take column names for sqlite database as input from user in an android app? »
I am creating an android app for my college faculties through which they will be able to keep and maintain the attendance of students in their lecture...
(1) odpowiedzi
2017-04-22 20:04 How to speed up SQL query with date GROUP BY? »
I have a normal SQLite database table called table1 with 7 columns and of course a rowid. The first column is an custom_id number, the second is date ...
(2) odpowiedzi
2017-04-18 14:04 Swift 2 iOS 9 and SqlLite »
I'm a new iOS programmer. I'm building a simple app with Swift. Now I want to insert a database to storage information of my app. I can't find any tu...
(3) odpowiedzi
2017-03-21 07:03 how to retrieve sqlite column values and store in to the array in objective c? »
Here is my code i am getting only the last value of the database in the array but i need the entire column values in my array... //select the values ...
(2) odpowiedzi
2017-03-18 00:03 How to display results from database in Sinatra using Sequel? »
I have an SQLite3 database called sk.db with a table called Sked that displays a schedule of sports matches with a column date. I am simply trying to ...
(1) odpowiedzi
2017-03-07 19:03 Setting up the Database on Heroku. bundler: failed to load command: thin , LoadError: cannot load such file -- dm-postgres-adapter »
so I'm trying to do some Sinatra tutorial (JUMP START SINATRA by Darren Jones - https://www.sitepoint.com/premium/books/jump-start-sinatra) And it wo...
(0) odpowiedzi
2017-03-07 18:03 Rails: Two 'where' queries - each works individually, but not together »
I want to write something like: @meeting_requests = Meeting.where('meeting_time >= ? AND requestee_id IS ? AND...
(1) odpowiedzi
2017-02-23 21:02 SQL combine WHERE and ORDER BY in one statement »
I have a problem with my database request(I use Sinatra for Ruby). There's a database where I store some articles with their attributes like the price...
(0) odpowiedzi
2017-02-21 15:02 Why does count() return 0 when accessing a character field larger than 511 using pyodbc? »
I was trying to count the number of occurrences of a substring within a character field of a database (PostgreSQL, pyodbc, Python 3.4.4, Windows 7). B...
(1) odpowiedzi