Questions tagged as 'sql'

Tagged questions
1
answer

I do not update with Update

I am trying to modify a password based on a textbox. Pass the code but do not update the database. string conexion = "Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\Resources\Atreus_bbdd.mdf;Integrated Secu...
asked by 14.08.2018 / 06:48
1
answer

Warning: mysqli_fetch_array () expects at most 2 parameters, 3 given

Does anyone know how I can do so that the mysqli_fetch_array can read me 3 parameters ? $registros = 1; //registros por página $sql = "SELECT * FROM base1"; $result = mysqli_query($conec, $sql); $reg_total = @mysqli_num_rows($result); //tota...
asked by 04.08.2018 / 23:13
1
answer

Obtain data with the lowest sequence number

I'm IN ORACLE SQL I do not know how to make the next query, to see if you can help me. I have the following table, in which there are 2 different products, inserted in different dates and times, and with different quantities: Producto1 1/12/17...
asked by 02.08.2018 / 22:39
2
answers

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' when loading sql

Version: Server version: 10.1.32-MariaDB I have trouble setting a password in mysql o mariadb use xampp 5.6 I install xampp I enter the console and with mysql -u root log me in. Following different examples that I...
asked by 04.08.2018 / 14:09
1
answer

Help with data management in Oracle, how to use the TO_CHAR for a NUMBER data type?

I have a query which obtains data of type NUMBER in the BD, what I do is show the result of the query in a .csv file and at the time of showing that data the fields of type NUMBER which are (IMPORTE_UNO, IMPORTE_DOS) it does not show deci...
asked by 26.07.2018 / 04:29
1
answer

ERROR CONNECTING TO BD PHP 7

I'm trying to generate a JSON file, but I'm getting ERROR 2, when I try to connect to the BD, my hosting uses PHP7, I do not know if that is influencing the error, before it worked correctly. ERROR:    Opps some thing went ERROR 2 PHP...
asked by 25.07.2018 / 05:14
1
answer

Problems with the IIS and the database

A few days ago I published my MVC + AngularJs application in IIS. Everything works fine except the database, the GET, ECT requests do not want to work ... Launches the following exception:    This Request has been blocked because sensitive...
asked by 15.08.2018 / 12:36
3
answers

How to calculate column total and show it in table

Hello, I need your help ... I need to take the total for each column and show it below the data table.  As well as this image .. <?php if(isset($_POST['search'])) { $valueToSearch = $_POST['valueToSearch']; $valueT...
asked by 05.09.2018 / 07:30
2
answers

Can you EMPTY a table (truncate) every X Minutes?

I have a little doubt, in which I have not found much information. Could something be done, for each "5 minutes" (for example) to empty all the contents of a table? The truth is that I have been investigating, and I have not found any usef...
asked by 04.09.2018 / 20:26
1
answer

Limit number of records and sort them

I have two tables one of clients and one of sales where I must select the 30 LATEST records added to the sales table, show the information of the clients that made those transactions and order them upwards with respect to the id of sales...
asked by 17.07.2018 / 23:32