Questions tagged as 'consulta'

1
answer

JAVA: how to query a word within a RandomAccessFile?

good is my first question here: I have doubts on how to make a query within a randomaccessfile. I have this part of the code the only thing that it does is that if I write the name of my first product that is in the list if it prints it, but if...
asked by 19.05.2018 / 03:53
1
answer

Do a keyword search with mySql? I need to make the query query

I need to make a search engine that searches for keywords in my database. I have a word field where I keep all the keywords I want for the product. For example I have a product with keywords 'red shirt', I need the user to put those words in...
asked by 10.05.2018 / 22:15
1
answer

Division in postgreSQL shows incorrect result

I have the query that returns the value of an index that is the result of an operation between two columns, the result I want in decimals and shows it that way, what happens is that the result is not correct: here I leave my query: SELECT dep....
asked by 09.05.2018 / 17:01
0
answers

Error in schedule creation

My problem is that I need to create a schedule with data from a database But what happens is that at times like 10: 00-15: 00 classes are not added in the rows of 10: 00-15 only in the first and last hour I leave an image of how it should look...
asked by 25.04.2018 / 07:32
0
answers

No query is made in SOAP php, does not respond WS

Good morning, I have tried to connect to a WS that works with soap, but I do not know if I am writing the code wrong or it is badly formulated that does not consume me at all. This is how the server indicates that the xml should be: POST...
asked by 24.04.2018 / 16:08
0
answers

Access, calculated field. (Tell)

My database has two tables, one attribute of one of them is "Total number of video games", while the other stores the name of the video games. I was wondering, how, through a calculated field (Without needing a query) I could count the number...
asked by 02.05.2018 / 19:21
1
answer

In a query add data only to the first data obtained - SQL

I have a table with X number of records, but I'm interested that only the first record can be given an extra data, this can be by identifier field , that is, the smallest identifier, this only in order to identify which was the first record to...
asked by 21.05.2018 / 18:05
1
answer

MySQL query in several tables

good morning. I am registering the sale of a product with its unique ID and price, I am wanting to make a report that tells me what category that product belongs to that is in another table. How can I perform the query in several tables?...
asked by 22.10.2018 / 15:13
1
answer

What are the conditions in mysql

I have a question, I do not remember the conditions in Mysql, I'm doing consultations with Inner join and reserved words. SELECT (Nombre_empresa) FROM (empresa) INNER JOIN (lucha) ON (id_empresa=id_lucha) WHERE condiciones_para_cualquier_camp...
asked by 10.07.2018 / 02:08
1
answer

How to call the id of my SQL database and show it in a query with PHP?

I have a form, where users enter personal data. I did an if, so that the CURP was not repeated, if the curp is repeated it sends an alert telling them that it is repeated and it returns them to the form, in that I do not have problem it seems to...
asked by 31.08.2018 / 09:32