Print Result To Screen

Question

1.00/5 (2 votes)

See more:

I have a console app and I need to print the result of this query to screen.
How is this done?

"SELECT COUNT(IP) AS row_count FROM urlock WHERE IP='173.201.216.2'";

Posted 9-May-11 9:34am

Member 7766180

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2011-05-09T09:40:00

Solution 1

Use printf() or cout to display your results formatted according to your requirements.

Posted 9-May-11 9:40am

Richard MacCutchan

Comments

Member 7766180 9-May-11 15:57pm

Tried this, it displayed to query...
int printf("SELECT COUNT(IP) AS row_count FROM urlock WHERE IP='173.201.216.2'");

Richard MacCutchan 10-May-11 3:50am

I think it's time to go back to your programming guides.

Member 7766180 10-May-11 11:34am

In the meantime, how do you get a returned value?

Richard MacCutchan 10-May-11 12:23pm

I don't really know SQL but "SELECT COUNT" looks like it returns the count of items that you are querying. Try a query that gets the value instead.

Member 7766180 10-May-11 12:37pm

I think I need a variable before the query, but whatI tried doesn't debug. I think it's the syntax...

int RED;
RED = SELECT COUNT(*) AS row_count FROM tblURL WHERE IP = '192.168.1.1';
cout << "RED"

Richard MacCutchan 10-May-11 13:29pm

No, you need to use a SELECT statement that returns data rather than the number of rows that contain the query value. Take a look here for some more information.
I also doubt that the above statement would even compile as it is not C/C++ code.

Member 7766180 10-May-11 14:23pm

Got it to print a result, result wrong though. It's the SELECT statement. See new post.

Richard MacCutchan 10-May-11 14:28pm

See new post

Where?

Albert Holguin 10-May-11 14:29pm

we keep saying the same things...lol

Richard MacCutchan 10-May-11 16:21pm

I found it here; take a look for more of the same.

Legor 11-May-11 4:05am

Learn the basics of programming please.

Richard MacCutchan 11-May-11 8:31am

I know the basics, it's the advanced stuff I can't figure out! :)

ShilpiP · Answer 2 · 2011-05-09T20:05:00

Solution 2

If you want to show the result of query than first you get this value in string and than with the help of printf and cout you can display your results.
Can you please share your database part with us ??

Posted 9-May-11 20:05pm

ShilpiP

Comments

Member 7766180 10-May-11 11:28am

Database is one table, one table only. I'm querying it to see if an IP address is in it. If it is then I get a "1" returned else it returns a "0".
Thanks
DS

Albert Holguin · Answer 3 · 2011-05-10T03:12:00

Solution 3

Here's an explanation on printf() and how to use it:
http://www.cplusplus.com/reference/clibrary/cstdio/printf/[^]

Posted 10-May-11 3:12am

Albert Holguin

Comments

Member 7766180 10-May-11 11:26am

Thanks Albert, the printing part I have, Its the getting the returned value that seems to be my problem. How do I get that?
Thanks
DS

Albert Holguin 10-May-11 11:36am

The return from the query? ...that query is not C++... you would have to put up more code, you may be trying to mix different languages.

Member 7766180 10-May-11 11:47am

It's MySQL, I have an online MySQL database that I am connecting to. I can make the connection, but I need to save the answer to a variable, then print to screen.
DS

Member 7766180 10-May-11 12:02pm

I thought maybe this...
int RED;
RED = SELECT COUNT(*) AS row_count FROM tblURL WHERE IP = '192.168.1.1';
cout << "RED"

Doesn't return or display anything.

Albert Holguin 10-May-11 13:22pm

that's because that statement is completely invalid, like I said, its not even C++... how are you passing that query to your SQL server (or database)? there has to be other code to interface the two, or use a library like SQLAPI++ (http://www.sqlapi.com/)

Albert Holguin 10-May-11 13:28pm

There's a lot of other library options as well by the way, look up "SQL database C++"

Member 7766180 10-May-11 14:22pm

Got it to work, now printing out a result. However; it's not the correct result. See new post.

Albert Holguin 10-May-11 14:26pm

what new post? don't see anything new posted by you...

Member 7766180 10-May-11 14:46pm

Sorry, dawg hungry! :)

Joan M · Answer 4 · 2011-05-10T04:37:00

First of all you should get a "connection" to the database... something you could use as an interface... once you've got that interface, then you will be able to query SQL strings like the one you've written here...

Then, typically you'll have to store the result of your SQL statement into a variable or so and then you'll be able to show it to the user by using any of the methods to show data... printf, cout...

if you use printf("SELECT COUNT(IP) AS row_count FROM urlock WHERE IP='173.201.216.2'"); of course this will show the text itself...

printf or cout only are useful to show information. Before showing the information you need to get it...

Give us more details on the database part and we will help you...

Good luck!