Questions tagged as 'query'

Tagged questions
2
answers

Problems when extracting several jsons with queries in a nodejs module

I have a module in a route that needs to return a json with the content of several queries made in the same module and some of these queries are made with data extracted from the first queries, my code is similar to the following, but the proble...
asked by 17.05.2017 / 23:57
1
answer

Change the format of the String that returns the LocalDate type

I have a project in which I connect to MySQL and work with data type Date (in MySQL ) and LocalDate (in Java ) My problem is as follows, the method TryParseDate() parsea from String to LocalDate and retu...
asked by 10.05.2017 / 13:25
2
answers

query on my mysql

hi friends could help me complete a query I have these records, from which I have to obtain day 1 the start date and the end date the day two start date and end date and so with the others, is what I get this way: (SELECT date_game_large...
asked by 10.05.2017 / 00:23
1
answer

Laravel 5 Eloquent Model error

Hello Stackoverflow community, I have this error while I try to use query between models and relationships in Laravel 5.3: BadMethodCallException in Builder.php line 2450: Call to undefined method Illuminate \ Database \ Query \ Builder :: ad...
asked by 06.04.2017 / 22:11
1
answer

XQuery: Error "Effective boolean value not defined for array (*): [true ()]."

I intend to make a query about an XML document whose structure is as follows: <bib> <libro anyo="1994"> <titulo>TCP/IP Ilustrado </titulo> <autor> <apellido>Stevens</apel...
asked by 28.03.2017 / 19:38
1
answer

Duda SQLITE query

I have a table that stores me that stores three numbers and an ID. NUMERO1 NUMERO2 NUMERO3 ID 14070 4641 24155 1 14070 4780 24155 2 14070 4333 24155 3 15000 4303 24000...
asked by 21.03.2017 / 13:35
1
answer

Problem with ResultSet in Java

I am working with MySQL in Java and when I do querys I formulate them in a general way, I prepare them and execute them. When I get the ResultSet I give it to a method that processes it (Command Pattern), but when the response is obtai...
asked by 20.01.2017 / 19:51
3
answers

convert the result of a SQL query into an entire PHP variable

I want to store the result of an SQL query in a PHP variable but as an integer, this is my code: $maxnroviaje=mysql_query("SELECT MAX(NROVIAJE) from viajes"); $nroviajenew=mysql_fetch_assoc($maxnroviaje); and doing echo on those two variabl...
asked by 19.02.2018 / 03:45
1
answer

Delete row from a table with php

Hello good afternoon again in the forum and I have the following question. I have this code that loads everything in the database into a table, the problem is when deleting by ID ... Thanks in advance. <form name="frmInsertarFecha" ac...
asked by 23.10.2018 / 20:48
2
answers

Fill MYSQL table with another table from the same database where table A has 1 field more than table B

As the question says, both tables are in the same database and both have the same fields (such as telephone address name etc ...) with the difference that table A (original table containing the data) has 1 field more than table B (table where th...
asked by 20.08.2018 / 15:46