Posts by Igor • 109 points
12 posts
-
3
votes2
answers12845
viewsA: How to get the names of all Postgresql database tables?
To get the name of all tables, use the command below: SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_type='BASE TABLE'; To get the attributes of a table, use…
-
1
votes1
answer54
viewsQ: Twitter User-App Authentication
I am developing some Python scripts with the intention to bring specific tweets and perform further analysis, but I have doubts about the type of Twitter authentication. As I noticed, there are two…
-
1
votes2
answers123
viewsA: Generate dynamic table in Excel from MSSQL with 8 million records
Apparently Excel stores the data loaded in memory without any compression. What BI tools do to be able to work with so much data. I believe it is not possible to perform this operation with Excel,…
-
0
votes2
answers107
viewsA: SQL query returning null value
You have already checked the result you are getting in the line quoted below? $resultado = $query->fetchAll(PDO::FETCH_ASSOC); Use a var_dump on the cited variable to check the values and see if…
-
-1
votes2
answers720
viewsA: Can memory leak occur in Java?
It can occur even with the existence of Garbage Collector (GC). Usually, memory leaks in Java will occur due to programming errors. For example, a simple example that generates memory leakage:…
-
1
votes2
answers4385
viewsA: How to set a Textview with a DOUBLE variable?
I use a similar conversion in an app that has developed. Suitable for your example, would be as follows: txtMedia.setText(Double.toString(media1));
-
0
votes3
answers4343
viewsA: How to download file without back-end
You can use the following HTML5 TAG: <a href="your_link" download> file_name </a> However, it does not work in all browsers. It follows the same documentation from W3schools to be able…
-
0
votes3
answers1438
viewsA: How to get value from selected checkbox
Change the name of your inputs to: name="bairro" And try this: $(function () { $('.span3').click(function () { var checkValues = $('input[name=bairro]:checked').map(function() { return…
-
0
votes3
answers3285
viewsA: Search word in Php text
You should put in the $search variable the value of the ID you want to search for. For example: $search = '490901'; Replaces the if inside the foreach by: if($line == $search){ echo $line; // ou…
-
0
votes1
answer113
viewsA: Media queries or multiple sheets of styles?
It is recommended to use only one style sheet file (.css). Below is a list of pros and cons. Remembering that are only recommendations and observations... any of the methods is effective. Pros of a.…
-
2
votes2
answers43
viewsA: Error when trying to calculate in fields of the same table in update mysql
Have you checked if the values that are coming in $Row are correct? Try a var_dump at the beginning of your while to check. while($row = mysql_fetch_array($listaconv)){ var_dump($row); die; ... If…
-
0
votes3
answers226
viewsA: Sum inputs checkbox and at the end subtract one
When you give a Get at the value the user entered on the screen, do a check... if the entered value is > 1 you charge for the informed quantity -1. Ex: if($_POST['qtdeMolhos'] > 1){ $valor =…