tedious query not retrieving correct data from db

[tediousjs]

tedious query not retrieving correct data from db

[pekim]

That does seem very strange. I can't think of a way that tedious could interfere with the statement.

Just a silly question. The top 5 isn't responsible your problem?

[tromboneamafone]

I have tried it with and without the top 5, and in my app I am only able to retrieve data prior to july 6 with tedious.

I have also tried different db's and have had the same results with anything after july 6 2012 returning 0 results.

[pekim]

To try and get a better understanding of what's going on, could you enable some debugging logging please?
In your connection config object enable all debug logging options.

    var config = {...}
    config.options = {}
    config.options.debug = {
        packet: true,
        data: true,
        payload: true,
        token: true,
        log: true
    }

Then on the Connection object, log debug events.

    connection.on('debug', function(text) }
        console.log(text);
    });

This should produce a whole bunch of debug data. If you can add it to this issue (or as a gist), then I'll take a look at it and try and work out what's going on. (You'll probably want to redact the username and password.)

[tromboneamafone]

here is a gist of the log data: https://gist.github.com/4150105

[pekim]

Is that all the log data? It stops at the point that an initial statement is sent. There's no sign of a response to that request, let alone the sending of your select statement.

As you've said that you're getting some rows back from your query (just not what you expect), I suspect that there should be more log data.

[tromboneamafone]

Here are ones that actually pull data. You were right, there was no request.
prior to july: https://gist.github.com/4151932
after july: https://gist.github.com/4151936

[pekim]

I can't see anything obviously wrong at the protocol level. The two requests are identical except for the date. The requests look perfectly reasonable. There's nothing except column meta data, and a 'done' with row count 0, returned by the server.

If there are rows in the realTime table where date is later than or equal to midnight on 06 November, then I'm afraid I'm stumped.

[patriksimek]

Closing due to inactivity.

[Karsenh]

I'm getting this exact same issue - the working SQL query I copy over from SSMS and send through is returning different data than SSMS and sometimes nothing at all? It's using the correct db but acting as if it's not.

[mShan0]

Hi @Karsenh, can you open a new issue? We can assist you from there.