Questions tagged as 'sqlite3'

Tagged questions
1
answer

import gallery image - android

Hey guys, I need help with my application, I have to select an image from the gallery, make it appear in an imageView and save it in the database (SQLite) so that the person can exit the application and keep the picture for when it comes back, i...
asked by 13.10.2016 / 02:14
1
answer

sqlite3.OperationalError error

I'm having a problem with sqlite3 in python, can anyone help me? The error is this: :~$ python3 05_create_data_param.py Nome: Henry Elias Carlos Eduardo dos Santos Usuário: Henry94 Senha: mGq0HJAM2C Data de nascimento: 08/01/1994 CPF: 772.0...
asked by 10.06.2016 / 12:51
1
answer

How to convert a "SQLite3 object cursor" to a list (Python)

In a cell of a table in my database I have a list of pairs. I have a Python module that I want to go fetch this list from the database and read it as a list. I tried to run this: interpretation = db.execute("SELECT interpretation FROM music WH...
asked by 26.05.2015 / 23:19
1
answer

How to generate sequential numbers automatically with current year in rails?

I need when a new product is created it generates a number ex: 0001/2015 number / year_vigente and when change of year returns to zero. I made a helper just to format the number in the views, but it does not solve the problem of automatic gen...
asked by 15.05.2015 / 21:26
1
answer

Saving image data from json / web-service to sqlite on iphone

Hi! I wonder if you can help me, I'm trying to save an image in an sqlite bank, on the iphone. But I can not.  Briefly explaining how it works ... The app connects to the server and receives the data using Json. Once received, the data is...
asked by 21.07.2014 / 02:10
2
answers

No such table error. SqLite

You're giving this error, I'd like to know if my DAO is right. Error: 08-06 14:19:53.304: E/SQLiteLog(16893): (1) no such table: proposta 08-06 14:19:53.334: E/SQLiteDatabase(16893): Error inserting validadebrinde=x validade=cd idusuario=1...
asked by 06.08.2014 / 19:25
1
answer

SQLSTATE [HY000]: General error: 1 no such table: contract Failed to prepare SQL: SELECT * FROM 'contract'

I'm using yii2 for a small project, I'm using sqlite to persist the data. So that's where the problem is. Any table I create in sqlite yii2 does not recognize, nor by using the GII to create the models. Interesting is that it plugs into the bank...
asked by 07.12.2018 / 19:14
0
answers

Date field with default value in the database

When I create a DataTimeField type field in Django, it has already been defined so that it contains the current date in this way: dt = models.DateTimeField(auto_now_add=True) or dt = models.DataTimeField(auto_now=True) But that way the...
asked by 04.12.2018 / 18:10
0
answers

Searching Data in Sqlite database with php

I'm trying to get the name of my session, and search the database for the data of who has this name, but echo does not return anything at all. $nome = $_SESSION["Aluno"]; $results = $db->query('Select * from alunos where nome = $nome ');...
asked by 13.11.2018 / 21:56
1
answer

Is it possible to use Sqlite3 on Android using the QPython3 application?

I'm trying to create a table: import sqlite3 def criar_tab_contato(conexao): cursor = conexao.cursor() sql = """ CREATE TABLE IF NOT EXISTS contato( nome text, telefone text, senha text ); """ cursor.execute(sql)...
asked by 25.10.2018 / 18:24