Questions tagged as 'select'

Tagged questions
1
answer

Catch all data selected with javascript in multiple select field

I'll describe what I'm trying to do: There are sectors, and in each sector there are several employees, and I need to, when selecting a sector in a select field, the next field select (which will list employees) be filled with e...
asked by 23.05.2016 / 22:25
1
answer

How do I select multiple values from the same table

How do I select values 1, 2, 3, 4, and 5 from the same table without doing that SELECT bundle? <?php $rateone = 1; $ratetwo = 2; $ratethree = 3; $ratefour = 4; $ratefive = 5; $query = "SELECT COUNT(rate) as rate FROM tb_comment...
asked by 15.12.2015 / 04:59
1
answer

How to do select using mask on output

I have a client table, and a cpfClient field of type varchar. The cpf is stored without a mask. Ex: "00751595170" I would like to make a select that formats the result by putting the masks. "007.515.951.70"     
asked by 26.10.2015 / 23:40
2
answers

How to group results from a row-to-column query

Good afternoon, I have this query SELECT tblcliente.idCliente, tblclienterespostapre.resposta FROM tblcliente INNER JOIN tblclienterespostapre ON tblclienteresp...
asked by 28.10.2015 / 16:18
1
answer

MySQL: Pivot (rows for columns) of columns with the result of a query dynamically

I have two sets of tables below: 1: 2: IputaquerythatreturnstheresultsofthetwotablesusingUnion:Selecttbprojeto.projNomeAsProjeto,tbindp.indPNomeAs'Tipo(Ind/Idx)',tbindc.indcValorAsValor,tbproj_cenario.projCenNomeAsCenário,tbidxind_grp.i...
asked by 15.10.2015 / 03:36
2
answers

Placeholder does not appear after applying "padding" in the input

Hello, I am having a very silly and simple problem that is causing me to miss a P # @ & time! Come on .. I'm using the Bootstrap v3.3.6 CLASS="form-control" If someone wants to do an inspection on the website, it is incomplete even in gi...
asked by 25.11.2015 / 04:17
1
answer

disable select in cakephp

I have 2 selects, and I want to make that when one of the select is with an option other than empty, the other select goes into disable. Follow my code: <script type="text/javascript"> function handleSelect() { if (this.value == '30...
asked by 29.09.2015 / 15:37
1
answer

SQL: Can I have clauses in GroupBy that do not appear in Select?

I know that I can not have clauses in the select that do not appear in Group By. But is it possible otherwise? For example: Select B From Table Group By A,B     
asked by 10.05.2015 / 03:36
1
answer

SQL Query returning duplicate records

I have a BIG problem in a SELECT: I have two Tables' adwords_performance 'and' analytics_transaction 'and I need to do a SELECT by adding columns' adwords_performance.clicks ', '< strong> adwords_performance.impressions 'and' analytics...
asked by 19.03.2015 / 21:16
2
answers

Query Query 1: N

I have the following tables: Tabela: estoque id_estoque nome Tabela: atributos id_atributo id_estoque nome And for example I need to know if there are 2 attributes of name X and name Y linked to Z stock. And I wonder...
asked by 03.06.2015 / 15:41