Posts by cmcampos86 • 207 points
18 posts
-
2
votes1
answer210
viewsQ: Get part of a string with Regular Expression - C#
Based on the string "Plan Liberty Company +50 - 043-98965-2784(058/POST/SMP)", I need to get the part of "043-98965-2784". I realized that in the txt file I’m using, the numbers follow the pattern…
-
2
votes1
answer119
viewsQ: Timespan conversion
I am reading a file delimited by semicolon and one of the information that is the duration of the link is coming as "00:97:54". When trying to convert to Timespan, obviously gives error The Timespan…
-
0
votes1
answer358
viewsA: List of values in a Session using Nodejs
I solved using the following code below: var app = require('express')(); var http = require('http').Server(app); var session = require('express-session'); var express = require('express');…
-
1
votes0
answers180
viewsQ: Nodejs Config Module Error
I have a mysql.js file that accesses the database as below: 'use strict'; var mysql = require('mysql'), config = require('config'); var connection = mysql.createConnection({ host:…
-
2
votes1
answer358
viewsQ: List of values in a Session using Nodejs
I’m using the modules express-Session and express and I need to create a list of values in an item of a Session so that at some point I can add values to it. Ex: req.session.category = "Include key…
-
0
votes1
answer197
viewsQ: REPLACE in the IN - Mysql clause
I have the following query below, and the idea is to take the value of the @subcategories variable and put in the query’s IN: set @subcategorias = replace('10, 11, 29, 30, 31', '''', ''); SELECT…
-
0
votes1
answer49
viewsA: Rows in Columns
sorry for the delay in feedback on this issue. As it had been said by Bacco first, a column was missing in one of the tables to obtain this link. That way, I was able to do the consultation I…
mysqlanswered cmcampos86 207 -
2
votes2
answers5887
viewsQ: Removing part of a string - SQL Server
I have written in a column of the database the name of a file with extension (FILE.txt). I need to show in a SELECT only the FILE instead of FILE.txt Someone knows how to do?
sqlasked cmcampos86 207 -
0
votes1
answer453
viewsA: Performance when comparing Varchar fields in SQL Server
I ended up solving this by having to work with some temporary tables in order to get a single value to do JOIN instead of Right(L.nrDiscado, Len(D.Descricao)) as said here that causes a lot of…
-
0
votes1
answer453
viewsQ: Performance when comparing Varchar fields in SQL Server
To SQL below is causing much slowness by the fact that I use the Right(L.nrDiscado, Len(D.Descricao)) (believe me) to compare with the field D.Descricao: create table #TempNrDiscado (NrDiscado…
-
3
votes1
answer49
viewsQ: Rows in Columns
I have the following result of a query: NOMECARACTERISTICA NOMEINFORMACAO Marca Samsung Marca ASUS Modelo E32 370E4K-KW3 Modelo X555LF My idea is to transform in the following form: Marca Modelo…
mysqlasked cmcampos86 207 -
0
votes2
answers336
viewsA: DELETE method using href - Nodejs
I ended up doing it that way: <a href="javascript:void(0)" onClick="ExcluirRegistro('/stormtroppers/',{{stormtropper.id}})">Delete</a> javascript: function ExcluirRegistro(url, user_id)…
-
1
votes2
answers336
viewsQ: DELETE method using href - Nodejs
I am loading some information from the bank and one of the columns will be a link that will delete an infomation. By being in a table, the link href is like this: href="/delete/ID(vem do template…
-
1
votes1
answer84
viewsQ: Difference between extends and include using the SWIG Template Engine
I’m using the Template Engine with Nodejs and I couldn’t understand the difference between using extends and include. I was able to understand that the include you included directly a part of HTML…
node.jsasked cmcampos86 207 -
0
votes2
answers191
viewsA: Nodejs debug using visual studio code
I ended up discovering that I was putting the breakpoint in the wrong place, causing it not to be triggered using Visual Studio Code. I also tested the debug of Visual Studio Community 2015 with…
-
2
votes2
answers191
viewsQ: Nodejs debug using visual studio code
I’m using Visual Studio Code and I’m not able to debug a nodejs for it. If I put one breakpoint anywhere in my app.js and start debug, it works, but when I already have it in the browser and switch…
-
1
votes1
answer246
viewsA: Curl + HTTP Nodejs Server
I resolved! The problem was in the way that the header was being passed on Curl. Debugging I saw that the header in Node.js was not as JSON and I had passed in Curl. In the Curl command I added a -i…
-
1
votes1
answer246
viewsQ: Curl + HTTP Nodejs Server
Good morning! I created an HTTP server using nodejs as follows: var express = require('express'); var app = express(); var bodyParser = require('body-parser'); app.use(bodyParser.urlencoded({…