Posts by Tonico • 25 points
12 posts
-
0
votes2
answers60
viewsA: SQL Server Questions When Adding Shift 3 (SUM)
Come on, let’s go, the query below should bring what you are needing select Dataturno, Maquina AS Maquina, Parametro AS Código, ROUND(sum(Metrica),2) AS 'Metrica Total' , ROUND(SUM(CASE WHEN Turno =…
-
0
votes1
answer58
viewsA: Error: Please install tedious package Manually
Based on the link quoted in the comments, I did the following to resolve: I created a file called db.js with the following code: import * as tedious from 'tedious'; const Sequelize =…
-
-1
votes1
answer58
viewsQ: Error: Please install tedious package Manually
I am trying to do a project in Node.js / Electron and need to get information from an SQL Server database. When I run the line below, the error appears: const db = new Sequelize('banco', 'sa',…
-
2
votes1
answer323
views -
0
votes2
answers117
viewsA: Explode and compare value in a Select?
If it is always 3 characters, you can select the following SELECT data_id, LEFT( data_id , 3 ) as codigo FROM sua_tabela WHERE LEFT( data_id, 3 ) = $variavel_que_esta_procurando Now if they are…
-
-1
votes1
answer540
views -
0
votes1
answer180
viewsQ: Scriptcase port 8090 external access
Dear, I have the following problem, I have a Windows Server 2012, in which I have installed the IIS, which works perfectly. I had to install another program (Scriptcase) that installs an Apache on…
-
0
votes2
answers951
viewsQ: Draw a circle on an image with Javascript
I have an image and when I click on this image, I want to mark with a circle the place where I clicked. I also need to take the position to record later in the bank, because when I open the image…
-
0
votes2
answers2962
viewsQ: How to total fields in Lade using Laravel?
Dear, I’m making a dashboard, and set up a table on HTML, in a View and I need to tally some columns, and I’d like to do that right at HTML, but how I’m using DB::select I can’t use the command SUM.…
-
-1
votes1
answer994
viewsA: Laravel + L5-Repository
I resolved, I cleaned up Composer.json and deleted the line in config/app.php. Installed following manual again and everything worked... Thank you for reading and trying to help... A hug Tonic…
-
1
votes2
answers543
viewsA: Assign value to SQL variable
Expensive, select codigo, 10 as jogos from minha_tabela Works on SQL Server...
-
-1
votes1
answer994
viewsQ: Laravel + L5-Repository
Dear, I’m trying to install the L5-Repository and give the command: composer require prettus/l5-repository and the following appears: Using version ^2.6 for prettus/l5-repository ./composer.json has…