MySQL Forums
Forum List  »  Connector/Node.js

CRUD SQL Result set problems
Posted by: Peter Huszar
Date: February 16, 2019 03:20PM

In connection with I have three questions and I haven't found anything after reading and searching the internet:

- How can I see and handle that a has an empty result set? In the node.js xdevapi implementation I do not get the result set, only result rows one after another and my .execute(callback) is not even once called.

- Because my callback is called several times I do not know when it is called the last time i.e., when do I get the last row from the result set. How can I see and handle it?

- COUNT(*) / * is not accepted in the select string throwing an unexpected token error at the * character both cases. This is standard SQL, though. I can see that I can use session.sql('SELECT COUNT(*) FROM table') but I am curious to know why not in CRUD then?

Options: ReplyQuote

Written By
CRUD SQL Result set problems
February 16, 2019 03:20PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.