Posts by lpacheco • 1,870 points
16 posts
-
1
votes1
answer95
viewsA: GIT --Bare with existing files
Actually, it’s two distinct steps: Create your repository with git init --bare; Initialize git in your existing project directory, add step repository (1) as a remote, and push your code.…
-
2
votes1
answer44
viewsA: Inaccuracy of column sum result
Look, this isn’t actually a bug, but a feature of how floating point numbers (with decimal places) are stored and operated on the memory of computers. Since numbers are coded in binary and have a…
-
3
votes2
answers2921
viewsA: How to use ternary IF
v = StrToInt(Edit1.Text); Edit2.Text = IfThen(v < 30, '30', IfThen(v in [30..50], '40', '50'));
-
10
votes4
answers1189
viewsA: How does a search engine work?
I understand there are three parties involved: a Crawler, which navigates the pages retrieving content and identifying references to other pages; an indexer, which evaluates the content of the page…
-
1
votes1
answer200
viewsA: Doubt group by + SUM function
Your query does not do what you say, starting with "each participant", as you have not included the attendee identifier in the SELECT. To know how many days each participant attended, you should do:…
-
0
votes1
answer111
viewsA: How to make an SQL do the correct property count under certain criteria
When you do inner join fotos on fotos.cod=imoveis.id you say that for each immovable.id there is a photo with corresponding.Cod photos. If your photo table doesn’t have a photo for each immoble, the…
-
0
votes1
answer361
viewsA: Convert a string of numbers into a word
From your comments, I understand that you want to model a mobile keyboard. If so, instead of a dictionary for all keys, you should have a vector for each one. tecla2 = ("A", "B", "C") tecla3 = ("D",…
python-2.7answered lpacheco 1,870 -
2
votes2
answers600
views -
127
votes4
answers233186
viewsA: What is the difference between INNER JOIN and OUTER JOIN?
I like images to understand joins.
-
1
votes2
answers985
viewsA: How to make an INNER JOIN not repeat information
When your query uses an aggregation function, you should put all the other SELECT fields in a GROUP BY clause. Your query should be SELECT clientes.id, clientes.nome, clientes.status,…
-
1
votes1
answer323
viewsA: Developing in Python with Visual Studio 2013
The Python Tools for Visual Studio attend to you? It already comes with VS 2015 (maybe you have to enable in your installation) and can be installed on VS 2013, or even VS 2010 and 2012.…
-
2
votes3
answers41
viewsA: Pointed from Pointed C
Quoting the Stack Overflow (in English): list of characters (one word): char *word; sentence (a list of words): char **sentence; monologue (list of sentences): char ***monologue; And so on and so…
-
1
votes1
answer457
viewsA: Champ inconnu error dans on clause - SQL
You are doing a type LEFT JOIN with type_servico, but the condition of Join uses a field that is in occurrence. FROM ocorrencias o, tipo_servico ts LEFT JOIN tipo_falha tf1 on tf1.cod =…
-
0
votes3
answers72
viewsA: Largest number in array, does not display
You didn’t initialize your matrix and initialized higher with the value of mat[0][0], which you do not know which is. Try it this way: int mat[lin][col]; int i, j, pos_i, pos_j; /* inicializa a…
-
1
votes3
answers2033
viewsA: SQL command inside a variable varchar - sql server
You are closing the string with two single quotes when you are going to concatenate. As two Single quotes are the exhaust to include one quotation marks on the string, then to close the string just…
sql-serveranswered lpacheco 1,870 -
18
votes6
answers2300
viewsA: AJAX is not a programming language. So what is it?
To implement the Exchange web interface (OWA) without using page exchange to load new content, Microsoft created an interface in its MSXML component that allowed sending a request over HTTP and…