Thread: n00b at reading data from databases need help

Hi, I'm working on a GUI (Visual C++ 2005) that one of the thinks it is supposed to do is take some data from a MySQL database and an excell file do some calculations and show the results.
What I want to know is the commands I need to use to take a data from a specific cell in the database and/or the excell file and for example add it to another non-database variable. For example if the database looks like this

Animal |Age | Collor |
---------------------------------
Dog |5 | Brown |
Cat |3 | White |
Dog |10 |Black |

What commands are needed to lets say have the Age of the Black Dog calculated in human years (5*7)
If there is a site I could look for more info about retrieving Data from databases, I think that will do also.
Thanks

This looks like a good place to start.

Originally Posted by AntV

Thanks, I guess, but thats a lot of info. I have started reading all that, but if you or somebody else had a more easy solution, please tell me. I must finish this asap and time for encyclopedic reading is not a luxury I have

p.s. I forgot to say that I already have connected the database to the GUI as a data source

That's why there's a table of contents so you can read the parts you need to know.

Also, if you think a 16-page tutorial is "encyclopedic" then you might be in the wrong line of work. (And so far as I can tell the tutorial answers your question by the time you get to page 3.)

So far as I can tell, cmdline.h and printdata.h are part of the mysql++ package. Do you have the entire package? (In fact, those examples there I think are part of the mysql++ package too -- the header files might be in that examples directory.)

So should I just copy all those files in the include folder of Visual Studio or somewhere else?
Isn't that what the install of SQL++ should do?

#include "this file" (as opposed to #include <this file>) generally means "this file is in the directory with the code in it, as opposed to the default include library for everything."

I still haven't found how to make use of MySQL++ and theworst is I don't know what I'm doing wrong

Originally Posted by AntV

I still haven't found how to make use of MySQL++ and theworst is I don't know what I'm doing wrong

It's a bit tricky, 'cause I don't have the package installed -- but have you read the readme for windows? Do you have that examples folder with those sample projects in it? Open those and run with them.

That's the whole problem... the projects are just headers that can't be executed by their own and if I just copy the code from them into a new project, it gives me an error of something missing (tried adding the .h files in the same directory, but no luck). Also the install file says to view the corresponding Read Me file, but in there there are no install-relative info. I tried googling around but the only thing I got is how to make some changes so that it runs in Form and MFC applications and although I did those as well it just doesn't work. Any other ideas? (btw you were right, if I do get this to work, I'll be almost finished )

Originally Posted by AntV

That's the whole problem... the projects are just headers that can't be executed by their own

Are you sure. Are you really really sure. Because the samples that I'm looking at, that they claim are included, are most definitely not "just headers that can't be executed". For example, simple2.cpp (supposed to be in the examples folder) is most definitely a complete, runnable program.

Also, did you read the bit that says

MySQL++ comes with the exrun shell script for Unixy systems, and the exrun.bat batch file for Windows. You pass the example program and its arguments to the exrun helper, which sets up the library search path so that it will use the as-yet uninstalled version of the MySQL++ library in preference to any other on your system:

./exrun resetdb [-s server_addr] [-u user] [-p password]

That's the typical form for a Unixy system. You leave off the ./ bit on Windows. You can leave it off on a Unixy system, too, if you have . in your PATH. (Not a recommendation, just an observation.)

(That may or may not be necessary of course.)