CODEWITHSUNDEEP
sqlnode.jsbotframework
Christian Abata
Christian Abata

Reputation: 1

set query into response bot microsoft framework

Team I'm trying to set the answer query in an answer into bot microsoft framework

This is what I do:

 request = new Request(
      "Here the string that returns me a number for example 763",
         function(err, rowCount, rows) 
            {
                console.log(rowCount + ' row(s) returned');
                process.exit();
            }
        );

 request.on('row', function(columns) {
    columns.forEach(function(column) {
           **session.send(column.value);
             next();**       
     });
         });
 connection.execSql(request);

The consult is ok, but I get the error :

cannot create property 'type' on number

For me Session.send is the way to send a message to the user from bot framewok emulator.

Upvotes: 0

Views: 146

Answers (1)

Vikram Jain
Vikram Jain

Reputation: 5588

Error - in Sql query syntax erorr:

"SELECT Medicina.Nombre FROM Medicina where='Aspirina'"

Change column name below query:

"SELECT Medicina.Nombre FROM Medicina where column_name='Aspirina'"

Upvotes: 1

Related Questions