Posts by Diego • 4,520 points
159 posts
-
0
votes1
answer26
views -
0
votes1
answer26
views -
0
votes1
answer27
viewsQ: Domdocument search XML nested tag
I am searching the XML data below to save in PHP variables for future processing. The XML excerpt below is what I am working on: Inside the "notas_fiscais", I was able to extract the data correctly…
-
0
votes0
answers142
viewsQ: Multiple return IN and CASE clause using Oracle SQL
I have a situation, using an Oracle-SQL database, where depending on the value informed of a variable (YES/NO), the value being used in the query will change. I tried as below but returns the error:…
-
0
votes1
answer69
viewsA: Sequence in Oracle SQL with strange behavior
If someone goes through this weird situation, the solution is simple, just take the CACHE 20 for NOCACHE. The CACHE 20 made it "hold" 20 numbers each session, then evaluated and really that was the…
-
0
votes1
answer69
viewsQ: Sequence in Oracle SQL with strange behavior
I created an Oracle database with the following script: CREATE SEQUENCE pcn_integra_ser_nfe INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 9999999 NOCYCLE NOORDER CACHE 20 It is used in only one…
-
1
votes1
answer362
viewsA: How to call a function in an HTML form?
In a very simple way, I united your two Htmls. I didn’t imagine it, I just changed the mistakes that were in it. I left the result as Alert for you to see how it works. There were some mistakes: *…
-
1
votes1
answer1161
viewsA: Percent calculation in Oracle SQL
Should anyone from Oracle fall here, the solution was as follows: On the line: ,ROUND(SUM(tab.qtde) / SUM(SUM(tab.qtde)) OVER (),4)*100 AS PERCENTUAL_CARGA Placed PARTITION BY: ,ROUND(SUM(tab.qtde)…
-
1
votes1
answer1161
viewsQ: Percent calculation in Oracle SQL
I’m mounting a query where I need the percentage of category for each cargo. If I filter for only one load, the query returns correctly. But if I put more than one (a period, for example) the…
-
1
votes2
answers1694
viewsA: VBA copying Brazilian standard date in American standard
If by chance someone goes through this problem (Texttocolumns changing the format of the date), follows below the solution. I changed the way to copy the CSV and it worked. I changed the function…
-
0
votes2
answers1694
viewsQ: VBA copying Brazilian standard date in American standard
I have the code below in a macro, to copy a TXT file separated by semicolon to an Excel file: Sub Atualizar_Dados() Application.ScreenUpdating = False Application.DisplayAlerts = False 'Abre o…
-
1
votes1
answer90
viewsQ: Inner Join with Where and multiple tables
I am mounting a query, where I need to Join between two tables (because the data will be in the main B but not in the complementary BC) and a third table that necessarily need data, which will…
-
3
votes2
answers983
viewsA: Limit R$ value in field input with HTML5 and CSS3 with Javascript
Doing a simple test here, with the input below: <input type = "number" min= '10' max = '1064'> Automatically, when typing 1065 I had the return below: Please enter a value Less than or Equal…
-
3
votes1
answer34
viewsA: Return the value to the left
You can use the operator like: SELECT * FROM EXEMPLO WHERE VALOR LIKE 'CARRO%' The operator % is the joker, you can use it in any position. For example, if you want to see if the word is at the end…
-
1
votes1
answer261
viewsA: Select with specific column - Oracle
Oracle SQL does not directly allow the use of * with another column, you need to use a alias for the table in this case, as below: select tbl.coluna, tbl.* from tabela tbl…
-
2
votes2
answers190
viewsA: check difference between values with php
The error, as already said of the lack of $, is that you are not fetch the query result: $con=mysqli_connect('localhost', 'root', '', 'pap') or die (mysqli_error ()); $strSQL1 = "SELECT…
-
3
votes2
answers1130
viewsA: Send PHP checkbox value
Try to do it this way: In HTML change the name to an array: name='tipoFesta[]' NO PHP handle array to ignore any blank fields: array_filter($_POST['tipoFesta']); Make a foreach and within it do the…
-
2
votes1
answer40
viewsA: Register filter by date
If you don’t need to compare the hours, use the function TRUNC: <?php $query = $mysql->query("SELECT * FROM c_clientes WHERE trunc(cliente_data_cadastro) BETWEEN '2018-04-07' AND…
-
0
votes1
answer34
viewsA: Combo filter with Jquery
To register, I decided as follows, placing this event in each field: $("#treinamento").on('change', function() { $("#validade_treinamento").prop('required',true)…
-
0
votes1
answer34
viewsQ: Combo filter with Jquery
I am using the code below to filter values between two combos. The value of the first does not appear in the second: $("#treinamento").on('change', function() {…
-
1
votes1
answer107
viewsQ: Datepicker with array
I’m trying to use a datePicker with array input, as there are 5 validity fields, which I will insert with PHP in an Oracle database. Using the option class the datePicker is called, but it only…
datepickerasked Diego 4,520 -
4
votes1
answer112
viewsQ: jQuery cutting words with space
I have a screen where the lines are loaded according to the data of the database and for this I have a PHP+jQuery and related to the creation of the same. What happens is that the array that sends…
-
0
votes1
answer43
viewsQ: datepicker with concatenated name
I need to call the function datePicker concatenating a fixed name with the name I bring from a query. It is possible? I tried that way: $("validade_T'.$v_id'").datepicker({ Where validade_T is the…
-
3
votes1
answer705
viewsQ: PHP Return AD user
I have the query below, which searches the full name of the registered AD user: <?php //Conexao com AD $ldapconfig['host']= '192.168.203.99'; //AD-001 $ldapconfig['port']= '389'; //Porta Padrão…
-
1
votes2
answers6025
viewsQ: Add blank Excel line using VBA
I have a spreadsheet with 10k lines, in this format (example): 3004977 \{DOWN} \{TAB 9} REMESSAS \%S 18082017 \{TAB} 2 \%D \^ S 3004972 \{DOWN} \{TAB 9} REMESSAS \%S 18082017 \{TAB} 3 \%D 3004972…
-
3
votes2
answers44
viewsQ: Allow only delete key
I have the script below, which blocks all typing in an input, forcing the user to use the DatePicker available: $(".readonly").keydown(function(e){ e.preventDefault(); }); In this same script, there…
-
3
votes1
answer38
viewsA: Loop for printing per page
In the place you want to break the page, put this command: <div style="page-break-after: always"></div> Will break to the next page.
-
0
votes2
answers235
viewsQ: Ensure query result random sorting
I have the query below, which I use to check IP’s valid collectors in the network for distribution of items for separation: Select distinct IP, USUARIO, trunc(DATA) from PCN_ROMANEIO_ACESSO PRA…
-
0
votes1
answer97
viewsQ: Group employees by company in query
I’m making a report, where I need to follow the following layout: With the query below, we ended up creating more lines, instead of grouping employees per company: select e.cnpj as cnpj,…
-
6
votes2
answers161
viewsA: What utility has this way of accessing variable values
Variables, dynamic variables or variables created during PHP execution. It is a feature that allows us to create a variable through the content of another variable. To create a variable you use one…
-
1
votes0
answers372
viewsQ: Search registered email in AD with PHP
I have PHP below that connects in AD using LDAP, working perfectly: <?php $username2 = $_POST["username"]; //Recebe o usuario do form "index.php" $password = $_POST["senha"]; //Recebe a senha do…
-
6
votes2
answers1350
viewsA: Add seconds to time - Excel
You can do it this way: 1) Convert seconds to an Excel time value (yes, that’s the term): Segundos / 86400 2) Then, in formatting convert it to a time field. Below is an example of how it would…
-
0
votes1
answer267
viewsA: How to submit via the PHP form, the selected option of an HTML5 select/option?
You can’t cross the field value blank or with a fixed value, you have to pass the information you want on the other page (id or name): Example: <option…
-
1
votes2
answers1771
viewsA: Javascript clock with NTP or server time
Using the same logic of the code that I had, I changed the code and now it takes the time of the server that is hosted the code. Worked perfectly: <?php //PEGA HORA ATUAL DO SERVIDOR…
javascriptanswered Diego 4,520 -
4
votes2
answers1771
viewsQ: Javascript clock with NTP or server time
I have the code below, which displays a clock on a page, which serves to record factory intervals. It works perfectly, with the code below: function moveRelogio(){ momentoAtual = new Date(); hora =…
javascriptasked Diego 4,520 -
4
votes2
answers35
viewsQ: Jquery ignoring houses on the right
I set the function below, for validation of values in two fields, one automatic (comes from the bank) and the other typed by the user. What happens is that, apparently, it ignores the houses to the…
-
4
votes3
answers899
viewsQ: Taking value from an array
I am trying to get the value of a table field created with Ajax. With the function below, all fields with the name qtde appear, including what I need. I need to make a simple account of a typed…
-
1
votes2
answers2083
viewsA: Block cell filled with VBA
If anyone need, I solved with the code below (adapted 2 I found on forums gringos) Option Explicit Dim blnUnlockedAllCells As Boolean Private Sub Worksheet_Change(ByVal Target As Range) Const…
-
6
votes2
answers2083
viewsQ: Block cell filled with VBA
We are setting up a routine where when filling a cell (C1, for example), automatically is filled date (A1) and time (B1) in the spreadsheet. Only right after the auto-fill I need the 2 cells to be…
-
1
votes0
answers55
viewsQ: Form action as radio button selection does not work
I am doing a validation of 2 radios Buttons, where depending on which form is selected forwards to a different page. I am using Jquery as below: jQuery(document).ready(function($) { var form =…
-
14
votes2
answers126902
viewsA: What is the difference between $(Document). ready() and window.onload?
The event ready occurs after the HTML document has been loaded, while the event onload occurs later, when all content (e.g., images) has also been loaded. The event onload is a standard DOM event,…
-
0
votes1
answer439
viewsQ: Onclick respect required field
I created an animation that appears on the screen and blocks the fields entered by the user while the request is processed, directly on submit, as below:…
-
1
votes0
answers442
viewsQ: Sweetalert follow execution
I have the confirm below using SweetAlert. If the user clicks the cancel it for the run and goes back to the previous page correctly. But if he clicks the continue, he does nothing. How can I make…
-
2
votes2
answers660
viewsQ: Sum dynamic line values automatically
As the example below, I am trying to add the value of the lines Qtde Transferir, that are generated dynamically as the result of the database, subtract from the value entered in the field Quantidade…
-
0
votes1
answer336
viewsQ: Return Ajax with multiple result and creating lines
Due to an internal need, I need to make the return of an Ajax query create lines for each displayed result. Today I have a function that I use and that works normally when the result is only one…
-
7
votes2
answers3863
viewsQ: Disable HTML5 Video Download Button
After updating Opera and Chrome, using the tag video started to appear the video download option, as below: Does anyone know how to disable this? I am using the following code: <video width="800"…
-
1
votes1
answer142
viewsQ: How to increase connection time for download?
Within my project, in the .htaccess, have set the following settings, for a company file exchange system: php_value memory_limit 6000M php_value post_max_size 6000M php_value upload_max_filesize…
-
1
votes1
answer103
viewsQ: Open responseText on a new page
Is there any way to open the responseText directly in a new window? I explain: The code I use sends data to a PHP file that returns N messages. If I do the following…
-
0
votes0
answers135
viewsQ: Send text together with Formdata Ajax file
I’m doing a test with the script below, for file upload: function uploadFile(){ var file = _("file1").files[0]; // alert(file.name+" | "+file.size+" | "+file.type); var formdata = new FormData();…
-
2
votes2
answers1542
viewsQ: PHP progress bar
I am using the functions below to make a progress bar: <script> function upload() { var request = new XMLHttpRequest(); request.upload.addEventListener("progress", uploadProgress, false);…