getting the count value from the querystring

Question

Suppose I have a Querystring defined as follows:

String MyTableCount =  "SELECT"
                         + "COUNT(*) AS TOTALCOUNT "
                         + " FROM "
                          // and so on

How do I access the "TOTALCOUNT" value as I want to compare it's value to another value?

I was thinking something like the following:

if((MyTableCount.TOTALCOUNT) > 100 )
{

}

else
{

}

But this generates an error, as TOTALCOUNT variable needs to be defined.

I'm not sure if I understand your question correctly, but are you actually running your database query against the Database using a connection, statement, and ResetSet? If so you can pull the data from the ResultSet and store it to access it. — user695992
– user695992, Commented Mar 21, 2014 at 18:43
MyTableCount.TOTALCOUNT does not make sense. MyTableCount is your query string, which you should pass to one of the query execution methods. — Bhesh Gurung
– Bhesh Gurung, Commented Mar 21, 2014 at 18:46

Gordon Linoff · Accepted Answer · 2014-03-21 19:13:19Z

3

You need to print out the query string. According to what you have, it starts as:

SELECTCOUNT(*) AS TOTALCOUNT

This is not a recognized SQL command. You need a space after the SELECT.

edited Mar 21, 2014 at 19:13

answered Mar 21, 2014 at 18:55

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Tiny Haitian Over a year ago

Agreed. Staying away from unnecessarily concatenating your queries would avoid issues like this.

user3239126 Over a year ago

@TinyHaitian Did you mean to stay that I should write the full query in one line?

user3239126 Over a year ago

@Gordon Linoff Your answer sounds more towards correcting the SQL String rather than what I actually asked. May I know why? Anyways, thanks for your answer.

Gordon Linoff Over a year ago

@John . . . If the SQL string is not formatted correctly, it will not run. If it doesn't run, you cannot get results from it.

Tiny Haitian Over a year ago

@John, that what I would do.

Collectives™ on Stack Overflow

getting the count value from the querystring

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related