Questions tagged as 'sqlite3'

Tagged questions
3
answers

because the variable "valuation" tells me that it is undefined (php)

This is the error that appears to me:    Notice: Undefined index: valuation in C: \ xampp \ htdocs \ FAVORITES \ deletefavorito.php on line 14 My code: <?php session_start(); $conexion = new sqlite3('favoritos.db'); $usuario = $_S...
asked by 31.07.2017 / 16:28
1
answer

How to make a foreign key in SQlite.net from c #

Hello friends I am working on a project of c # I am new to this and I can not find the way to declare a foreigner from a class with c # code I clarify that I am using the MVC model but I give you one of my classes class producto { [SQLite...
asked by 05.04.2016 / 01:16
0
answers

Full text search with SQLite using prefixes and suffixes at the same time efficiently

I would like to know how I perform the following SQL query: SELECT * FROM libros WHERE titulo LIKE '%caball%' OR titulo LIKE '%pur%' OR titulo LIKE '%sangr%' OR ...; but using "Full Text Search" with SQLite and efficiently. I do not like...
asked by 15.12.2018 / 23:58
1
answer

Help with creating SQLITE3 tables

I have an error with the following query of my table in sqlite3: Create table EmpleadosCursos( Empleado constraint fk1_empleadoscursos references empleados, Curso constraint fk2_empleadoscursos references cursos, constraint pk_empleadoscursos...
asked by 10.12.2018 / 18:59
1
answer

I do a query in a sqlite database with Flask Python and it returns none when there are rows to read

I leave the code @app.route("/") def getInicio(): conn=sqlite3.connect('datala.db') c = conn.cursor() row=c.execute('''SELECT * FROM servicio''') resultado =c.fetchone() print(resultado) conn.close() return "...
asked by 30.11.2018 / 12:59
0
answers

how to make requests from ajax to python and sqlite

Hi friends, I have a question which I do not know what to use, I'm new to web programming and I know enough to create a web page, what happens is that I want to make an App and using a compiler of code like cordova which allows me to create an A...
asked by 12.11.2018 / 18:55
0
answers

Why does Sqlite3 let you store a String on a float?

Gentlemen, I'm working on Sqlite3 for android, and I've seen that it allows storing a STRING in a FLOAT value, how do I control that? I leave you the create: CREATE TABLE 'mercado' ( 'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'i...
asked by 02.11.2018 / 17:50
1
answer

Pass a class attribute by reference to a local variable

How about people! I have a PrintServer with the software PaperCut PrintLogger which generates some CSV (and HTML) files with the printing log. I'm doing a script that reads the CSV in the data entered into a database, for further analysis....
asked by 27.10.2018 / 22:47
0
answers

Sqlite3 with tkinter

I have a problem wanting to get a data from the db and show it in an entry in the tkinter window, it does not show it. from tkinter import * from tkinter import ttk from tkinter import messagebox import tkinter as tk import sqlite3 import stri...
asked by 27.10.2018 / 02:22
0
answers

Python, tkinter and Sqlite3 Error selecting an item in the listbox

I'm doing a small app in python (3.6) and I'm using sqlite3 as a database. The app in question is a modification that you take out of a tutorial to make a book registry with tkinter. I have almost 0 programming experience, I am in full training...
asked by 05.11.2018 / 00:30