Forum Discussion
tristaanogre
13 years agoEsteemed Contributor
The problem is in your SQL query I think. Because the single quote is a special character for JScript, you need to specify that you're actually wanting to include the quote. So, change your query string to
I think this will resolve both methods as it seems that in the first case you have nothing logged because you're already at EOF and the second is because of the empty record set due to a malformed SQL query string.
Try this and see if this fixes it.
var query = "SELECT promoname FROM database.promotion WHERE promoenddate = \'08-09-01\'";
I think this will resolve both methods as it seems that in the first case you have nothing logged because you're already at EOF and the second is because of the empty record set due to a malformed SQL query string.
Try this and see if this fixes it.
Related Content
Recent Discussions
- 6 hours agotramuntana
- 2 days agoSlickRick