Questions tagged as 'select'

Tagged questions
1
answer

Group_concat in JPQL

I created the following query: SELECT o.codigoChamado, o.codigoOrcamento, group_concat(o.conteudoOrcamento), o.observacaoOrcamento FROM Orcamentos as o group by o.codigoChamado, o.codigoOrcamento, o.observacaoOrcamento order by o.codigoOrc...
asked by 10.10.2018 / 16:29
1
answer

Divide sql results in rows through delimiter

Good afternoon, guys. I have a difficulty to do a select in a postgres DB here. For some reason, the programmer invented creating a field where, if the user enters two notes at the same time, the system writes in the bank only one line for tha...
asked by 25.09.2018 / 18:58
1
answer

MySql - inner join runs in PHPADMIN but in SCRIPT php does not

I have a small PHP script to interact with MAKERIOD. When I execute the select in PHPADMIN I have the return: "Showing records from 0 - 16 (17 total, Query took 8.0945 seconds.)" SELECT Tbdiario.cn1, Tbdiario.cn2, Tbdiario.cn3, Tbdiario.cn4, A...
asked by 30.07.2018 / 19:08
2
answers

SELECT pulling data from the Database

I'm not able to do a select that pulls the data from the Database, I wish someone could help me ... <!DOCTYPE html> <html> <head> <title>TODO supply a title</title> <meta charset="UTF-8">...
asked by 20.06.2018 / 14:16
1
answer

Select without repeating data

I'm developing a site for a musical project and I'm having difficulty with select, it's the following, I have 2 tables a call album that contains cd information (artwork, disc title, songs name, etc), the other table calls album_links that has t...
asked by 31.05.2018 / 05:15
1
answer

Add values in a Select (postgres)

I'm having a little problem, I need to populate a gridview in C #, but my query is not doing the sum of some values and this is causing the company code to be repeated and with the value "separated" p> The value I need is the sum of the 3 valu...
asked by 07.06.2018 / 20:06
1
answer

After choosing an option in the selectbox, disable and change the text of two other selectboxes

Beauty galera. I have three selectboxes and after picking the "Movies" option in the first box, I would like to disable the other two selectboxes and modify their texts to "N / A": <select id="categoria" name="categoria"> <option valu...
asked by 24.01.2018 / 05:11
1
answer

Redirect through the option value and keep it selected

I need to redirect according to the value of the "option" and keep this "option" selected after the redirect. I can already redirect through this code: $(function() { // bind change event to select $('#categoria').on('change', function() {...
asked by 26.01.2018 / 00:40
1
answer

DOUBT ON SUBSELECT IN FIREBIRD

Hello, good evening! I have a table that wraps the input and output part of a box, an example of this is: On 01/01/2018 the user informed that he entered $ 200.00 in the company safe, on the same day he made another entry transaction in the amou...
asked by 01.01.2018 / 21:59
1
answer

Get an HTML data for a SELECT in another file without POST

Good morning, I'm starting my PHP programming life and I have a problem here. I have the following form: <form action="cadastro_pex.php" method="post"> <label>Período: <select name="periodo" id="periodo" style="text-transform:...
asked by 26.01.2018 / 15:06