Posts by tarsomatos • 108 points
13 posts
-
0
votes1
answer307
viewsA: ORA-00907: Missing right parenthesis, but why?
The correct would be to store the full date: create table horario ( codhorario number(8) , horainicio DATE, horafim DATE ); In case you only wanted it an hour and a minute later. Through select vc…
-
0
votes1
answer35
viewsA: Capture checkboxes marked in a View
I’m not sure I understand your question, but come on. For this first you have to put the value in the value of the input @{int i = 0;} @foreach (var item in ViewBag.Contratos) { <tr>…
-
0
votes1
answer67
viewsA: How to bring in Razor a Dropdown with the element already selected from a database?
Yuri, try returning in your Viewbag a Selectlist. I don’t know if I understand this correctly, but you’re putting together a Dropdownlist sequence. I believe that the value you are bringing in…
-
0
votes2
answers162
viewsA: MYSQL - How to return records that exist in one table and do not exist in another?
I didn’t see which reference field between the tables. However, you can do this command. Taking into account that there is a reference key in contract idNPSParticipants. select * from…
-
3
votes1
answer39
viewsA: Assign date to a var date in oracle
The function to_date takes two parameter. parameter is the date date format v_data := to_date('01022020', 'ddmmyyyy'); more examples: TO_DATE ('2003/07/09', 'aaaa / mm / dd') Resultado: valor da…
oracleanswered tarsomatos 108 -
0
votes3
answers215
viewsA: Problems with connectionString in ASP.NET C# CORE
The correct command using lib System.Configuration 4.0.0 is ConfigurationManager.AppSettings[paramName];
-
0
votes1
answer29
viewsA: Slow problem with CAST in consultation
If your database is set to Innodb. You could create an INDEX for table/field. Thus the database will index the table and the queries filtering that/those fields would be faster. Note: This guideline…
mysqlanswered tarsomatos 108 -
1
votes3
answers1426
viewsA: Find element without tag ID and Name
You can also use it to find the element by the name of the css class var x = document.getElementsByClassName("btn"); If you are using jQuery becomes even easier and faster, because you have to put…
-
0
votes1
answer22
viewsA: Asp.Net Identity using Procedure
Identity would not be compatible with this mode of use, however you can use a Entityframework to create the ORM in this way. So it would be transparent for you. So it would generate the code…
-
0
votes1
answer156
viewsA: How to get a return from a subreport in Jasper
It would be valid to pass which version you are using. I think we are missing you define which type of return subreport expression is java.lang.String Try: <subreport runToBottom="false">…
-
1
votes3
answers7164
viewsA: LEFT JOIN SUBQUERY
If your select filter is right, the code can be this one: SELECT T.ID, T.NOME, T.ATUALIZACOES FROM ( SELECT A.ID, A.NOME, (SELECT COUNT(C.ID) FROM POSTAGENS AS C WHERE C.DATA_CADASTRO >…
sqlanswered tarsomatos 108 -
0
votes2
answers74
viewsA: How I see the code of an already interpreted html page
This is because the page is dynamic. It is built with javascript and/or frameworks like : angular, vueJs, reactJs, etc... HTML is built upon entering the screen, most likely in the document’s…
-
1
votes1
answer39
viewsA: change webconfig mysql+ Connection. NET
Assuming that user’s password is correct, the error message: Mysqlexception: Access denied for user 'meuusario'@'ipdobanco' (using password: NO) This may mean that the user is not allowed to connect…