Posts by Rafael L Ramon • 125 points
9 posts
-
1
votes2
answers3812
viewsA: Convert Currency Values to Decimal?
SQL does not work with a comma. It separates the decimal using a dot(.). First vc must remove the point from the string q takes and then replace the comma by a dot. $valorFormatado =…
-
0
votes1
answer33
viewsA: Query of Records in DATE Fields by Month
Your question is confused. If you filter only month 8 for the one-way and month 8 for the back you put in condition: WHERE MONTH(ida) = $mes(valor inteiro) AND MONTH(chegada) $mes(valor inteiro)…
-
1
votes0
answers456
viewsQ: Select2 does not select
Using the Select2 plugin via json I can’t select any results. When you select it does not display the result. I am doing something wrong? $(".PessoaTipo").select2({ language: "pt-BR", placeholder:…
-
1
votes1
answer1439
viewsQ: PDO DBLIB AND UTF-8 ENCODING
I am in a project using UBUNTU-SERVER 64bits as WEBSERVER. In the project I chose the Microsoft Sql Server 2012 database which I have a short-term license to use. With a lot of effort I got the…
-
1
votes1
answer685
viewsQ: How to apply the two add-on to an Hex string in c#?
I need help converting an Hex string into an Hex string by applying two add-on. Example: 0x00FEB5AB 0x00014A55 My Hex. 00FF17DB ? (represents a negative latitude) and 00FCFF75 ? (represents a…
c#asked Rafael L Ramon 125 -
0
votes0
answers807
viewsQ: How to capture data from a gps connected in php
I am trying to develop a tracker system. I have managed to connect the gps with my php server. Only that I am a layman in the subject and I do not know how to capture the msgs that the gps sends me.…
-
0
votes2
answers1435
viewsA: How do I receive messages from a GPS that uses GPRS via PHP?
I managed to make the gps connect with this code how I treat and which variable captures the msgs? require_once('/webserver/production/htdocs/assets/SocketServer.class.php'); // Include $server =…
-
4
votes1
answer488
viewsQ: Different numbers become equal after conversion with doubleval
I have 2 values 4850.00 and 4850.01 When I set 2 variables manually with these values and compare using if, returns me different (OK). But in an ERP system I develop I receive 2 values via AJAX.…
-
4
votes3
answers12716
viewsQ: SQL Grouping by name, date and quantity by month
I am not able to group this result per month ("PP.PAPELETA_DATA" field). Type the quantity (Count(PD.Personal) as Total) separated by month! Could someone give me a hand? Usage SQL SERVER 2012.…