Posts by Lone Tonberry • 525 points
50 posts
-
0
votes1
answer346
viewsA: Why does SQLSERVER Express not recognize accented words when creating a bank using sqlcmd?
Resolution for the first problem To change the encode of the archive *.csv was enough: Open it as a notepad Select the option Salvar como Change the encoding to UTF-8(In a combo-box that is next to…
sql-server-expressanswered Lone Tonberry 525 -
0
votes1
answer346
viewsQ: Why does SQLSERVER Express not recognize accented words when creating a bank using sqlcmd?
Problem In some databases(SQLSERVER) I am often needing to popular the tables with some data, which usually comes from a file .txt or .xlsx, I need to do this as quickly as possible. The first thing…
sql-server-expressasked Lone Tonberry 525 -
0
votes2
answers309
viewsQ: How can I only enter a certain amount of records into sql server?
I have a table called Hoteis which is related to another helper table Hoteis_Fotos, as its name suggests this table will save the photos of a particular hotel. As you may have understood, each hotel…
-
1
votes0
answers17
viewsQ: How does the representing flow of a extending use case include another use case in the specification document?
My use case: Example of how I’m doing the flow specification: [...] X-flow. Flux y. Z-stream. Here would need to enter the use case part "Provide Identification" \ "Cadastrar Times" My doubt: When…
-
1
votes1
answer89
viewsQ: Am I required to use a repeat loop if my LINQ query returns only one object?
My class: public class Carros { public int ID { get; private set; } public string Atributo2 { get; private set; } public int Atributo3 { get; private set; }}} Suppose the ID attribute could not…
-
2
votes1
answer234
viewsQ: How to fill a Datagridview manually, after having used "Tolist()" from the link as Datasource?
I am filling the Datasource of my Datagridview so: var enderecos = from endereco in EnderecoBusiness.Enderecos select new { Logradouro = endereco.Logradouro, Numero = endereco.Numero, Cidade =…
-
0
votes2
answers98
viewsQ: Layout ratio difference between Form1.Cs[Design] and . exe
Recently I’m programming a Windowsforms application using c#, and there’s kind of a bug going on with the IDE that leaves the layout ratio different, like in the image below: The form on the left…
-
0
votes1
answer40
viewsQ: Doubt in self-relational table modeling
I need to make a system where the business rule is this: One card must duel against another card The same duel between two equal cards can happen more than once Each letter should contain only two…
-
3
votes1
answer96
viewsQ: Question with SELECT instruction from a self-relative table
Hello dev’s I own the following table courses(self relational): desc cursos; +-----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra |…
-
1
votes2
answers41
viewsQ: Error when trying to add class dynamically with classList.add() and classname
If I create an element and already add a class to it like this: let paragrafo = document.createElement('p').classList.add('text') Then try to add a child element to it like this: text =…
javascriptasked Lone Tonberry 525 -
-1
votes1
answer37
viewsQ: Do all entities of the conceptual model need to be related?
I was developing a conceptual model for a database according to the requirements of the activity, but I came to doubt the title because my model ended up being according to the image:…
modelingasked Lone Tonberry 525 -
-1
votes1
answer240
viewsQ: Request returning Cannot PUT with express
Greetings dev’s my route file is like this: const express = require('express') const routes = express.Router() const TodoController = require('./controllers/TodoController') ...…
-
0
votes0
answers24
viewsQ: Enum and default does not work?
Greetings dev’s, I have the following schema in my app: const customerModel = new Schema({ ... roles: [{ type: String, required: true, enum: ['user', 'admin'], default: 'user' }] }) However, when I…
-
0
votes0
answers70
viewsQ: Why isn’t Mongodb saving the data with default values declared in his schema?
Greetings dev’s, I declared the schema as follows: const mongoose = require('mongoose') const TweetSchema = new mongoose.Schema({ author: String, content: String, likes: { type: Number, default: 0…
-
4
votes3
answers89
viewsQ: OFFSET next to COUNT(*) returns nothing?
When I make a query this way are returned me the data correctly(At the moment 2 lines): SELECT * FROM noticias ORDER BY data_noticia DESC LIMIT 30 OFFSET 2 But I need to know the number of lines…
-
0
votes1
answer68
viewsQ: Registration is not being sent to the database
When I use 'Insert into noticias set ? ', to register in the bank, it is simply not registered Model: module.exports = function() { ... this.salvarNoticia = function(noticia, connection, callback) {…
-
0
votes2
answers1197
viewsQ: Angular 404 (Not Found)
I finished my app and ran the command ng build --prod to generate the production version, then http-server inside the directory created by the previous command and the server worked normally, but…
angularasked Lone Tonberry 525 -
1
votes0
answers320
viewsQ: Command "git status" does not show changed files inside folders
The structure of my briefcase is this: If I change (without editing the code) any file inside any of these folders(Calculator, Color, etc), when I run git status it does not list any modified file,…
gitasked Lone Tonberry 525 -
0
votes1
answer346
viewsQ: How do you return all the rows of the SQL query with PHP?
The result I have of the SQL query is this: I want to return these two lines of the 'publishing' column. But using this code: <?php //Código para buscar os tweets do usuário $sqlTweets = "SELECT…
phpasked Lone Tonberry 525 -
0
votes3
answers364
viewsQ: Manipulating values through Hidden input
I made a calculator as follows: <?php if (isset($_POST['calcularbtn'])) { $valor1 = $_POST['valor1']; $valor2 = $_POST['valor2']; $tipo = $_POST['tipo']; if ($tipo == 'Somar') { $operador = '+';…
phpasked Lone Tonberry 525 -
0
votes2
answers664
viewsQ: How to add value to an array without losing the previous value?
Through a form and a single input I need to receive multiple numbers and store these numbers in an array. For example, I type any number in the input and click on the form’s Submit button, with PHP…
phpasked Lone Tonberry 525 -
2
votes1
answer26
viewsQ: Variable returning null value
I’m creating a precedent for it to store the food name in the Procedure food variable, follow the code: DELIMITER $$ CREATE PROCEDURE armazena_nome(id INT, OUT alimento VARCHAR(20)) BEGIN SELECT…
-
1
votes1
answer632
viewsQ: How to make a ranking with SQL?
Well, I have a "voting uniform" table that receives in the columns "voto_uniforme1", "voto_uniforme2" and "voto_uniforme3" a value of type "BOOLEAN", where 1 means that the person voted in this…
mysqlasked Lone Tonberry 525 -
4
votes1
answer4332
viewsQ: How do JOIN in 4 tables or more?
I need to make a select on four tables but I’m having a headache with it, follows the image of how they are related: It would be something like : SELECT integrantes.id_integrante,…
-
1
votes1
answer4727
viewsA: How do I use the "LOAD DATA INFILE" command?
I managed using the command this way: LOAD DATA LOCAL INFILE 'C:Users/Wallace/Desktop/activity/data.txt' INTO TABLE people;
-
0
votes1
answer4727
viewsQ: How do I use the "LOAD DATA INFILE" command?
It is the following guys, I have a database and in it a table called "people" which contains "id_people" as attribute and I want to test an import of information using this command of the title, I…
-
0
votes1
answer546
viewsQ: Can a foreign key be part of more than one table?
I wonder if I can put a foreign key in more than one table, for example, where the entity "competitors" in the image is a table and the attribute "id_competitor" is a primary key, and the other…
-
-2
votes1
answer757
viewsQ: ERROR Error: Uncaught (in Promise): Typeerror: Cannot read Property 'src' of null
I want to take the "src" of an html image but keeps showing this error. I’m trying to do it this way import { NavController, NavParams } from 'ionic-angular'; import { Component } from…
-
1
votes2
answers121
viewsQ: setTimeout doing lose value of variable?
I’ll summarize the code because mine’s too big, come on. I have a global variable of type Boolean that gets false, when entering an if it has to receive instead of false the true, but when entering…
-
1
votes0
answers1464
viewsQ: Memory game with Javascript
I’m developing this game for a mobile app, along with Ionic, angular2, CLI, among others. However logic is totally with javascript but as every game has its rules I stopped at the part where the…
-
1
votes3
answers913
viewsQ: Conditions with typescript
I’m trying to make a if in typescript but it simply gets ignored and never enters the condition. My typescript code: import { Component } from '@angular/core'; import { NavController, NavParams }…
-
0
votes1
answer424
viewsQ: Uncaught Referenceerror: vira1 is not defined
I’m creating a function but when it’s called it says it hasn’t been defined yet, what would be the reason ? import { Component } from '@angular/core'; import { NavController, NavParams } from…
-
1
votes1
answer167
viewsQ: `Uncaught Referenceerror: floor is not defined` when trying to use floor and Random to choose an item from an array randomly
I have the following array: var cartasViradas=[ 'assets/img/1.png', 'assets/img/2.png', 'assets/img/3.png', 'assets/img/4.png', 'assets/img/5.png', 'assets/img/6.png', 'assets/img/7.png',…
-
1
votes1
answer1488
viewsQ: Image cannot be loaded in the application
The image appears normal when running on "Ionic serves" but when I run on a device ionic run android --device it cannot be loaded, strange that I put an alt in the img tag and can only be displayed…
-
-1
votes1
answer30
viewsQ: Simple doubt about json
I would like to be sure what is considered a json code. For example the code below would be considered a json ? $(".hide").css("display","block"); If yes why? If not which code formats are…
-
0
votes1
answer697
viewsQ: How do div with arrow?
I am grateful if someone can show how to do these div’s that stay on the globe site with a small "arrow" pointing to the item in which the user is browsing, using only HTML and CSS Follow the…
-
0
votes2
answers243
viewsQ: How to make one element continue with effect when passing the mouse on another?
I have the following code: .classes { margin-top: 80px; height: auto; background-color: red; } .classes ul { list-style: none; float: left; position: absolute; } .classes ul li { position: relative;…
-
0
votes1
answer441
viewsQ: Checked does not work
The logic is to make the menu appear when it is as checkbox selected and is on a screen of maximum width 800px but for some reason does not work... .classes { margin-top: 80px; width: 100%; height:…
-
1
votes1
answer224
viewsQ: Code being performed only when double-clicking?
Well, I had to make sure that when I click on a button I would show the div’s and if I click on another button and some div is showing up (display:block;) I would acquire a display: None; that’s…
-
2
votes1
answer106
viewsQ: Alert in only certain browser
It is only possible with Javascript and HTML to make one appear alert only and only when the user is browsing through Internet Explorer? For example when browsing Google Chrome alert does not…
-
2
votes2
answers195
viewsQ: How to make menu with different drawing?
Good stack galley I need to do this menu that is in wireframe, but I do not know which commands I use to leave the line diagonal. Follow the image below: NOTE: I need to do only with HTML and CSS,…
-
1
votes1
answer91
viewsQ: How do I keep the site elements in the same place all the time?
I have the following HTML code: <div id="geral"> <p class="texto_grande_titulo">...</p> ... </div> In the CSS: div#geral{ background-image:url(../imagens/borda.png);…
-
3
votes2
answers1000
viewsQ: Different layout on other computers?
I’m with a project and this project was all done from scratch on my PC, however when I took my project to another PC that had a monitor resolution totally different from mine, the images and certain…
-
0
votes2
answers137
viewsQ: How to incorporate a div to the form article or the other way around?
I’m developing a Fomulário for a project and I needed to add images only that these images represent the place of the client’s chairs and when the user clicks on any of these chairs the place is…
-
1
votes4
answers3595
viewsQ: How to put picture in input type reset?
It is possible to input an image with the type="image" But he stays as Ubmit and I want to leave the input type="reset" With image also but without staying as Submit and yes to reset the information…
-
-2
votes1
answer933
viewsQ: I can’t edit css files
Before I did not use PHP I only used HTML and CSS to develop the project but the need for PHP arose, so I had to use XAMPP as well, but it turns out I modified the HTML files for PHP and now I can’t…
-
0
votes1
answer375
viewsQ: Form does not send data
I am trying to make the data typed by the user appear on another page when he clicks the button only the page is updated but does not contain the information typed. HTML file <form…
-
0
votes1
answer149
viewsQ: Sending form only with HTML and/or JS
Guys I need to make sure that when the user clicks on the "Send" button automatically it is redirected to another page with all the data entered by the user as: e-mail, password, name, etc(using…
-
6
votes2
answers10617
viewsQ: How to change image when clicking?
I have a work course and I had the following idea: There are several images that will represent the chairs of a cinema (all are the same images, the same are in my HTML file), and I want to make the…
-
4
votes1
answer186
viewsQ: Different concatenation ?
Guys I’m starting programming has little time and I have to register only I want the information typed by the user as the name, email and age appear through an "Alert" after he click on the button…