Questions tagged as 'query'

Tagged questions
3
answers

Difficulty installing SQL query

Personal oops. I'm having difficulty setting up a query in MySQL. It is as follows, I have a table with the following structure The time_array and time_azul columns store user IDs of the system. I need to look in the columns time_...
asked by 07.07.2018 / 01:08
0
answers

National Simple The ControlToValidate property of '' RegularExpressionValidator1 '' can not be blank

I am developing a query in Simple National, but when giving an HTTPPost in the site link returns me the error The ControlToValidate property of ''RegularExpressionValidator1'' cannot be blank. Follow the query code: Post.WriteString('_...
asked by 03.07.2018 / 19:20
0
answers

Error with BigQuery using GoogleApp

My worksheet was working normally, but this error started to appear. My account is business, so I have not activated the charge. I've done some spreadsheets and none of them needed this. Can anyone help me?     
asked by 05.07.2018 / 16:39
0
answers

Value accumulated day by day - Firebird

I'm starting now in the programming area, I'm having a hard time with SELECT which brings the accumulated value day by day of sales, I need this SELECT to play it on the line of a graph indicating the cumulative sales value of the...
asked by 05.07.2018 / 17:54
1
answer

Multiple bags Exception / Searching multiple collections with JPA

I'm having a problem with JPA when it comes to making a query. I want to query Entity A that has a% of Entity% B and% of Entity% C (I want to query Entity A by bringing Entities B and C into the same List ). > When I try to execute th...
asked by 11.07.2018 / 04:54
0
answers

Show result grid in mysql Workbench

When executing queries in my MYSQL WorkBench, I can not see the Result Grid, just the output screen telling me if there was an error executing the command or not. How can I activate the Result Grid tab to view the table? Follow the print f...
asked by 28.06.2018 / 06:02
0
answers

"Transpose" table in classic ASP

People, I have a table in SQL with the following columns "pv, product, values". Currently I have a registration form, where the person inserts these values and he goes to this table with id auto increment. But I need to generate a control...
asked by 28.06.2018 / 22:40
0
answers

PHP query with response from another query

I run a query that returns a list of IDs. With each ID of this list I want to make an insert into a second table. My code: <?php $db = mysqli_connect("localhost","root","","test") or die("Erro ao conectar na base de dados MySQL!"); $que...
asked by 17.06.2018 / 06:36
0
answers

mysql inner join with wildcard

I need to update on a table A by taking information from table B using inner join with wildcard to compare a snippet of content and if found in B, load a column in A. To just test this join I made the select below: SELECT vinhos.* FROM vinhos...
asked by 24.06.2018 / 21:00
0
answers

Search in the combo box data that contains specific record in the bank

I am developing a project in C # MVC, it has a combo box that takes the data from a sql server database I did adding in the combo box itself and list all, I would like in that same combo box to be able to type for example "Maria" and return all...
asked by 11.06.2018 / 18:11