Posts by Gabriel Silva • 706 points
48 posts
-
1
votes1
answer30
viewsQ: Migrate data from one DB1 table to another DB2 database table
I have 2 databases on Sql Server DB_1 and DB_2 being DB_2 a clone of DB_1 I am trying to migrate all data from DB_2 Ignition table (older data) to DB_1 Ignition table (newer data) so that the data…
sql-serverasked Gabriel Silva 706 -
1
votes0
answers135
viewsQ: Date value coming 01/01/0001.00:00:00
I’m having a problem with my API when I try to rescue a date from a column in my table in Sqlserver I’m doing it this way using (SqlCommand command = new SqlCommand()) { command.Connection =…
-
1
votes3
answers57
viewsA: How to make the text inside the button not be tilted?
Just add in the style of the .example{} display:block; and Transform: skew(40deg); <!doctype html> <html lang="pt-br"> <head> <meta charset="utf-8"> <meta name="viewport"…
-
0
votes1
answer28
viewsQ: Condition in SQL Server query
I’m having a doubt that seems silly but I can’t seem to solve I have a table with the following fields IdInstallation(bigint)|NameInstallation(varchar(255))|IdGroup(FK(bigint)) I would like to make…
sql-serverasked Gabriel Silva 706 -
0
votes1
answer58
viewsQ: API Rest only returns the last value
I am using ASP.Net to create a REST API I’m trying to create a method that returns a list of groups structured this way: { "IdGroup": "1", "NameGroup": "Group1", "Installations": [ {…
-
0
votes2
answers201
viewsA: React Switch Route Default
Try to do this: <Switch> <Route path="/sua rota" exact component={seu componente aqui} /> </Switch>
-
1
votes1
answer149
viewsQ: SQL Server Data Types
I have a question about the type of data real in SQL Server. I’m trying to store the value of 1.5 in a real type but it represents 1.5 as 1.5, wanted to know if when I was passing this value to a…
-
-1
votes1
answer4512
viewsQ: Get value from an input type='text' React
I am trying to redeem the value of an input type text. I’m doing it this way: class CreationGroups extends React.Component { constructor(props) { super(props); this.state = { value: '', };…
-
1
votes1
answer151
viewsQ: Dynamic matrix in C#
What would be the best way to create a dynamic square matrix ? An array that increases row and column as elements appear to be inserted into the matrix I found some comments on the internet saying…
-
6
votes1
answer247
viewsQ: Size of a list list using list.Capacity
Creating a list of lists: List<List<int>> myList = new List<List<int>>(); I add elements in myList with 1 element: myList.Add(1); When I do debug.writeLine(myList.capacity)…
-
2
votes1
answer109
viewsQ: How to control the size of a font using @media
I’m trying to change the size of a font when decreasing or increasing my screen size using @media I know this is how it works: #Fonte{font-size:10vw;} @media (max-height:880px){ #Fonte{ font-size:…
-
0
votes1
answer221
viewsQ: How to call a c# function when an SQL Server table changes
I have the following code on C# Asp.NET 4.5 to count the number of records in my table [HttpGet] [Route("consult")] public HttpResponseMessage GetAll() { try { MatrizGeneral matriz = null; //int…
-
1
votes1
answer160
viewsQ: How to control the size of cells in an HTML table?
I’m trying to control the size of a cell in my HTML table using CSS properties height and width, but it’s not working. I’m doing it this way: #CelL7C1, #CelL3C1, #CelL3C3, #CelL7C3{ height: 5px;…
-
1
votes2
answers32
viewsA: Graphic with SVG
Simply exchange the following part of the code: var svg = d3.select("#graphicsBubble").append("svg:svg") .attr("width", width) .attr("height", height) .append("svg:g") .attr("transform",…
-
0
votes2
answers32
viewsQ: Graphic with SVG
I have a chart made with SVG generated by a Java code that I found on D3.Js that I am trying to use it in a college job, but I have a problem to put it inside a div. I am setting the chart size…
-
0
votes2
answers406
viewsQ: Select 2 latest records from Sql Server table
I have a table with the following fields. IMEI | TimeStamp | Value 123 | 1570011000| 1 123 | 1570012800| 0 123 | 1570015200| 1 123 | 1570017000| 0 I would like to take the last 2 records and make…
-
0
votes1
answer41
viewsQ: Javascript Element not defined
I’m having trouble running the following Javascript code //dynamic table function chamadaTable(){ const detailsbody = document.querySelector("#maintenance > tbody"); console.log(detailsbody);…
javascriptasked Gabriel Silva 706 -
1
votes1
answer327
viewsQ: Using Awesome font in an SVG
I’m trying to put an icon font awesome within my SVG. I am based on this tutorial: http://tutorials.jenkov.com/svg/svg-icons.html I am doing as follows, but the icon is appearing outside of Circle.…
-
0
votes1
answer478
viewsQ: Text in SVG HTML
I have the following HTML code: <!DOCTYPE html> <html> <body> <svg height="100" width="100"> <circle cx="50" cy="50" r="40" stroke="black" stroke-width="3" fill="red"…
-
0
votes1
answer45
viewsQ: HTML element readjusts with screen resize
I have the following code. var logo = document.getElementById("svgLogo"); var area1 = document.getElementById("area1"); var area2 = document.getElementById("area2"); var area3 =…
-
2
votes3
answers104
viewsA: Change project c# . Net 4.6 to . Net4.5
Open the project properties and change the "Target Framework" option to the version of . NET Framework desired... Note that if you used any functionality of . NET Framework 4.6, by changing the…
-
2
votes3
answers104
viewsQ: Change project c# . Net 4.6 to . Net4.5
Would have some way to change the summer of . Net used in my project to an earlier version ? In my project is with . NET 4.6 and would like to return to the version . NET 4.5 without having to redo…
-
0
votes0
answers381
viewsQ: Problem with Cors C# Asp. Net
I’m having enough trouble solving a CORS error. I am following the following steps: I added the CORS Nuget package to my project. I’m adding the code config.EnableCors(); in my class startUp. I…
-
-2
votes2
answers59
viewsQ: placeholder with the same label name
How do I get the placeholder to pick the same name that’s on my label ? I’m doing it this way: <label for="sing_pass" class="label_pass"><span class="lang" key ="Text33">Code…
-
1
votes1
answer1726
viewsQ: How to check if a Date field is NULL C# ASP.Net
I have a webservice where I make a query in a table of my bank where I have a column of type Datetime and I am wanting to make a check if this field Datetime is filled or if you are NULL I’m doing…
-
0
votes0
answers23
viewsQ: Doubt with xhr.Answer
I have the following Javascript code: function load(){ var validationEmail = Email.value; var validaationCode = Code.value; var json = JSON.stringify({"userName": validationEmail, "codeCustomer":…
-
0
votes1
answer246
viewsQ: CSS Font Awesome does not load
I’m having difficulty using fot awesome I found this example on the internet: http://astronautweb.co/snippet/font-awesome/ but I’m not managing to solve this problem mine HTML and CSS is as follows…
-
2
votes1
answer70
viewsQ: What kind of data to accept any size?
What kind of data can I use to store text "dynamically" in SQL Server? I know that CHAR and VARCHAR are character data types, the difference is that CHAR is a type of data fixed length and VARCHAR…
-
0
votes1
answer59
viewsQ: HTML template in Java
I’m having a problem assigning a role to a input I have 2 HTML templates in Java var forgotPassword = ' <form action="#">'+ '<fieldset>'+ '<legend class="title"><span…
-
1
votes1
answer606
viewsQ: Translation of html page
I am creating a Single page Application and in this project I am doing the translation of texts. Javascript var arrLang = {…
-
0
votes1
answer269
viewsQ: Problem with Z-index
I’m having trouble using the z-index. The elements #questionSingUp and #actionSingUp CSS are not overlapping with div .loginActionWrap. I tried to change via Javascript but also could not. var…
-
0
votes1
answer60
viewsQ: animation with CSS
I have a problem using animation in css when I click the login and Sing Up buttons for the first time works normally, but when I click on any of these buttons the animation does not work, I tried…
-
0
votes1
answer113
viewsQ: Sql Server Procedure
I have the following description PROCEDURE [dbo].[spAVL_Ignition] @DeviceIMEI VARCHAR(50), @TimeStamp SMALLDATETIME, @Value INT, @Tag VARCHAR(50) AS BEGIN IF NOT EXISTS (SELECT TOP (1) TimeStamp…
-
-1
votes2
answers284
viewsQ: Password encryption in Javascript
I have this snippet of code that makes the sending of user and password to my web service done in Asp C#. function validation(){ var json =({ "emailUser": email, "passwordUser": passWord });…
-
3
votes1
answer93
viewsQ: Unixtimestamp for Date Javascript
I am receiving a JSON in which the date is being returned in this way: /Date(1563568740000+0200)/ I believe it is Unixtimestamp, but I can not convert it to format Date javascript. I’ve tried to do…
-
6
votes3
answers4742
viewsQ: Convert string to dd/mm/yyyy hh:mm format
How can I convert a date that is string to a date type? I tried to do it this way but it didn’t work: var string = "19/07/2019 14:18" var date = new Date(string); When I give a console.log(date);…
-
0
votes1
answer112
viewsQ: Minute difference between two dates
I’m trying to catch the minute difference between two Javascript dates Javascript: function compare() { var currentDate = new Date().format("DD/MM/YYYY HH:mm"); var timeStamp =…
-
0
votes1
answer89
viewsQ: Scrolltop position()
I have a Javascript function that refreshes my page every 15 minutes and I’m trying to get the last position of the scroll bar before the refresh with the jQuery command. $(window).scrollTop();…
-
0
votes2
answers127
viewsA: Search last access record with MYSQL
From what I understand, you want to do a consultation of the last customers who had access You could try doing it this way select Cliente, Data_Registro from *tabela* where (select max(…
-
4
votes3
answers1332
viewsQ: Format DATETIME SQL Server
I wonder if you have any way to change the Datetime format in SQL Server EX: 2019-07-09 11:42:00 for 09-07-2019 11:42:00
-
0
votes1
answer58
viewsQ: Qt Error: ASSERT Failure in Qlist<T>
I am new using Qt Creator and am currently working on a project for college and am getting the following error ASSERT Failure in Qlist::Operator[]: "index out of range", file .. /.. /. /..…
-
0
votes1
answer175
viewsQ: Is there a command in sql server that returns the number of records in a table?
I have a table called client with several customers already registered and I want to filter all customers who are the same age and get an entire number of these records, in case the amount of…
-
4
votes1
answer654
viewsQ: Is it possible to list 2 tables from 2 different banks?
I’m looking to relate 2 different database tables. I’m using SQL Server SSMS 17.9.1. TBL1 in DB1 TBL2 in DB2 Scenarios: Both banks are on the same server; Database 1 is on my server and database 2…
-
0
votes1
answer85
viewsQ: creation of a composite KP
I have two tables: tbl1 and tbl2. In the tbl1 I own a pk and in the tbl2 I own a FK which refers to PK of tbl1 and a pk. With this, I can make a pk composed for the tbl2 with these 2 fields ? EX:…
-
1
votes1
answer168
viewsQ: String Split in C++
Folks I’m looking for a split on the following String in C++ [ { "Nome":"Gabriel", "idade": 23 } ] I’m doing it this way... I receive this json through a query get and storing in a string to power…
-
1
votes1
answer122
viewsQ: Can I get more than one FK referencing the same PK?
I wonder if it is possible to reference foreign keys (FK) from different tables to the same primary key (PK). Below is a piece of the SQL command CREATE TABLE Run( Project_Code INT FOREIGN KEY…
-
0
votes0
answers40
viewsQ: HTTP protocols
I’m new to development and I’m learning how to make a web service below this my method of consultation, insertion and removal. they are already working, however I wanted to know how to pass in the…
-
0
votes0
answers66
viewsQ: Materialized view
I’m having a problem creating a view CREATE MATERIALIZED VIEW table_name You’re making this mistake: ERROR: syntax error at or near "MATERIALIZED" LINE 1: CREATE MATERIALIZED VIEW…