Posts by Robson Cabral • 55 points
15 posts
-
0
votes2
answers93
viewsQ: How do I get as much and as little as possible of a consult?
I have the following consultation: select DATEDIFF("D",DtVencimento,DtBaixa) as atraso from Entrada where Id='1' and DtEmissao >='01/01/2020' and DtEmissao <='01/12/2020' and ((VlBaixado is…
-
0
votes1
answer64
viewsQ: How to select all options from a select to submit?
I am unable to send the selected options when I enter the code below. Out of code is working. the page receives information and assembles the box according to the requests that came, so it is…
-
0
votes1
answer69
viewsQ: How to block the suggestion list of an input text?
I want to block that list of suggestions that appears when you type something in a text field, someone knows how to do it?…
-
0
votes1
answer140
viewsA: Copy an option from one select to another with jquery
moving here I managed to solve the problem as follows. ''' function ordenarOptions(obj) { var options = $("#"+obj+" option"); options.sort(function(a, b) { var at = $(a).text(); var bt =…
-
0
votes1
answer140
viewsQ: Copy an option from one select to another with jquery
Guys I am trying to copy the options from one select to another using change, but when copying is passing the value of the option I selected and the text of all the options of select at the same…
-
2
votes0
answers26
viewsQ: How to validate an input type number to accept only numbers?
I am wanting to configure the input number of Html5 to accept only numbers, but it is accepting the letter "and" and also ",." I’m doing it this way: <label for="txtHora">Hora…
-
-1
votes2
answers418
viewsQ: How can I recover File explorer from VS Code side menu?
I’m having a problem, in the office pc that file explorer icon that is in the side menu of vs code is gone, even opening the project or the project folder it does not paparece. To appear I use…
visual-studio-codeasked Robson Cabral 55 -
0
votes1
answer73
viewsQ: How do I pass a list of parameters to a precedent?
I want to pass N parameters of N types to a dynamic process. How can I do it? Example: struct = (Here the structure will be mounted with several parameters) struct.id = 123 struct.name='Marisa'…
-
0
votes1
answer62
viewsA: Help to call function
Oops, have you tried calling your function in window.load? ''' window.onload = function(){ console.log('Onload disparado'); } ''' Can you use jquery? In jquery you can use $(Document). ready() '''…
-
0
votes1
answer30
viewsQ: How do I get back the id of the new record created in a table using cursor and Procedure in SQL Server?
I’m trying to make my previous run and return the registration ID that has just been created, as I don’t have much knowledge of cursors and procedures I don’t know where I am failing. When I run the…
-
0
votes0
answers224
viewsQ: How do I make an Insert into using dynamic SQL and run sp_executesql?
I am trying to make an Insert using cursor and execute sp_executesql using variable, the first time it ran and did not return anything, I went to the table and had not added any record. Then I ran…
-
0
votes1
answer45
viewsQ: How can I use sp_executesql to execute a query mounted on a variable?
I’m learning to use cursors and I’m trying to run a query I’ve mounted within a variable but it’s giving the following error: "Message 214, Level 16, Status 2, Procedure sp_executesql, Line 1…
-
0
votes0
answers38
viewsQ: How can I clone a record from a stored table using Procedure and picking up the fields dynamically?
I have the need to clone a record into a table but picking up the fields the way they are, the reason is that someone can insert or remove some column, so I don’t know which columns I have in the…
-
0
votes1
answer28
viewsA: Bug in Javascript validation
Oops, I just identified my problem. js is treating the contents of the fields as strings, so I used the js number and it worked. Stayed like this... bindEvent("click",".next",function(event){…
javascriptanswered Robson Cabral 55 -
0
votes1
answer28
viewsQ: Bug in Javascript validation
Hello. I have developed a process bar with a next and preview button, where clicking next will reduce the processes. I have 2 fields on the screen, "position" and "totalItems", where position needs…
javascriptasked Robson Cabral 55