Posts by Bruno • 51 points
9 posts
-
1
votes1
answer308
viewsQ: Charset problem between Asp.Net MVC with Entity Framework and SQL Server
I’m having a problem that all the values that come from the bank SQL Server, are having accentuation problem. When written words are directly on HTML, does not give this problem. What is strange is…
-
0
votes1
answer658
viewsQ: Local Application to Save C#Data
I’m in need of working with Windows Forms, more specifically in a system that works on intranet, without the possibility of using MYSQL, SQL Server among others. I need to create a second project…
-
1
votes1
answer5453
viewsQ: Check if date is between a period
On my table, I have two columns, DT_INICIO and DT_FIM, would be an Absence table. Let’s assume an employee is absent from DT_INICIO From (25/03/2016) until DT_FIM (27/03/2016), I need to make an…
-
1
votes1
answer59
viewsQ: Connectionstring according to scenario
Hello, good morning! I have a project where there are two scenarios, which is approval and production. In this same project I created two connectionstrings, setting one for each scenario. In the…
-
1
votes1
answer702
viewsA: Compare current url to href
var url = window.location.pathname; $('a').each(function(){ var href = $(this).attr('href'); if (url === href){ console.log('works'); } }); var url = window.location.href; -- takes the whole url. So…
-
0
votes1
answer24
viewsA: How to reuse my . htaccess
In the last row: RewriteRule ^(.*)$ $1.php Alters to RewriteRule ^(.*)/([a-z0-9-]+)/([0-9]+)/?$ $1.php?param=$2&id=$3 Just change ? param=$2 and id=$3 with your get variables.…
-
0
votes3
answers50
viewsA: comma between the arrays
You can turn the variables into an array and use the function array_filter: $diasPromocoes = array($seg,$ter,$qua,$qui); $arrayLimpa = array_filter($diasPromocoes); echo arrayLimpa;…
-
0
votes2
answers2555
viewsA: How to Type in a Select?
This is not a select, it can be treated according to the language you are using. One way to do this is with jQuery, with the keypress function: $("#filtro").keypress(function () { // ação a ser…
-
0
votes3
answers1432
viewsA: Perform UPDATE with values from another table, in columns with the same name
You cannot update multiple tables in the same query, however, you can use a transaction to make sure that the two querys of UPDATE are treated: BEGIN TRANSACTION; UPDATE Table1 SET Table1.LastName =…
sql-serveranswered Bruno 51