Posts by Vieira • 185 points
6 posts
-
5
votes2
answers309
viewsQ: Mysql does not use Input in query (Inner Join)
I have a query that is taking time to be executed, analyzing the explain I see that Mysql is not using the Word in one of the tables. Tables: CREATE TABLE `rel_financeiro` ( `protocolo` char(13) NOT…
-
1
votes1
answer3002
viewsA: Using 'Hide' and 'show' in a div
The problem is that you are setting all the elements .homeMenuFilhos with display = none and then checking if it’s display == none, i.e., the if will always be true. Remove align:…
-
1
votes1
answer288
viewsA: View saved BMP image in Oracle in PHP
There are some ways to do this without saving the image to the server, one of them is like the Faculties explains in Update LONGBLOB field is possible? Another way is to convert the image to base 64…
-
2
votes1
answer104
viewsA: Make . append() before . load()
The problem is that the .load() will always replace the element content. What you can do is use the method .get() and within it the .append(), see: $.get('/ContratoCli/carregaProduto', {serie:…
-
0
votes5
answers27365
viewsA: Remove jquery field mask
Put a "clean" mask on the field, take the value and then put the real mask back on: if ($("#txtCnpjPesquisa").val() != "") $("#txtCnpjPesquisa").mask("99999999999999"); resultado = ({ "cnpj":…
-
5
votes1
answer480
viewsA: Do not enter equal data in the database
Correct: $ci->db->select('nome')->from('tipo_produto')->where('nome', $subgrupo->attributes()->SubGrupo) Changing to:…