Error Select NODEJS [closed]

1

Good morning,

I am designing a REST API with NODEJS and when I insert this query:

function getInvTop(req, res) {

                if (connection)
                {

                    connection.query('SELECT recvTimeTs, CONVERT_TZ(recvTime, '+00:00', '+02:00'), fiwareServicePath, entityId, entityType, attrName, attrType, attrValue, attrMd FROM iof.invjuan WHERE attrName = "sensor2" ORDER BY recvTime DESC LIMIT 15', function(err, rows) {
                        if(err)
                        {
                            throw err;
                            console.log('Error al Conectar' + error);
                        }
                        else
                        {
                            res.status(200).json(rows);
                        }
                    });
                }
    }

I get the following error:

connection.query('SELECT recvTimeTs, CONVERT_TZ(recvTime, '+00:00', '+02:00'), fiwareServicePath, entityId, entityType, attrNa
me, attrType, attrValue, attrMd FROM iof.invjuan WHERE attrName = "sensor2" ORDER BY recvTime DESC LIMIT 15', function(err, rows) {
                                                                                                    ^^

SyntaxError: missing ) after argument list

How can I solve this problem?

fails for this, CONVERT_TZ(recvTime, '+00:00', '+02:00') , if I delete it works but I need it to put the European date.

This query in MySQL Workbench does work.

a greeting and thanks.

    
asked by Manolait 29.09.2017 в 09:01
source

0 answers