Posts by Gabriel Paixão Justino • 287 points
29 posts
-
0
votes1
answer22
viewsA: QRCODE Having Ireport Problems
In the SQL query I was using the CRC16 field without any treatment, this field had a blank space at the end, causing the problem, because the code was breaking. I made the following change in the…
-
-2
votes1
answer22
viewsQ: QRCODE Having Ireport Problems
My Qrcode is printing as follows on iReport, this way is in trouble: Correct would be in this format: I have already realized all the necessary configurations for the operation of it. 1 - I added…
-
0
votes1
answer259
viewsQ: How to create a Function that calculates CRC16 in SQL Server?
can tell me if there is any sql function that calculates CRC16, the calculation method is listed as "CRC-CCITT (0xFFFF)". CRC-CCITT (0xFFFF) -> polynomial: x 16 + x 12 + x 5 + 1 I tried to create…
-
-2
votes3
answers56
viewsQ: How do you put a div that’s inside a container under each other?
I’m having the following problem, my Divs are getting online, I’ve tried several ways to try to insert one under the other, but it still doesn’t work. The correct would be to stay in the format…
-
1
votes1
answer45
viewsQ: How to insert one div on top of the other?
I’m trying to insert a div with the name on top of the main one, I’m creating a goal monitoring panel, where the channel comes in the header and the percentage will be the center, as example of the…
-
0
votes1
answer301
viewsQ: Invalid or Unexpected token
When trying to execute the code below fetch(`https://mktp.oversystem.com.br:8443/MKTPlace2/rest/sinistrosZurich`, { method: "GET", header: { "Access-token": "aC0009E000081007F400dF210",…
-
0
votes1
answer269
viewsQ: How to convert Datetime to timestamp? (SQL SERVER)
Today I have the following situation, I need to send the current date and time of the request in an int format, as image below Below are some attempts I made, but when testing the conversion to date…
-
0
votes1
answer17
viewsA: How to Create XML Array in SQL
I was able to solve the problem using FOR PATH XML. The code was in the format below. SELECT(SELECT ITE.CODPROD AS SKU, ITE.VLRUNIT AS NIR_PRECO_UNITARIO1 FROM SANKHYA.TGFCAB CAB (NOLOCK) LEFT JOIN…
-
0
votes1
answer17
viewsQ: How to Create XML Array in SQL
I have the following XML structure <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:gen="http://www.rapidaocometa.com.br/GenPoWMS10In"…
-
-2
votes1
answer70
viewsQ: How to create Divs with Specific Images?
What is the best way to create Ivs with the images below using CSS? I would like my dashboard to look exactly like the image you have as an example. I created two classes to try to insert, but the…
-
0
votes1
answer48
viewsQ: How to look at the field that is being changed in a Procedure?
I created a precedent where after running or updating in a table the flag is marked S automatically, causing this item to go up to an integration and integration after the return of success mark the…
-
1
votes1
answer8559
viewsQ: Like putting a div under one?
Gentlemen, I’m trying to insert a div under the other, the same should be according to the attached image, but when I execute it is not working. It follows an excerpt of my code, must be some detail…
-
1
votes1
answer289
viewsQ: Drop or Truncate table with 80 million records?
I have a table with 80 million records, clean it without deleting the table, because it is used in real time, what is the best suggestion so that I can clean this table without losing the…
-
1
votes1
answer89
viewsA: How to remove the special character that forms inside a String in SQL?
I solved the problem using ' ', I found this character in the Windows character map, it solved my problem.
-
0
votes1
answer89
viewsQ: How to remove the special character that forms inside a String in SQL?
I am using the excerpt below in my code, but when inserting > inside a String, it returns the result as > ;, the same is converting to HTML entity, as I can use '>', without problems?…
-
0
votes0
answers500
viewsQ: HTTP Status 500 - Internal Server Error
After trying to make a call in the Glasfish Webservice is occurring the error below, I am trying to make a call in the Webservice Rest Json, in the XML Rest call it runs normally. package…
-
0
votes1
answer44
viewsQ: Difficulty Positioning Background Image
[![insert the image description here][1][1]Gentlemen(as), I am trying to position an image to the background of my project, but when using the cover the same cuts the bottom, and when I use any…
htmlasked Gabriel Paixão Justino 287 -
0
votes1
answer254
viewsQ: Is it possible to filter through a calculated column?
Gentlemen(s), I am performing the following select on my database. SELECT TOP 5 A.APELIDO, A.REALIZADO, A.META, CAST((A.REALIZADO/A.META)*100 AS DECIMAL(10)) AS ACUMULADO, DENSE_RANK() OVER (ORDER…
-
3
votes1
answer154
viewsQ: How to improve my HTML layout?
Gentlemen(as), I need to make the following rectangles below in html, can instruct me what would be the best option indicated? body { width: 100%; height: 100%; margin: 0; padding: 0; } body {…
htmlasked Gabriel Paixão Justino 287 -
2
votes1
answer743
viewsQ: How not to bring a particular column in SQL using IF and ELSE?
Gentlemen, I have a table where I want to bring the column when the value is null but when it is filled it should not be displayed, as I can implement this condition in SQL ? SELECT OBS.NUOBS,…
-
1
votes1
answer201
viewsQ: How to control height within a Grid?
Currently, I have the code below, I would like to descend to marca and meta to the edge of the red line, how can I move them ? html, body { width: 100%; height: 100%; margin: 0; padding: 0; } body {…
-
3
votes4
answers9972
viewsQ: How to get the month and current year in SQL?
How can I print the current month and year on the screen in sql ? I need the month to be extended. I’m using the query below. select GETDATE() from DUAL Currently it is being printed as follows.…
-
2
votes1
answer507
viewsQ: How to create a View with filter?
I created the following query in my BD, I need to create a View from this query, the same should return the 3 initial columns realized, meta and accumulated, according to which the select is…
sql-serverasked Gabriel Paixão Justino 287 -
0
votes1
answer46
viewsQ: Which operator should I use in Javascript c:if when I want to be between two variables?
Gentlemen, I need to know which operator to use in c:if of Javascript when I want to make a decision between themselves, for example, I need a background of a Div turned red when it is between the…
-
0
votes1
answer244
viewsQ: How to format a Grid within Div?
Gentlemen, I am trying to insert a grid inside my Divs, but it is in conflict with the top part, as image attached, follows an excerpt of my code where the problem occurs. I have the div row1 which…
-
1
votes1
answer2093
viewsQ: How to format numbers directly by SQL
Gentlemen, my numbers are coming out without formatting when I perform the select directly at the bank, they are coming out as follows: REALIZADO META 61274436,2090003 80000000,00 How can I make…
-
1
votes1
answer62
viewsQ: How to improve the formatting of information within my Div?
Gentlemen, I need to format my Div according to the image attached below, with Meta information about Div, etc. Currently my code is breaking this information into lines, as attached image. Follow…
-
0
votes1
answer570
viewsQ: How to format a number in percentage within Javascript?
Gentlemen, I am developing a billing monitoring panel. I want to turn this number 56% directly into my Javascript code. Follow an excerpt of my code, it is directly fed by a query of my SQL. This is…
-
1
votes1
answer48
viewsQ: Javascript Formatting of Dates
could you help me please? I would like to use the function below in a logic that I am creating, but I would need the function below to return to me only the last week of the month, I am not able to…