Posts by Leticia Rosa • 1,184 points
49 posts
-
0
votes0
answers11
viewsQ: ESP8266 400 BAD REQUEST when connecting to an API using dynamic parameters
I am trying to make an RFID reader using ESP8266 to check via API whether the card/tag has access authorization or not. When I try to dynamically place the card data in my URL it displays a 400 BAD…
arduinoasked Leticia Rosa 1,184 -
0
votes1
answer44
viewsA: Calculator in C does not return decimal numbers, when dividing 7/2 it returns me 3. And how do I get the code back to the choice menu?
You have two situations here: To return to the menu at the end of the operation you can use the goto. With it you will tell your program that when it reaches a certain point, it will return to a…
canswered Leticia Rosa 1,184 -
0
votes1
answer22
viewsA: GITHUB - Problems to associate local repository with remote repository
In your local repository the default branch is master. But in Github the default branch is now the main branch. To fix the error you are having you need to rename your local branch from master to…
-
-3
votes1
answer36
viewsA: Undefined function mysqli_connect ()
To work with PHP 7.0+ try to change the connection to the following format: <?php $servidor = "localhost"; $usuario= "user"; $senha = "pass"; // Criar conexão $conn = new mysqli($servidor,…
-
3
votes1
answer58
viewsA: What is the $$ function in posntegresql functions?
In Postgresql, dollar signs are used to replace single quotes in user-defined functions and stored procedures. In some cases it is difficult to understand when the string has too many single quotes…
-
1
votes1
answer158
viewsA: Indefinite array key
The problem you are encountering is because you told your code to count the amount of items in the array and do it this amount of times. It has 25 values in the array so it tries to do from 0 to 25…
-
2
votes1
answer26
viewsA: display an image through the URL
Hello, Matheus! Your code is correct and this is possible. What is wrong is the code of the image you used. If you open this link in the browser and right click on the image will appear: Copy Image…
-
3
votes2
answers50
viewsA: Select HTML using database data is empty
When you do the database search you set the value of the select option, but did not put what will be displayed. Your code should be something like: echo '<option…
-
1
votes1
answer29
viewsA: Error in R script syntax
Missed you close a parenthesis, you opened 3 and closed only 2. flt <- filter(grade.ac,st_contains(ac,grade.ac,sparse = (FALSE)))
-
1
votes1
answer119
viewsA: Error 1776, Level 16
Every foreign key is referenced to a primary key. You need to define it in your tables. Only the user table has it. All your other tables work because the foreign key is from the Usuarios table, but…
sql-serveranswered Leticia Rosa 1,184 -
0
votes1
answer136
viewsA: Problem selecting month with Chart.js
Remove the filter to pull only month 4 and let it pull normal. The way your code is done it’s returning only one result, but despite being the COUNT of month 4, it’s filling in the first label,…
-
5
votes1
answer2475
viewsA: Where is the data stored in Mysql 8?
All Mysql databases are stored in directories within a DATADIR directory, which is specified in the configuration. Then, a bank called "Bancoapp" would be stored in $DATADIR/Bancoapp. There are a…
-
4
votes1
answer245
viewsA: Arduino’s Serial.read() does not work as expected
When you send a serial 1 you are sending an ASCII 1. Since you are reading this in a timpo variable int Uino understands this with its hexadecimal value. If you print it there it will be reading 49.…
-
4
votes1
answer617
viewsA: Picking up specific text from a text file using PHP
You can use the file_get_contents along with the function strpos. It would be something like this: if (strpos(file_get_contents($arquivo), 'palavra_a_ser_procurada') !== false) { echo 'found'; } The…
phpanswered Leticia Rosa 1,184 -
4
votes1
answer45
viewsA: Insert line number in SQL Manager
Depending on your SSMS version the path is: Top Menu >> Tools (Tools) >> Options (Options) >> Editor Text (Text Editor) >> General (General) >> Enable the option: Line…
-
0
votes2
answers75
viewsA: Format only last characters of a column’s values in Mysql
You can make a UPDATE and use the command locate() in the WHERE. The command locate() serves for you to find a substring within a string. You could then fetch the substring ". j" and update Where…
mysqlanswered Leticia Rosa 1,184 -
0
votes1
answer92
viewsA: Trying to get the property 'num_rows'
To log in using PDO I do not use Count Rows, I use the fetchAll() and check the amount of results, thus: //SQL Statement $query = $conn->prepare("SELECT * FROM cadUsuario WHERE email=:email AND…
phpanswered Leticia Rosa 1,184 -
2
votes3
answers203
viewsA: sort array by date
You can make SELECT return you sorted as you want, rather than having to work it out in php. For this, at the end of your SELECT you need to put: ORDER BY nome_campo_data. By default sql sorts in…
-
10
votes1
answer211
viewsA: Mysql use 'as' in aliases or not?
According to the documentation of Mysql: A select expression can receive an alias using AS alias_name. Alias is used as the name of the expression column and can be used in: ORDER BY, GROUP BY ou…
-
0
votes1
answer28
viewsA: Place label Display="block" when passing over the image and removing Display="None"
You don’t need to do javascript, you can use the title attribute in the image: <img src="sublime2.png" title="Sublime Net, projeto de Tecnologia de negócios na internet.…
-
1
votes1
answer56
viewsA: doubt with date in sql tables
Trigger only works when you perform an action in the database (Insert, update, delete...). I believe that the best solution in your case would be to schedule the task. In SQL Server you can use SQL…
-
0
votes1
answer169
viewsA: How to insert data and a table with Foreign Key in PHP/MYSQL
The ideal is that the customer receives the foreign key from the address and not the other way around. You can use the mysqli_insert_id() or PDO::lastInsertId(), because even if there are several…
-
0
votes1
answer72
viewsA: Create mask to accept only links containing HTTP/HTTPS - Java JSF
If you make a <input type="url"> maybe I’ll fix it. But if you want in javascript, here’s an example: <html> <head> <script src="https://code.jquery.com/jquery-3.3.1.min.js"…
-
1
votes1
answer33
viewsA: Is it possible to put a spinner in function to another spinner just as an image?
First situation - fill in the second spinner after selecting the information in the first: For this you can use the Onitemselectedlistener(). It would be something like this:…
android-studioanswered Leticia Rosa 1,184 -
0
votes1
answer458
viewsQ: Monitoring of Printing Spool
I’m trying to make an application that monitors my printer and when the user sends a print of any program, it captures that information, pauses the print and opens a new window for the user to enter…
-
0
votes1
answer254
viewsA: Capture the radio button and save Text to the database
To get the selected radiobutton text I use the following code: RadioButton selecionado; String situacao; int idSelecionado = status.getCheckedRadioButtonId(); //pega o id do RadioButton selecionado…
androidanswered Leticia Rosa 1,184 -
1
votes1
answer440
viewsA: Confirm registration password Ionic 3
The function this.fire.auth.createUserWithEmailAndPassword admits only two arguments (email and password). You are trying to add a third party which, by its code, is also a password. You will not be…
-
0
votes3
answers900
viewsA: how to find a string for json
You can use the library JSON.Net Example of the site itself how it would be: Product product = new Product(); product.Name = "Apple"; product.Expiry = new DateTime(2008, 12, 28); product.Sizes = new…
-
1
votes1
answer457
viewsA: Connect external Mysql in app to perform authentication
You can access the database the way you want, but this is not currently recommended, as it is much more complex, impairs performance and leaves your database vulnerable. It is not because your…
androidanswered Leticia Rosa 1,184 -
3
votes1
answer1717
viewsA: Android studio does not display the devices to emulate
As for the physical device: Is your phone Debug mode on? If it’s not, it won’t show up at all. To enable debugging you first need to enable the programmer mode on mobile. For this you can follow the…
-
1
votes1
answer171
viewsA: Adjust Constraintlayout
When you are using Constraintlayout you define where your component is linked, that is, what will be the position reference for it. You can set using the Android Studio properties side box as per…
-
-1
votes2
answers1371
viewsA: How to avoid duplication of record in a table in mysql
You can set in the database that the column 'board' is of the type UNIQUE, which will not allow duplicate data or you can create on your page a SELECT that checks if the board already exists. If it…
-
3
votes1
answer110
viewsA: Can someone help me find the mistake in this create?
The error of this CREATE is that there is no + option where you are putting (as SQL Server itself is showing you). If you are trying to create both tables at the same time create 2 separate CREATE…
-
1
votes1
answer314
viewsA: Count Listview items
You can do the following: ListView listItens; listItens = findViewById(R.id.listItens); EditText etDados = findViewById(R.id.etDados); //Presumindo que o usuário irá inserir os dados em uma editText…
androidanswered Leticia Rosa 1,184 -
3
votes1
answer1089
viewsA: How to set up Android Studio to save projects to another folder?
When you create a new project you have the option to choose the place you want to save it. You can also change the location where it searches for the latest projects: C: Users . Androidstudio…
android-studioanswered Leticia Rosa 1,184 -
1
votes1
answer21
viewsA: Android appears message in the log about security configuration
That message is not a mistake. That means you haven’t set a specific security option to use in your app, so it will use the default Android settings. If you want to know more about them, you can use…
-
1
votes1
answer1085
viewsA: Insert into related tables
By your choice of TAG it has become difficult to know if you are using SQL Server or Mysql. Therefore: If it is SQL Server: You cannot use LAST_INSERT_ID, you need to take the data in another way.…
-
1
votes1
answer43
viewsA: Doubt with the %i
0x15 in hexa = 21 decimal. The specifiers %i and %d are interpreted in the same way by the functions of the fprintf() family, but are interpreted differently by the fscanf function family(). Using…
canswered Leticia Rosa 1,184 -
0
votes2
answers2246
viewsA: Doubt in class diagram
I would add the following methods: in the Client class: insert Client(), change Client(); in the Room class: book(); in the Employee class: insert Employee(), register Employee(); (although it is…
-
1
votes3
answers247
viewsA: check if only one field is equal to the one entered in the input
I’d do it different than you: I would check the database to see if that url already exists. If the query displays a line it means it has worked, so the url already exists. Otherwise, it’s available…
phpanswered Leticia Rosa 1,184 -
3
votes2
answers1039
viewsA: How to force the Landscape/Landscape position?
In your Activity you need to put the following code in the onCreate method: this.setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_USER_LANDSCAPE); Thus remaining: protected void…
-
1
votes1
answer96
viewsA: Query - Comparison of Distinct Bases with equal columns
Depending on the DBMS you use, you will use the "MINUS" or "EXCEPT" function. In the case of SQL Server, your query would look like this: SELECT Conta, Saldo FROM Tab1 EXCEPT SELECT Conta, Saldo…
-
0
votes2
answers2375
viewsA: Set up site on IIS 7. Do not start site
1 - You cannot have two active pages at the same time on the same port. 2 - The default page he reads is index.html, so creating a website without it won’t work, ie change the name of your index. 3…
-
0
votes4
answers158
viewsA: printf function is not running after scanf method
Correct on the scanf line is as follows: "scanf("%d", &Radius);" Missed the &, so it does not continue the execution, whenever it is performing the reading of a number it should appear in…
canswered Leticia Rosa 1,184 -
3
votes1
answer808
viewsA: Formatting/Breaking Line of Code in Android Studio
You need to go to Files > Settings > Editor > Code Style > Java > wrapping and Braces > Check the box: Ensure right margins is not exceeded…
android-studioanswered Leticia Rosa 1,184 -
1
votes2
answers860
viewsA: How to create a report in Sql Server with information by date
SELECT DataDoPedido, CodProduto, QuantidadeProduto, CustoProduto, VendaProduto FROM nome_tabela ORDER BY DataDoPedido;
-
-1
votes1
answer66
viewsA: Rotation over a point on a 2D pivot in Java
This Angle is how many degrees you want to rotate one point with respect to the other. Take a look at that answer here too, teaches a way to do:…
javaanswered Leticia Rosa 1,184 -
0
votes1
answer930
viewsA: Printing Datagridview C#
Solved: I used the Dgvprinter. The button went like this: private void btPrint_Click(object sender, EventArgs e) { this.printDocument1.DefaultPageSettings.Landscape = true; DGVPrinter printer = new…
-
0
votes1
answer930
viewsQ: Printing Datagridview C#
I need to print the selected columns in a Datagridview. I can not generate image, because there are many columns (15 in all) and not all appear on the screen. I can make the impression in landscape…