Posts by Gladiador • 345 points
28 posts
-
-1
votes1
answer56
viewsQ: Loop While and Foreach (PHP & JS) problem
I have two values from two different columns in the database: Column: Laitude, Longitude.I have stored values within each column of the table: Location. I want to list all the values of Latitude and…
-
-1
votes1
answer649
viewsQ: How to check if Cpf and cnpj already exist in the database (Pdo Php)
I’m trying to do a check when I want to register a customer. Before registering I want to check if the customer’s Cpf or cnpj already exists in the database. when I try to check only Cpf it works…
-
0
votes1
answer73
viewsA: How to use the if condition in jquery with variable usage?
the rate value was seeing as integer using parseint() so I switched to parsFloat and it all worked out fine. $("#qty").click(function () { var taxa = $("#taxa").val();//0,2 var Price =…
-
-1
votes1
answer73
viewsQ: How to use the if condition in jquery with variable usage?
I am trying to compare the selling price and the rate value over the selling price. example: the product costs 1467,73R$. my rate is 20%.In this case 20% above the price of the product would give…
-
-2
votes1
answer237
viewsQ: Multiply two numbers and show result (JQUERY/JAVASCRIPT + PHP)
I have 3 fields in my form FIELD 1: which already has a value that I pulled into my database which is the product price Field 2: where I will insert a whole number indicating the amount of product I…
-
1
votes1
answer110
viewsA: Error: Subquery Returns more than 1 Row MYSQL
So, guys, to get it I had to use wheren in in case, my consultation is so: select productid,pb.pricebookid, listprice from vtiger_pricebookproductrel pbp join vtiger_pricebook pb ON pb.pricebookid =…
-
-1
votes1
answer110
viewsQ: Error: Subquery Returns more than 1 Row MYSQL
The column I’m adding to subquery has more than one record, but do not know how to solve: select productid,pb.pricebookid,(select bookname from vtiger_pricebook p inner join…
-
0
votes1
answer38
viewsA: How not to show element that has no content using Angular js?
You can handle it yourself. This is what I wanted to do: <div class="row border-error mt-10 br-md" ng-repeat="pergunta in $ctrl.security_questions | orderBy: 'ordem_pergunta'"…
-
0
votes1
answer38
viewsQ: How not to show element that has no content using Angular js?
I have to list to the user a message within a panel depending on the "Radio" that face will click to show a message. has a radio as YES and another as NO. If he clicks yes, he will have to show you…
-
-1
votes1
answer126
viewsQ: How to skip an entire row only if the field is empty in PHP?
I am generating an sql script for a csv file. I would like to generate the sql file only where the id field is not empty. if the field is empty it jumps the line and does not generate that line in…
-
1
votes4
answers440
viewsQ: How to Fill in the field when the field is empty in PHP?
The LIMITE_SUPERIOR field is of the real type. I’d like to know how to tell him that if it’s empty fill in the number 0 field and when it’s not empty can fill in the number he found inside the…
-
1
votes1
answer49
viewsQ: How to duplicate a Csv field in PHP?
I have an id field in a csv file that is read as an array. This id field comes with two id in a field because id has an identical answer field called "answer". Instead of repeating this identical…
-
1
votes3
answers95
viewsQ: how could I use instead of passing an id, passing a Class in JQUERY?
I have this code here: HTML: <button class="btn btn-danger btn-circle delete" type="button"><i class="fa fa-remove"></i></b</td> $('#submit1, #submit2').click(function ()…
-
1
votes0
answers195
viewsQ: how to resolve Notice: Trying to get Property of non-object and delete a PHP PDO record
I have the following function to delete a record: //FUNÇÃO PARA LISTAR TODOS OS USUAROS public function ListarUsuarios() { $stmt = $this->conn->prepare ("SELECT *FROM N00_Usuario");…
-
0
votes1
answer1721
viewsQ: How to resolve Fatal error: Call to Undefined Function Contausuario() in
In my case I have this function : in the Home archive at the very beginning imported here: <?php require_once("session.php"); require_once("class_usuario.php"); $auth_user = new USER(); $user_id…
-
0
votes0
answers268
viewsQ: How to import record from only one CSV column within a Sql server column?
I have a csv file with multiple columns "ID,NOME_RUA,DATE" and I want to enter the record of a column "NOME_RUA" which is inside the csv file in my sql server table called "DATA". My "DATA" table in…
sql-serverasked Gladiador 345 -
1
votes0
answers116
viewsQ: How to implement an exception using "IF AND ELSE" in a Sql Server query
I have a query that lists all databases, tables, highway, and dates. only that in the query it returns me an error in the conclusion pq within the field to which are stored all tables, there are…
sql-serverasked Gladiador 345 -
3
votes3
answers775
viewsQ: How can I make a copy of multiple tables in a new table using SQL SERVER?
I have several tables with the same number of columns. and I want to insert the records of these tables into a new table. Anyone have an idea? because I only managed to insert one and does not…
-
0
votes2
answers917
viewsQ: How to reduce the running time of a query in SQL server?
I have a query that when it runs it’s taking a little while to bring results. And I don’t know where to start to improve this query. If anyone can help me I’ll be grateful. The query copies record…
-
0
votes2
answers600
viewsA: How to use Order By before Union in sql Server using this query?
To fix it I simply added the a in front of the Order By that is in this code that our friend @Alexandre Cavaloti sent to me here. the "to" is the reference for the table with "ATTACH" in the first…
sql-serveranswered Gladiador 345 -
1
votes2
answers600
viewsQ: How to use Order By before Union in sql Server using this query?
I have this query: SELECT * FROM ( SELECT distinct db_name() as 'Banco_de_Dados',g.KM_SIMBOL, fotos = COUNT(*) OVER (PARTITION BY d.globalid ORDER BY d.globalid),d.GDB_FROM_DATE as Data , g.RODOVIA…
sql-serverasked Gladiador 345 -
0
votes3
answers2525
viewsA: How can I insert multiple lines once only using Sql?
So guys with your help I managed to solve this mystery. to replace in the right place, I had to use a regular expression by the site https://regex101.com/ test if he could find exactly where I…
sql-serveranswered Gladiador 345 -
0
votes3
answers2525
viewsQ: How can I insert multiple lines once only using Sql?
I exported a Sqlite data record to Sql Server with Dump. I need to take these records and insert them into a new table that I created to receive these records within my database in Sql server. The…
sql-serverasked Gladiador 345 -
-1
votes1
answer90
viewsQ: How to Register a Date in My Database using ASP.NET MVC
Let’s assume that I want to register an item in my database.knowing my item name and price. But I also want when registering the item should also register the date.How do I do this? I’m still new to…
asp.net-mvcasked Gladiador 345 -
1
votes1
answer506
viewsQ: Insert the result of a Procedure into a new SQL table
I made the following code but I can’t insert the result into the new query table.Can I help myself? Here is the Sql code: DECLARE @Resultado TABLE ( Tabelas nvarchar(max), data_sincronização date,…
-
0
votes1
answer2401
viewsQ: How to convert a varchar type from a column to datetime within a view using SQL?
I have a view with a varchar type column and I want to convert this column to a date time type my code is here: update temp_vertical_dashboard set data = convert (datetime,data,101)…
-
2
votes5
answers16830
viewsA: How do I list all tables with their respective databases?
I finally managed to solve this problem I had. I found a specific solution to what I was looking for.I decided to post it here, because I think it might help someone else who might need it someday.…
-
6
votes5
answers16830
viewsQ: How do I list all tables with their respective databases?
I would like to list all the tables in my database that ends with a specific name and also all my databases that match these tables. I tried to do it but nothing comes back. Query SELECT da.name AS…