Questions tagged as 'sql'

Tagged questions
0
answers

Show logged-in user reservations only

I wanted to know how I can show only reservations made by the logged-in user, as I tried a lot of code and none of them worked. I tried declaring a session with the ID, which I even picked up but displayed information from another user. Remem...
asked by 08.11.2018 / 21:17
1
answer

SELECT lock when I make an UPDATE - SQLServer

I'll give an example of what I'm doing, but the very question is at the end. I have a table with 4,100,000 records and I am creating a theft that reads this data and exports it to MYSQL (it does not enter into the agenda, just to set it up)....
asked by 08.11.2018 / 13:41
0
answers

Generate protocol number with contact form 7

I need to develop a simple system of ombudsman, and for this I am using Wordpress and in the form the Plugin contact form 7 , I would like to implement a unique and non-sequential protocol number for each submission. This protocol number w...
asked by 31.10.2018 / 22:14
1
answer

Search item result on the same line separated by commas

I have a select that returns the risks (job security) in several lines, I would like the item "T4.RIS_RISCO" to appear in a single line separated by a comma, can anyone help me ??? I have basic knowledge ... SELECT T1.ASO_ID, T1.RIS_ID,...
asked by 30.10.2018 / 12:22
1
answer

Bring range data

I would like to bring even the ones where there was not value in the query For example; table data id | valor | data 1 | 5 | 01/10/2018 2 | 6 | 03/10/2018 3 | 7 | 04/10/2018 5 | 8...
asked by 29.10.2018 / 19:42
2
answers

sql return given php

$hoje = date('d'); $data_hoje = "SELECT * FROM vendas WHERE dataCompra = now()"; $result = mysqli_query($conexao, $data_hoje); while($linha = mysqli_fetch_assoc($result)){ if($linha['dataCompra'] == $data_hoje){ $hoje++; } }...
asked by 26.10.2018 / 20:44
1
answer

foreach within the foreach without repeating the data

I have a listing of Employees and each employee can have many Cost Centers. And as far as I get information from the bank employee I need to list the cost centers and list the cost centers where the employee is registered by marking the selec...
asked by 25.10.2018 / 19:51
1
answer

How to solve: Column "id" not found [42122-197]?

Folks, I'm creating an API that will display random phrases, from a table in the database. The problem is that whenever I access the route, in the console, I get this exception:    org.h2.jdbc.JdbcSQLException: Column "id" not found [42122...
asked by 01.11.2018 / 02:08
1
answer

How do I use the text_input python-kivy text?

I'm having trouble using text_input text to store in the database. Python code: from kivy.app import App from kivy.uix.screenmanager import ScreenManager, Screen from kivy.core.window import Window from kivy.utils import get_color_from_hex...
asked by 16.11.2018 / 18:16
0
answers

Web Server SOAP data interception

So, I aim to get a copy of a return NF through the web server, however I have no experience with it. How can I after an NF is generated, on its return, by its key, get a copy of the .XML file and play this file inside a folder, such as a copy?...
asked by 23.10.2018 / 08:12