Posts by Alineat • 357 points
23 posts
-
0
votes2
answers790
viewsQ: How to get max() and min() data in SQL?
How can I get the minimum and maximum date of a table? I am using the functions min() and max(), but it is not returning the expected value. This is a small example of the date data from my table:…
-
1
votes1
answer212
viewsQ: T-SQL - Delete filter "NOT IN" does not work
I am filtering my base by store code (varchar), but the filter is not removing the store codes I want to delete from my query. This is my consultation: SELECT A.CPF , A.[Cod Loja] , B.NomeLoja ,…
-
0
votes3
answers6516
viewsQ: How to convert varchar to Numeric in SQL?
I am trying to make an SQL query, but it returns the following error: "Error Converting data type varchar to Numeric." SELECT Tabela1.CPF, Tabela2.CPF FROM Tabela1 INNER JOIN Tabela2 ON Tabela1.CPF…
-
0
votes1
answer33
viewsQ: How to create a class attribute with predefined Python types?
I consulted at documentation from Python, but I couldn’t find a syntax for how I could create an attribute from a class that has a predefined type. I took as an example this exercise of W3schools:…
-
0
votes0
answers83
viewsQ: How to identify left and right table in the execution of multiple Joins in SQL?
I’m trying to understand how to read the execution of multiple INNER Joins. If I do multiple INNER Joins my left table remains the same as the first INNER JOIN or the left table becomes the…
-
1
votes1
answer675
viewsQ: What is the difference between JOIN and UNION in SQL?
What’s the difference between JOIN and UNION in SQL? I thought a query made with either of the two would result in the same table, but I’m taking a course at Datacamp where the teacher says these…
-
-1
votes1
answer1186
viewsQ: How to remove "Uncaught Syntaxerror: Unexpected end of input" from Javascript
I am running a script on the Google console and get the error "Uncaught Syntaxerror: Unexpected end of input". I did not find the syntax error of this code, I searched in previous questions, here…
-
0
votes1
answer548
viewsQ: How do ORDER BY DESC work in Mysql?
I am trying to make a query on my table using OREDER BY DESC, even using the correct syntax I get the error: "You have an error in your SQL syntax; check the manual that Corresponds to your Mysql…
-
1
votes1
answer131
viewsQ: How to write a python module from a test?
I’m doing an inverse exercise on Python modules and tests with pytest, but I’m not succeeding. Whenever I run the code I get the message "E Attributeerror: 'str' Object has no attribute…
-
0
votes0
answers36
viewsQ: How to update a key slice (key) of a Python dictionary?
How do I update just a slice of a key in a Python dictionary? I am scraping a page and would like to format the result so that my key is on the same line as my value, for example: Air Conditioners:…
-
2
votes1
answer1373
viewsQ: How to add values of a csv using Python?
I have a csv file similar to this, with all the information of all the municipalities of Brazil (I shortened the csv to not get too extensive): ESTADO,MUNICIPIO,HABITANTES,AREA…
-
0
votes2
answers1305
viewsQ: How to turn a list into a set in Python?
I’m trying to intersect the player list with the computer list, but I’m getting an error that says "line 13, in print(set(player).intersection(computer)) Typeerror: 'int' Object is not iterable".…
-
0
votes3
answers3591
viewsQ: How to use "while not in" in Python?
I tried to loop with while to check if a condition was met. If the user enters 0, 1 or 2 the program should stop asking the user which number he will choose. If the user chooses a number other than…
-
0
votes1
answer2256
viewsQ: How to link a computer file in my html?
How do I link a folder from my computer to my html file? Each folder I want to open is inside the same folder where I saved my html file. I’ll leave the screen print to help you understand. Inside…
-
0
votes1
answer819
viewsQ: Invalid syntax message without any apparent error
I am trying to rename a folder that has a set of files, I want to remove all digits of the names of the files. But when I try to run the code the error message appears: "invalid syntax", pointing…
-
1
votes1
answer131
viewsQ: How to open different web pages using while
I would like the program to perform the repetition of a command 3 times: wait 10 seconds to open a web page. For this repetition to occur I set the code below: import time import webbrowser…
-
2
votes2
answers8846
viewsQ: Syntaxerror: unindent does not match any Outer indentation level
What should I do when this error message appears: "Syntaxerror: unindent does not match any Outer indentation level"? I cannot declare the Else of the variable. Follow a print of the problem and the…
-
1
votes3
answers1036
viewsQ: How to avoid repeating html and css commands?
How do I not repeat the HTML and CSS code of a site’s structure? For example, I did the structure of a web page and I want that structure to be applied to the other 5 pages that I will create for…
-
2
votes2
answers235
viewsQ: Background-position is not working
Hey there, guys. I used the image-Replacement technique, tried to leave the image centralized using the background-position: center, but the image position remains unchanged. Would anyone know why…
-
2
votes1
answer292
views -
0
votes1
answer167
viewsQ: How to make a checkbox become clickable?
Someone knows how to make the checkbox clickable. I created a new look for my checkbox, but when clicking on the checkbox it is not selected. I want the checkbox to be white and only when it is…
-
2
votes2
answers2990
views -
2
votes1
answer4115
viewsQ: Problem in HTML checkbox size
I have a problem with the size of my checkboxes. I isolated ul with a class, so that this element did not take any characteristic of the other uls for which I had already defined a style. Would…