Questions tagged as 'query'

Tagged questions
1
answer

Search with Ruby on Rails to generate a report

Well I have a project with scaffolds of books and loans and I need to do a search for a specific book and as a result show all the loans in that book had I have no idea how to start doing this.
asked by 17.05.2018 / 20:58
0
answers

Display Ajax query on another page

Good morning. I am doing a web application of shared races, type "Uber". I want you to submit a query to the database with the list of registered drivers searching for cpf, but that I want you to show on this green carousel. InthiscodewithAj...
asked by 16.05.2018 / 14:14
0
answers

Make results appear by relevance level

I have a JS query that returns me the songs of an artist when searching for the name of the artist, can someone tell me how I can make the songs appear by level of relevance? That is, from the most famous to the least famous? I'm using the youtu...
asked by 13.05.2018 / 15:19
0
answers

Display query on the same form page

I'm doing a web application for a "Shared Racing" service (Uber type), where I want a CPF query to appear on the green card. I want when I check the CPF, present on the green card, without leaving the page. Formscript:<formid="cons_motoca...
asked by 11.05.2018 / 20:40
1
answer

Query zeroing column when applying order by - Mysql

I have a query that when sorting it in ASC it zeroes a column of my table, however if I command in DESC it displays values normally. This is a query: SELECT 'tab_medicamentos'.'id', 'tab_medicamentos'.'classe_terapeutica', 'tab_medicamento...
asked by 11.05.2018 / 21:08
0
answers

How to Assign Vacancies from one table to Patients from another table

Galera for a project of dental consultations I need to relate two tables of patients and vacancies in order to assign the first patient who came in contact requesting a specific specialty (orthodontics, whitening, etc.) the first available wave...
asked by 21.05.2018 / 21:33
0
answers

Join 2 query on mysql [duplicate]

I have a problem in attaching 2 query in mysql. Well I have a query that, roughly speaking, brings me information from a transporter, from the cte and how much was the freight. Another query shows me the price lists of the conveyors. I want...
asked by 07.05.2018 / 16:47
1
answer

SQL - Searching for XML data

I have a table where one of the fields is an XML ThestructureofXMListheBrazilianstandardschemaofCTE(KnowledgeofElectronicTransport)<cteProcxmlns="http://www.portalfiscal.inf.br/cte" versao="2.00"> <CTe xmlns="http://www.portalfiscal....
asked by 08.05.2018 / 17:29
2
answers

ChartJS + mysql + php (subscriptions in the month)

Well, I have a table of user registrations. I'm creating a chartjs to display the number of registered users per month on a bar chart. The mysql query would only have to return me 2 columns (MONTH and TOTAL NUMBER OF SIGNATURES OF THAT MON...
asked by 16.05.2018 / 20:56
2
answers

Mysql Query does not work with many arguments

I would like to ask you for help identifying the reason why my update query does not work. I have the following problem, the query below works normally: $conn->query("UPDATE dados_cadastrais SET nome='$nome',sobrenome='$sobrenome',nascimen...
asked by 29.04.2018 / 00:43