New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Upper/Lower CASE error returns empty Queue List in FirebirdJobQueueMonitoringApi #3

Open

devvs opened this issue Oct 12, 2015 · 0 comments

devvs commented Oct 12, 2015

My Queue List (only 'Default') ist always "empty". Debugging the code shows the following:

public IEnumerable GetQueues()
{
string sqlQuery = string.Format(@"
SELECT DISTINCT QUEUE
FROM ""{0}.JOBQUEUE"";", _options.Prefix);

        return _connection.Query(sqlQuery).Select(x => (string)x.queue).ToList();

has to be:
return _connection.Query(sqlQuery).Select(x => (string)x.QUEUE).ToList();

or the SELECT should be SELECT DISTINCT queue FROM....

The text was updated successfully, but these errors were encountered:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment