Posts by Antonio Raichaski • 305 points
7 posts
-
2
votes2
answers1095
viewsQ: HTTP Error 406 using Rest Delphi components with XML return
I am trying to consult an NFS-e with the REST components in the XE7, in the queries of type Json I could normally, but when the return is of type XML it gives error 406, I tried to send the Accept…
-
4
votes3
answers11523
viewsA: Putting two Yes and No buttons on a Javascript message
You have the option to put confirm button <script> function mensagem() { var name=confirm("Pressione um botão.") if (name==true) { document.write("Você pressionou o botão OK!") } else {…
-
1
votes2
answers186
viewsA: How do I display total records in a Manytomany relationship when I use HAVING?
I imagine this is what you want, you must select the COUNT from the article_id field to return the amount of records. select COUNT(article_id) from article_tag where tag_id in (1, 3) group by…
-
3
votes1
answer766
viewsA: Run function only the first time you open the page
Use the initialize function, See an example on this site: http://pt.androids.help/q4068 Code: initialize: function() { this.bindEvents(); }, can put the warning inside the function this way will…
-
3
votes1
answer4727
viewsA: Select the 3 highest values
Check if this solves your problem select * from TABELA order by lg_cliente DESC LIMIT 3
-
2
votes3
answers328
viewsA: How to compare encrypted data with crypt
To make the comparison with the encrypted password you need to have two already encrypted password or encrypt them at runtime, so notice you are comparing an encrypted password with a password…
-
2
votes4
answers1917
viewsA: Home Time in SQL (Years, months and days)
Make sure it’s logical: DECLARE @DTINI DATE, @DTFIM DATE SET @DTINI = '2015-10-17' SET @DTFIM = '2016-12-17' SELECT CAST(DATEDIFF(DAY, @DTINI, @DTFIM) / 365.25 AS INT) AS ANOS, DATEDIFF(d, @DTINI,…