Posts by Guilherme Montagnani • 39 points
8 posts
-
0
votes1
answer59
viewsA: SQL Summing all values, how to break by blocks
The problem was solved by inserting a Join that "ties" the request id so that it disappears line by line. I also had to replace Inner Join with a left Join. Thanks for the help!
-
0
votes1
answer59
viewsQ: SQL Summing all values, how to break by blocks
I have a table that stores financial values per month, I need to display by year, I made a SUM and it worked when I have only one project registered, when I have more than one project it sums up all…
-
0
votes0
answers95
viewsQ: Insert line breaks into HTML for Outlook
Good night. I have a routine that sends emails to users with a simple text, but in outlook it does not recognize line breaks, making reading practically impractical. The line breaking is done by a…
-
0
votes1
answer52
viewsQ: How to use concatenation function in JSP file
Good afternoon. I have an SQL query with 3 Where clauses, but I need to activate them only when the values are filled in. How can I make the jsp file recognize that for example field 1 is filled in,…
jspasked Guilherme Montagnani 39 -
0
votes1
answer43
viewsQ: How to Optimize Substring Regular Expression in Oracle BD
I have the following expression: SELECT us.FULL_NAME, us.USER_ID FROM knta_users us WHERE USER_ID IN(SELECT DISTINCT REGEXP_SUBSTR(PRJ.PRJ_PROJECT_MANAGER_USER_ID, '[^#@#]+', 1, LEVEL) AS GP_ID FROM…
-
1
votes1
answer2516
viewsQ: Insert css image into HTML tables
Good morning, I would like to insert an image inside a column in the table, leaving it in the center. The most I could do is according to code below, but this way it stays with a border around as if…
-
0
votes1
answer88
viewsQ: Filter empty or null value in JSP file using SQL
Good afternoon, I have an SQL query as code below where I have 3 filters, these filters use the clause Where, and e and but if one of the filters is blank the value returned is also blank. How can I…
-
2
votes3
answers1050
viewsQ: Separate Tables in Columns using HTML
I need to distribute 10 tables in 2 columns of 5 for display. How can I do this distribution or separate the tables from the example below by a space or something similar? <HTML> <BODY>…
htmlasked Guilherme Montagnani 39