Posts by Agnaldo Junior • 193 points
15 posts
-
0
votes2
answers670
viewsA: Error Uncaught Error: Class 'Client Register' not found Using namespace
Check your Register.php class, the error I think is in it: class Cadastro { private $nome; private $email; private $senha; public function getNome():string{ return $this->nome; } public function…
-
1
votes1
answer610
viewsQ: Open modal pop-up automatically when opening the site only once
I have a Modal window that should open only once when opening the site. Below, I have the button I use to open the Modal screen, in addition to the responsible div, I need this button to run the…
-
0
votes1
answer981
viewsQ: Grouping data by hour intervals in SQL Server
I currently have the following query in the SQL Server database: SELECT TOP 5 CAST(CAST(CAST(CAST(E3TimeStamp as float)*24 as bigint) as float)/24 as datetime) as hora,…
-
-2
votes1
answer2747
viewsQ: Freeing external access to a particular port through Iptables
I currently have two network card on my Ubuntu 16.04 server, configured as follows in the file interfaces: auto lo eno1 enp2s0 iface lo inet loopback #Rede Externa que vai para antena de Internet…
-
0
votes2
answers815
viewsA: Select averaged in minutes - Mysql
I managed to solve using GROUP BY, follows (opcaoDesejava): Intervalos por minuto = ... GROUP BY DATE_FORMAT(`i_l1`.`TimeString`, '%Y%m%d%H%i') Intervalos por hora = ... GROUP BY…
-
0
votes2
answers815
viewsQ: Select averaged in minutes - Mysql
Below is a query returned in a table of my database (Mysql): What interests me are the Timestring, Varvalue and id columns. Every 5 seconds on average an Insert is made on my system. I have 1 month…
-
0
votes1
answer737
viewsQ: Displaying 'load' warning when iframe update - html
I’m having trouble with an app, where the screens take a while to redirect. To get around the problem, I created a page with just an iframe, which contains the navigation between pages. The bigger…
-
0
votes1
answer155
viewsA: Converting Word to bits - Javascript and Siemens CLP Webserver
I was able to solve the problem by creating a recursive function, starting at the highest value and decreasing. The variables cBit-- are temporary variables, which I am decreasing. Bit-- variables…
-
1
votes1
answer155
viewsQ: Converting Word to bits - Javascript and Siemens CLP Webserver
I am receiving a PLC variable, which is a Word(16). However, I am not able to 'convert' this Word in 16 bits with their respective values (true or false). 1 Word = 16 bits. I get word with 'full…
-
3
votes1
answer61
viewsQ: Float to Byte Array conversion
How can I be performing the conversion of float or integer (if possible) for a array byte in Java. Say: float x=180 Theoretically you would need to create 1 array 2 position bytes. Is there any way…
-
2
votes1
answer1778
viewsQ: Key Foreign Relationship Problem in Phpmyadmin - Wamp
I have 'problem' in my Wamp, more precisely in the latest version (Wampserver 3.0.6 64 bit x64). When I create 2 tables, example: CREATE TABLE categoria( id_categoria INT NOT NULL AUTO_INCREMENT,…
-
2
votes3
answers14296
viewsA: Export SQL Server query to CSV file
I was able to export from SQL Server to CSV via the code below: exec master..xp_cmdshell 'bcp "Select E3TimeStamp, Message, USUARIO, Acked, Severity, FormattedValue, Area, EventType From…
-
1
votes3
answers14296
viewsQ: Export SQL Server query to CSV file
I need to somehow export the result of my SQL query to a CSV file. However, it has to be directly via SQL or VBS. Or else, all database table data can be exported to CSV.
-
0
votes1
answer9363
viewsQ: Run function that returns multiple values and based on these make the main SELECT - SQL Server
I have the following function in SQL Server that returns the name of each column of my table: CREATE FUNCTION dbo.FiltraNomeColunas(@FiltroColuna VARCHAR(200)) RETURNS VARCHAR AS BEGIN DECLARE…
-
7
votes2
answers837
viewsQ: How to implement a class to use Preparedstatement through it?
I have the following class Connect.java package util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import…