Category "database"

Java - SQLITE_BUSY; database file is locked

My application reads a html table and then a script (TableToCSV) converts it into a .csv format. After that I convert that .csv into a sqlite database. After th

Prevent database access outside the application

We have a MVC application running with SQL Server database. We are using windows authentication, and when we want to give user access to our site we add them i

Opening/Closing a Database connection in an apsx page for an IVR system

I am currently developing an IVR system, my question is more on a development side of basic architecture and opening/closing a database connection. As you can

How can I mock nest typeorm database module in end to end (e2e) tests?

all. Include details about your goal: I'm trying to mock repository in e2e test Describe expected and actual results: Request to server will not have access

Convert Access Database to SQL Microsoft DTS - Data Type '130' not in mapping file

I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the dat

Listing users for certain DB with PyMongo

What I'm trying to acheive I'm trying to fetch users for a certain database. What I did so far I was able to find function to list the databases or create us

Access Anki history from SQLite3 file

I want to perform some data analysis of my own on my Anki history. I found out that my history should be contained in ~/.local/share/Anki2/User 1/collection.ank

Procedure or function expects parameter which was not supplied, when parameter is auto-generated

I'm trying to insert data in my db. this is the code im using SqlCommand cmd = new SqlCommand("dbo.UsersInsert", cnn); cmd.CommandType = CommandType.StoredPro

phpMyAdmin Accepts NULL in the NOT NULL field

I've created a table with some NOT NULL columns using phpMyAdmin. CREATE TABLE `TEST` (`ID` INT PRIMARY KEY AUTO_INCREMENT, `Firstname` V

Database schema for messaging to multiple users

I'm looking for the best solution to implement messaging to multiple users within the system(Facebook-style). I'm came up with the following idea: where each

How to Dynamically Name Table in Oracle SQL Select Statement?

i would like to return all rows and fields from a table, where neither the tablename nor the fieldnames are known in advance. Something like: select * from [TA

How to convert XML columns to rows in SQL database?

I am trying to import an XML invoice to SQL database. After some research, I have managed to put it in SQL database but it has x rows whereas it should be a sin

Warning: sqlite_query() expects parameter 1 to be resource, string given

I've looked all over the place and cant find a solution that helps my case. I hope someone can help? I have this and receive Warning: sqlite_query() expects pa

recursive tree as a list (array items) in a new attribute value child

How to get hierarchy data(recursive tree) as a new column like below? (if there is last child then column child array is empty) rows: [{ 'id' : 1, 'paren

django.core.exceptions.ValidationError: ['“” value must be a decimal number.']

I got this error while migrating here is my models.py file: from django.db import models from django.conf import settings from decimal import Decimal # Create y

MySQL Query error using UNION/UNION ALL and Group By

Generate the following two result sets: 1). Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each

How to connect SQL Server with Rstudio?

I have downloaded Microsoft SQL Server on my Mac with the Docker image as described here, and also I have downloaded the database AdventureWorks2019 as an exam

Get specific row col values from mysql using vb 2012

I have one button retrieve I just want to get the database table "account" value by its row and col and display it in a textbox. I keep on getting errors on th

SQLite extension in VSCode not showing tables

I am trying to use SQLite in VSCode. I have installed SQLite extension by Alexcvzz. after opening the database when I right-click on the table and select "Show

What's the difference between " = null" and " IS NULL"?

What is the difference between "=null" and "IS NULL"? How are they used differently?