Posts by Onaiggac • 1,127 points
62 posts
-
1
votes1
answer90
viewsA: Change output of an input type time
Nothing prevents you from handling the information at destination (index.html). However, if it is a restriction of your project you can do it as follows: <input type="time"…
-
3
votes1
answer1226
viewsA: Check if the date selected is javascript weekend
First you have to create a Date type object by watching the Timezone (GMT -0300) for Brasilia time, if applicable. var Minha_data = new Date('Fri May 17 2019 11:20:58 GMT-0300'); Or in a more…
-
1
votes4
answers120
viewsA: Simplification of the jQuery code
I think you can simplify it this way: $(document).ready(function () { $("#enter").on("click", function () { $("input:required").each(function(){ var _$this = $(this); _$this.val(_$this.val() == "" ?…
-
0
votes1
answer58
viewsA: Run code javascript: How to design an environment that runs the user-provided Javascript code?
You can use the command eval('expressão') executing the expression passed as string (text). https://www.w3schools.com/jsref/jsref_eval.asp However, the site you indicated uses the command var doc =…
-
1
votes1
answer1414
viewsA: SQL Server - Line Break
You can use this function according to your delimiter ('**',',',..) CREATE FUNCTION [dbo].[SDF_SplitString] ( @sString nvarchar(2048), @cDelimiter nchar(1) ) RETURNS @tParts TABLE ( part…
-
1
votes1
answer68
viewsA: What happens if I forget a bugger
For the customer, during use will be transparent unless he accesses the Browser Development Tool while loading the screen. In this case, execution shall be paused for each debugger; there is but…
-
0
votes1
answer64
viewsA: Active backup or Restore
By default, in SQL Server, every database has a file with extension . ldf that stores transaction logs. Depending on the settings it can reach its limit size and start presenting the message you…
sql-serveranswered Onaiggac 1,127 -
1
votes2
answers95
viewsA: Disable hidden DIV
The problem in your script is that part of it runs before the DOM loads and so the effect you would like to give to the button does not occur. To fix just put it within $(Document).…
-
0
votes1
answer71
viewsA: How to Relate a Table to Another Table where the field to relate is an XML
The best way would be to normalize these data in an N:N generated database and change the application code to handle this new structure. If that’s not possible, we can do the following: TABLE MOVES…
-
0
votes1
answer95
viewsA: Return of a Stored Procedure
You can use the Try-catch inside the sp: BEGIN TRY SELECT 1/0; END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber ,ERROR_SEVERITY() AS ErrorSeverity ,ERROR_STATE() AS ErrorState…
-
1
votes1
answer36
viewsA: Show message if IN record does not exist
Try something like that: DECLARE @TAB TABLE ( cpf NVARCHAR(255) ) INSERT INTO @TAB SELECT '11111111111' UNION ALL SELECT '22222222222' UNION ALL SELECT '33333333333' UNION ALL SELECT '44444444444'…
-
0
votes1
answer510
viewsQ: Object alignment with Bootstrap
I can not understand why the label Customers gets bigger than the label Order and the 2 were defined with the same size. <div id="accordion-opcoes"> <div class="panel box"> <div…
-
1
votes1
answer270
viewsA: Take animation from the button and leave only the ZIP code field visible
Try something like that $(function() { $(".form-button").click(function(t) { if (!$(this).hasClass("active")) { var i = $(this).hasClass("full-width"), s = $(this).outerWidth(); i && (s =…
-
2
votes1
answer512
viewsQ: Notifications with Signalr
I want to create a notification system in my web app (MVC) using Signalr 2. When someone in the app does a certain action some users (not all and not always the same) should be notified. Something…
-
-1
votes1
answer236
viewsQ: Redirect www to non-www
I have an SSL certificate that holds www.dominio.com.br dominio.com.br Sub1.dominio.com.br sub2.dominio.com.br sub3.dominio.com.br However there are links (in which I have no control) that access…
-
1
votes5
answers1818
viewsA: Group records per day
I ended up opting for the following solution Dice DECLARE @INI SMALLDATETIME = '20170101' DECLARE @FIM SMALLDATETIME = '20170131' DECLARE @TAB TABLE( ID INT ,INICIO SMALLDATETIME ,FIM SMALLDATETIME…
-
2
votes5
answers1818
viewsQ: Group records per day
I have the following table ID | Início | Fim | Horas 333 | 01/01/2017 | 03/01/2017 | 5 333 | 02/01/2017 | 05/01/2017 | 1 333 | 05/01/2017 | 07/01/2017 | 3 333 | 01/01/2017 | 07/01/2017 | 6 I need a…
-
0
votes2
answers236
viewsQ: Avoiding conflicts between variables in Javascript
All modal windows of my system open via ajax and these have their own JS codes with variables and functions. In order to avoid problems with the variables and functions of the screens that call…
-
0
votes1
answer139
viewsA: Check Input Size and display label according to expression
How about something like this example? You can return false in the function and display what you want according to some parameter of the date-type of the text field. Try to follow this article that…
-
1
votes1
answer53
viewsA: Is it possible to redirect a page and send a value from a field at the same time in jQuery?
Just add the value to the redirect url: $(document).ready(function(){ $("#select-native-fc").change(function(){ var val = $("#select-native-fc").val(); if($(".assy") && val == "1"){…
-
1
votes1
answer312
viewsA: Doubt when returning string json to Fullcalendar event
As already solved the problem maybe you can decrease the code of: eventClick: function (event, jsEvent, view) { $.ajax({ type: "POST", dataType: "json", url: '<?php echo base_url(); ?>' +…
-
2
votes1
answer2709
viewsA: Form inside an html form
Just to get an answer. Follow the HTML code: <form> <input type="text" class="input-form" name="input_pai_0" value="FormPai"> <form> <input type="text" class="input-form"…
-
0
votes1
answer102
viewsA: Using Promises and Deffered in everyday life
Hello. If the calls are very similar you can do something like this: var url = '/echo/json/'; var acao = 'CarregaDadosCliente'; var dados = {acao: acao,codigo: null}; function funcao1(json,nom_cod){…
-
1
votes1
answer121
viewsA: How to avoid the ajaxStop() method function in a single ajax call?
You can create a plugin in jquery more or less like this: $.fn.meuAJAX = function(){ var url = arguments[0]; var dados = arguments[1]; var callback = arguments[2]; $.post(url,dados,callback); }…
-
1
votes2
answers732
viewsA: Retrieve via Jquery custom "date" attribute value
Try placing the parameters on the button itself <button data-params='{"IP_Clube":"@item.ip_clube","alias_clube":"@item.alias_clube","cod_clube":"@item.cod_clube"}' class="btn btn-outline…
-
1
votes1
answer331
viewsA: Ajax Undefined index
Your javascript is doing 2 posts. Is that right? Not to mention that in the second he is not sending anything to buscas.php (where the error must occur). If the idea is to receive the result of…
-
0
votes1
answer17
viewsA: how to create a slidershow for content
Tecmundo uses this plugin: carouFredSel
-
2
votes0
answers113
viewsQ: Using Paypal REST with Classic ASP
I am trying to make a simple call to the Paypal API with the following code: On error resume next Set objHTTP = CreateObject("Microsoft.XMLHTTP") objHTTP.open "POST",…
-
4
votes2
answers81
viewsQ: Simple SQL query
I have a proc that gets a product ID. If it gets NULL, then it should list all products. If it gets the specific ID, it should list only that product. There is some way to do this without having to…
-
4
votes1
answer835
viewsQ: Internationalize web app with jQuery i18n plugin
I’m trying to use this jQuery plugin to internationalize my web app. Specifically, I want to use the data API in the fields that should be translated but the alert returns "one" and not "one" and…
-
3
votes1
answer468
viewsQ: Signalr - Messages for multiple hubs
I am using Signalr in a C# web application with VS2015. This application has 2 pages A and B. Who accesses page A connects to the "paginaA" hub and who accesses page B in the "paginaB" hub. This way…
-
1
votes4
answers490
viewsA: Start connection to Signalr
According to the link Note: Normally you Register Event handlers before Calling the start method to Establish the Connection. If you want to Register some Event handlers after establishing the…
-
1
votes4
answers490
viewsQ: Start connection to Signalr
I am creating a simple application for C# Signalr studies on VS2015. How do I start the connection without having to define a method in the client? I’m doing it this way: $.connection.hub.url =…
-
2
votes1
answer81
viewsQ: Updating hierarchical data using hierarchyId
Hello. I have the following table in SQL Server 2008 The goal is to update the Value field on a child and accumulate in the parent. For example: If in the id record 12 I put the value 31 in the…
-
2
votes3
answers2032
viewsQ: Select from the last records sorted by 1 field
I have the following table structure The goal is to get the last 3 oldest records (oldest date) ordered by Name. Today I’m using subselect: Select * from (Select top 3 from TB order by Data desc) A…
-
2
votes0
answers35
viewsQ: ASP Classic in Xmlhttprquest for the same site
Hello. I’m trying to do a post of http://java/app/form.Asp for http://java/app/notification.Asp but is giving timeout with the following code: caminho = "http://java/app/notificacao.asp" Set objHTTP…
-
1
votes4
answers2941
viewsA: Split String using comma as parameter
You can use the method Split with regular expression String sttr = parent.getItemAtPosition(position).toString(); for (String retval: sttr.split(",")){ System.out.println(retval); } The Split method…
-
5
votes2
answers926
viewsQ: Saving Base64 Image with ADODB.Stream
After converting an image to Base64 using Html5 and canvas, send the string to ASP Classic and there I must save this image in a certain directory. I’m using the following code: base64String =…
-
2
votes0
answers161
viewsQ: MVC5 separate . Net Identity projects
I would like to create a solution where I have 3 projects obeying the following structure: The index of my site will be responsible for the registration of the user so that he has access to other…
-
1
votes1
answer304
viewsQ: Table for storing expenses and revenues. Cyclical information
I’m creating a C# system for storing individual expenses and revenues. I have doubts about the storage of this type of information, which has frequencies and repetitions. For example: I have a…
-
1
votes1
answer437
viewsQ: Logical deletion of SQL Server records
We have the culture of making only logical exclusions in the application, keeping 2 fields where 1 is the date of exclusion and another char that gets’S' or 'N'. When we perform searches for deleted…
-
3
votes1
answer187
viewsA: Cubes of some customers in Analysis Services
I was able to solve my demand using SSIS (Integration Services) with Visual Studio. I create the Azure SQL (Basic) bases with the tables I want to publish to my client In SSIS I created a package…
-
3
votes1
answer187
viewsQ: Cubes of some customers in Analysis Services
I intend to allow my customers to access their data to generate customized reports and use the power of Powerpivot Excel. Today all customers (business) are in the same database and for the little I…
-
3
votes1
answer589
viewsQ: Application Layers and Web API 2
I have a question in the planning and structuring of my application and hope to hear the most experienced. Today, in the plan, I have access to data (DAL) and the MVC 5 Web application in different…
-
2
votes1
answer322
viewsQ: Access to DAL data with ASP.Net MVC Identity and Owin
Today my solution has a MVC 5 Web application project and a DAL Library (Data Access Layer) with EF Databasefirst. I want to create a layer with MVC Identity + Owin, however I would like the data…
-
2
votes1
answer187
viewsA: Global Filter on MVC 5 not working
After restarting the pc the code worked as expected. I believe it has something to do with the reboot of IIS Express as there have been changes in Global.asax after the first run.
-
2
votes1
answer187
viewsQ: Global Filter on MVC 5 not working
Hello. I am following the tutorial below with the intention of better understanding the authentication process of . net Identity with OWIN.…
-
2
votes1
answer215
viewsQ: Remote connection of SQL Server 2008 Express
I have 2 servers (a physical and a local VM) in which one of them has SQL Server 2008 R2 Enterprise Edition (physical) installed and the other (local VM) I have SQL Server 2008 Express Edition.…
-
1
votes1
answer205
viewsA: Asynchronous server responses for AJAX calls
I always use Jquery in my AJAX requests: $(document).ready(function(){ /*Primeira requisição*/ $.ajax({...}); /*Segunda requisição*/ $.ajax({...}); }) In this case, none of the requests waits for…
-
4
votes1
answer311
viewsQ: Bootstrap organization and maintenance
I am starting with the use of Bootstrap with MVC 4 and during the planning I noticed that the main screen of the system will have many Divs. Many of them can be repeated (exactly the same) on other…