Posts by Jean Gustavo Prates • 3,067 points
71 posts
-
4
votes1
answer357
viewsA: Send mouse click
If you are using Windows Forms, to move the cursor use the class Cursor. this.Cursor = new Cursor(Cursor.Current.Handle); Cursor.Position = new Point(Cursor.Position.X - positionX, Cursor.Position.Y…
c#answered Jean Gustavo Prates 3,067 -
1
votes2
answers215
viewsA: Ignore dot in a Query
You can use the function REPLACE to remove the points. Below is an example. REPLACE('99.999.999', '.','')
-
4
votes1
answer4634
viewsA: How to change an SQL Server View
Use as an example the query below. ALTER VIEW [dbo].[VIEW_EXEMPLO] AS SELECT 1 GO Or follow this step by step. Right click on the view; Click on Script View as Click on ALTER To…
-
19
votes1
answer50369
viewsA: How do I get current Javascript url?
Try using the code below var url_atual = window.location.href;
-
2
votes1
answer159
viewsA: Wrong string to double conversion
This is because the culture that is using does not consider the point as decimal separator (PT-BR). To avoid this, you must define a culture that you consider. You can use as an example the code…
-
3
votes2
answers8263
viewsA: Assign Mysql query result to a PHP variable
It is correct the way you have developed, alias, can use other types of returns that you expect as Object, Associative or Array. Examples //Objeto while ($row = mysql_fetch_object($result)) { echo…
-
2
votes2
answers113
viewsA: Calling function without signature knowledge
Rafael, C does not support this type of operation. What you can do is compile a dll with the functions and then search the function by name within the dll. Example #include <Windows.h> HANDLE…
canswered Jean Gustavo Prates 3,067 -
4
votes2
answers475
viewsA: Malloc improperly reserving memory?
André, The function malloc finds spaces in the memory that are available. Using the cited form, only the address of ptr[0] will be "reserved" for your program, with this, your program may present…
-
3
votes1
answer172
viewsA: Search by dates
You did not use simple quotes to use the like, try changing the content of the table variable to the proposed below: tabela = consulta.executeQuery("SELECT a.cod_arquivo, a.nome_arquivo,…
-
4
votes1
answer3116
viewsA: Add multiple select Count results to MYSQL
Can add up the result of a Subselect SELECT SUM(CLIENTES) FROM ( SELECT COUNT(1) AS CLIENTES FROM X1.CLIENTES UNION ALL SELECT COUNT(1) AS CLIENTES FROM X2.CLIENTES ) AS T…
-
1
votes4
answers504
viewsA: Filter numbers not yet registered via SQL
Emerson, To verify which codes were not registered in the range, you can execute the query below by changing the table name. DECLARE @CONTADOR INTEGER DECLARE @TT INTEGER CREATE TABLE #CODIGO (…
-
1
votes2
answers2034
viewsA: Passing values from a select to subselect
Giancarlo, you can use temporary tables or Join with select, follow examples below. Using temporary table. CREATE TABLE #TABLE_PORCENTAGEM ( QUANTIDADE BIGINT, CODIGOT NVARCHAR(MAX) ) INSERT INTO…
-
2
votes2
answers774
viewsA: Generating random number in C language
Try to use the section below int rand[8]; int range; srand(time(NULL)); range = (1000 - 1) + 1; for(int i = 0; i < 8; i++) { rand[i] = rand() % range + 1; }
-
0
votes2
answers2226
viewsQ: What better way to insert an array into the database
I would like to know how to best insert an array into a database table. I could use a foreach but I would like something performative because I will work with large number of data. foreach (var item…
-
1
votes1
answer36
viewsA: Can you create a "Reader Mode" with PHP?
Carlos, 1) Create the file Readability.php 2) Create the file Jslikehtmlelement.php 3) Create the index.php file with this code: In the stretch $url = 'http://'; Add the website address. Taken from…
phpanswered Jean Gustavo Prates 3,067 -
0
votes1
answer3466
viewsA: Display numerical values without scientific notation in Oracle select
The numformat set numformat 99999999999 select * from teste_numerico;
oracleanswered Jean Gustavo Prates 3,067 -
0
votes1
answer2827
viewsQ: Consume Webservice WSDL
Good afternoon, I am trying to consume a Webservice using ASP.NET, however, after adding its reference and executing the method, the parameters return null, generating Exception. I tried to run…
-
0
votes1
answer805
viewsQ: VBA does not recognize values
I am trying to get data type values from a certain excel cell, however, my macro does not recognize the values of the cell, even if it is filled (date). Remembering that there are three Heets. With…
-
0
votes4
answers395
viewsA: How to Debug only one project in Visual Studio?
Right click on the project. Select Debug. Click on Start new Instance.
-
0
votes1
answer256
viewsQ: Automatically list products from different stores
I have a question in comparing prices of products from different stores, I have no idea which component to use or how to do this. The idea is to do something similar to Buscapé and Zoom (relate the…
-
1
votes1
answer218
viewsQ: Element <Strong> returning empty - Htmlagilitypack
I’m trying to get the contents of an Strong text from the submarine site. When I open the website with browser I can see in the code the content however, using Htmlagilitypack the content returns…