Questions tagged as 'sql'

Tagged questions
1
answer

Error jQuery and Ajax, returns [object Object] of a SQL query

I have an error, and PHP does not return the query sql well. This is what I do: $(document).on('click', '.editarCliente', function () { var idc = $(this).attr("id"); console.log(idc); $.ajax({ type: 'POST', url: 'php/edit...
asked by 17.09.2018 / 21:35
1
answer

Error when placing a WHEN in SQL query - ORACLE

I have a query in oracle: WITH hist_snaps AS (SELECT instance_number, snap_id, round(begin_interval_time,'MI') datetime, ( begin_interval_time + 0 - LAG (begin_interval_time + 0) OVE...
asked by 12.09.2018 / 18:47
0
answers

function sum (text) does not exist

I have a very simple function that groups together some values of the Chile 2017 census. The columns of interest say a2007, a2008, a2009, etc that are the years and their population, all are of the numeric type but not the problem that does not...
asked by 12.09.2018 / 19:24
0
answers

MySQL, MariaDB with Jupyter Notebook

I have a sample database "Sakila" about MariaDB locally with which I practice with HeidiSQL, I would like to know if there is a way to get the same BD with Jupyter Notebook, to be able to practice and comment code from there same and that I stay...
asked by 04.10.2018 / 15:18
0
answers

Delete blank space at the end of the file (.txt)

I have a code where I make a query with php and sql server, the query brings me some records, then I create a text file (.TXT) and with a cycle while(true) I write the records and when there are no records that write I give the order b...
asked by 12.09.2018 / 21:03
2
answers

Send ID from jQuery to a page to make an INQUIRY

I try to explain, since it is something I had never done before: Attempt: when opening a modal, I take out an "id" (the one of the client) Now, I try to send that "id" to the same page that had made the action, I put the code here:...
asked by 13.09.2018 / 20:37
1
answer

Insert data from a DataGridView to SQL in c #, Visual Studio

I am making an application that records the daily information of what was done on a farm during the day. The grid shows something like that. Where I have to enter information from the data grid to the database. But the size of the rows va...
asked by 19.09.2018 / 21:41
0
answers

problem when trying to create this table in sql, I get an error in the Identity

CREATE TABLE Materia (codigoMateria INT IDENTITY(1,1) NOT NULL , nombre VARCHAR(40) NULL , estado BIT NOT NULL CONSTRAINT DF_Materia_estado DEFAULT (getdate()), CONSTRAINT PK_Order PRIMARY KEY (codigoMateria ), CONSTRAINT AK1_...
asked by 09.09.2018 / 03:12
0
answers

Error making an UPDATE from PHP with Ajax

I try to do an "edit" clients, but it does not work at all. Is it possible that it is because the form , I get it by PHP in a query? I will explain my code: First of all: The form , comes from a query, by clicking...
asked by 08.09.2018 / 18:22
0
answers

Problem to pass values by URL (GET) in PHP

I try to do the following: From a query, I create a table, to which at an option, I am adding a link to print a pdf, $indices .= '<tr> <td>' .$row[id_presupuesto]. '</td> <td>'...
asked by 05.09.2018 / 20:01