Posts by Lucas Matias • 640 points
25 posts
-
1
votes4
answers3686
viewsA: How to get javascript/jquery array content?
You can take the element that is being iterated on each using this. var arrayIDs = [ {id_produto_itens: 150, id_proposta: "123"}, {id_produto_itens: 160, id_proposta: "123"}, {id_produto_itens: 176,…
-
3
votes2
answers2352
viewsA: Reset datetime time with SQL
You can use the format and spend the zeroed part of hours. Ex: SELECT FORMAT(GETDATE(), 'yyyy-MM-dd 00:00:00') AS DATE;
-
0
votes1
answer219
viewsA: Record Video and Upload C# MVC
Well, considering that the library returns the file as an input file, what you can do to save it without submitting it is using localStorage. Since you left no more details about your code, I’ll…
-
2
votes1
answer928
viewsA: How to print JSON object list
To print the list you can use the following function: var obj = { "posts": { "data": [ { "created_time": "2017-11-16T19:52:28+0000", "message": "Teste | JAGUAFRANGOS | A Agência produziu os layouts,…
-
0
votes1
answer447
viewsA: Change display at the push of a button
Define that the second div will get hidden by assigning the style="display:none;" and assign to its inputs the property: onchange="ManipulaConteudo();". Add the function to your javascript: function…
-
3
votes1
answer257
viewsA: Write address by coordinates and pick up google maps
What you want to do is use Geocoding. The way to use will depend on the language you choose. As unspecified, follow a basic example in JS. var geocoder = new google.maps.Geocoder();…
-
1
votes2
answers220
viewsA: What is the best way to treat Exceptions and Log in Webapi (C#)?
I recommend taking a look at Log4net that is very popular and it is possible to find interesting content in Portuguese (Ex: Macoratti) and in the Elmah which is a very complete and very interesting…
-
0
votes2
answers326
viewsA: how to save date with Date type in MYSQL and return to an Android app
Dates in Mysql are 'YYYY-MM-DD' format and support a range from '1000-01-01' up to '9999-12-31'. Check if the date you are reporting is in this format and is valid. If you need to convert, use the…
-
10
votes2
answers31808
viewsA: The difference between COALESCE and NVL
The differences are: COALESCE follows the ANSI standard while NVL is specific to Oracle; NVL accepts only 2 pointers while COALESCE can receive multiple arguments; NVL executes both arguments and…
-
1
votes1
answer58
viewsA: Daily folder creation in C#
You can use the Getlastwritetime to get the latest directory: Ex: new DirectoryInfo(path).GetDirectories().OrderByDescending(d=>d.LastWriteTimeUtc).First();…
c#answered Lucas Matias 640 -
2
votes2
answers343
viewsA: submit a form when selecting a select option, without re-loading the page
You are not sending Hidden data. Use serialize to send all the data of your form. Ex: var dataString = $("form").serialize();…
-
0
votes1
answer178
viewsA: Update in PL/SQL
The command update can only be applied to one table at a time. If you want to ensure that the two occur together, you can use a transaction. Or you can fire a Trigger that after the first update,…
pl-sqlanswered Lucas Matias 640 -
0
votes2
answers121
viewsA: Execute code inside Event Listener
You can abstract the content of this function, and create another, calling it when you want. Ex: function Teste(){ alert("teste"); } document.getElementById("voltar").addEventListener('click',…
javascriptanswered Lucas Matias 640 -
1
votes2
answers243
viewsA: How do I capture the value of this input when I click enter in input and without using form?
Use the keycode to capture enter and retrieve the value of the field by calling the function in some key event (keypress, keyDown or keyUp). Ex: function ObterValor(e) { if (e.keyCode == 13) {…
-
1
votes2
answers1323
viewsA: Get CSS by Javascript
You can use the getComputedStyle. Ex: function ObterCSS(element){ var css = ''; var o = getComputedStyle(element); for(var i = 0; i < o.length; i++){ css+=o[i] + ':' +…
-
1
votes2
answers102
viewsA: Position element using another element reference
You can recover the position and size of the reference element and set the position of your element from the sum of them so that it is below. var elementoReferencia = $(".taskAtiv"); var posicao =…
-
2
votes1
answer885
viewsA: Jquery plugins use different versions, how to bypass?
Yes, with the jQuery.noConflict() you can do something like this: <script type="text/javascript" src="jquery-1.9.0.js"></script> <script> $190 = jQuery.noConflict();</script>…
-
2
votes1
answer144
viewsA: Why does Oracle not have autoincrement?
From version 12c it is already possible to use this feature. Take a look at this link. Now, the exact reason for not implementing before, would only be possible to obtain through some note of Oracle…
-
2
votes1
answer104
viewsA: Get click (this) element in method
To get your element in the function you can send it as a parameter to it. Ex: <i onclick="FuncaoTeste(this);">Teste</i> var FuncaoTeste = function(element) { console.log(element); } If…
-
1
votes2
answers259
viewsA: Single auto increment on all DB tables
The auto increment is individual from each table. To standardize your Ids, you can control through your application or Trigger/function, where you would recover the ID of the generated in the table…
-
2
votes2
answers755
viewsA: Visual Studio 2017 no template
You need to install from the Visual Studio installer. Click the "Workload" tab in the upper left corner, then tick the right ". NET-Desktop Development" and click Install. Note that this can modify…
-
0
votes2
answers64
viewsA: Cellclick event, does not return Datetime value
Put a breakpoint on that line, select dgvOS[2, poc].Value and press "Shift + F9" to see its result. This string returned is the cause of the problem as it is not a valid Datetime as pointed out by…
-
0
votes2
answers256
viewsA: Table take margins in media print
Check that your selector is being applied correctly and that the print style is being called properly. Ex: <link rel="stylesheet" href="#" media="print">.
cssanswered Lucas Matias 640 -
1
votes3
answers82
viewsA: Error formatting date in C#
The question appears because its Datetime property can be null. And a null Datetime does not have the method ToString(String), therefore presents error. To solve your problem, replace the type of…
c#answered Lucas Matias 640 -
2
votes5
answers3132
viewsA: What is the difference between comparison operators on Oracle?
There is no difference in performance only the syntax that is different. But if you want to make a query compatible with the SQL standard, use the operator "<>" which is also accepted on other…