Posts by Fernando Souza • 1,887 points
25 posts
-
3
votes1
answer44
viewsA: php search with UNION - mysql_num_rows error
As discussed in the comments: 1) Double quotes were missing in the first two selects SELECT * FROM noticia WHERE noticia_title LIKE "%'.$q.'%" SELECT * FROM eventos WHERE evento_nome LIKE "%'.$q.'%"…
-
5
votes2
answers77
viewsA: Updating multiple records at the same time
I created in the SQLFiddle an example based on what you gave us of the structure of your table, and I adjusted with the response of @escapistabr so that you can check if it meets your need. Create…
-
7
votes3
answers1947
viewsA: Add time column in SQL SERVER
You can do it this way: create table t1 (id int, t time) insert into t1 values (1,'00:00:25.0000000') insert into t1 values (1,'00:12:20.0000000') insert into t1 values (2,'00:00:02.0000000') insert…
-
4
votes1
answer192
viewsA: Test Automation (Slow down running speed)
Try to change the property Delay Between actions as shown below: Maybe this can help you.…
-
6
votes1
answer47
viewsA: Null Pointer after Try catch
The name of the birth date input is different from the name used in the getParameter(String). One is like this: dataNascimento, and the other one is like this: DataNascimento the getParameter is…
javaanswered Fernando Souza 1,887 -
7
votes1
answer3994
viewsA: Reset Auto-increment SQL Server
I simulated your question as follows I did the insert of 83 records in one table I deleted the records from the table I executed the command to list what value the AUTO_INCREMENT table SELECT…
-
7
votes2
answers85
viewsA: Inner Join - SQL Server
You forgot to remove the comma before the FROM, in this line [ComPlano].[CodigoPlano] AS [CodPlanoC] And as commented by Paulo R. F. Amorim : Use the alias created for the INNER JOIN causes error…
-
6
votes1
answer92
viewsA: What’s wrong with that code?
The problem with the code is that if there is more than one concurrent call on first access to the method getInstance() it can create two Test instances. The basic solution for this is to…
javaanswered Fernando Souza 1,887 -
19
votes3
answers1684
viewsA: Why Arrays start at 0 and not 1
An array is a set of elements arranged side-by-side in memory, from an address. For example, let’s say in memory you have 10 integers in an array. And that the address of that array in memory is 100…
-
3
votes2
answers44
viewsA: Disable Aspxrichedit buttons
Add this code to the Prerender event: [C#] @Html.DevExpress().Spreadsheet(settings => { settings.Name = "Spreadsheet"; settings.PreRender = (s, e) => {…
-
5
votes1
answer739
viewsA: Returning week number of the month
Maybe this can help you: weekNum: Integer; weekNum:=(StrToInt(FormatDateTime('dd',Date)) - 1) div 7 + 1 ;
-
6
votes1
answer111
viewsA: Error using Case and Select in PL-SQL
Try to run your select this way: DECLARE BEGIN SELECT p.categoria, CASE WHEN p.categoria = 'A' THEN DBMS_OUTPUT.PUT_LINE('A') ELSE 2000 END FROM PRODUTO_TESTE2 p; END;…
-
4
votes2
answers344
viewsA: PHP script to open Csvs files directly, no need for fomulário sending
You can use the function glob() to search for CSV files. $files = glob('*.csv'); var_dump(files); Exit: array(3) { [0]=> string(8) "test.csv" [1]=> string(9) "test1.csv" [2]=> string(9)…
-
5
votes2
answers3844
viewsA: How to delete commits from gitlab
Try to reverse your commit in gitlab: References: Gitlab Docs If that’s not what you’re looking for, you can take a look at this documentation on Gitlab - Rollback Commits…
-
6
votes1
answer460
viewsA: How to install the Typescript Plugin in Sublime Text 3?
Try to follow this step by step:…
-
4
votes1
answer70
viewsA: SQL Reporting Services: Problems with Arrows on the Chart
You must select the graphics and press F4 to access their properties. Go to the Smartlabels area and change the Calloutlineanchor property to change the arrow and/or put another symbol You can…
reporting-servicesanswered Fernando Souza 1,887 -
14
votes3
answers605
viewsA: How to give a Regex before a string? And select?
In this case REGEX will take everything up to the first (:) Match result = Regex.Match(text, @"^.*?(?=:)");
-
3
votes1
answer485
viewsA: Asynchronously checking existing files
I wonder if this might help you? Documentation var fs = require("fs"); var Promise = require("bluebird"); function existsAsync(path) { return new Promise(function(resolve, reject){ fs.exists(path,…
node.jsanswered Fernando Souza 1,887 -
4
votes1
answer47
viewsQ: REGEX of HH:MM:SS may be negative
I’m working with HH:MM:SS and I have this REGEX ^([0-1]?\\d{0,4})(?::([0-5]?\\d))?(?::([0-5]?\\d))?$ I’m using the library Inputmask but I would like to work with negative hours example: Effort:…
regexasked Fernando Souza 1,887 -
3
votes3
answers119
viewsQ: Invalidcharactererror
I have a variable inputParams with the string "Teste StackOverflow€" But I need to do the btoa() of this variable and the error is occurring: Failed to execute 'btoa' on 'Window': The string to be…
javascriptasked Fernando Souza 1,887 -
10
votes1
answer1387
viewsQ: Difference between exhaust, encodeURI and encodeURIComponent
What is the difference between these three functions, and when to use each of them? escape() encodeURI() encodeURIComponent()…
javascriptasked Fernando Souza 1,887 -
2
votes1
answer66
viewsA: How to add a Music embedded in a file. HTA
Try to base yourself using this code <html> <head> <title>Hackoo Audio Player with Playlist by Hackoo 2014</title> <HTA:APPLICATION ID = "Music"…
htmlanswered Fernando Souza 1,887 -
3
votes1
answer647
viewsA: Select data from a spreadsheet
I wonder if this might help you? output = [] f = open( 'arquivo.csv', 'rU' ) #abrir o arquivo em read universal mode for line in f: cells = line.split( "," ) output.append( ( cells[ 0 ], cells[ 1 ],…
-
4
votes1
answer243
viewsA: Source delay to load on the hosted site
Steve Sauders did an article on this topic, but is in English, if you understand worth checking. In short: Just use @font-face if you really need to use. Post your statement @font-face above all…
cssanswered Fernando Souza 1,887 -
3
votes2
answers951
viewsA: Draw a circle on an image with Javascript
From what I understand, that’s what you wanted? jQuery(document).ready(function(){ $('#special').attr('height', $('#special').css('height')); $('#special').attr('width', $('#special').css('width'));…