C++ sql pass integer to sql string

Question

I have built a database in MS Access. There I have a table called Customers which also has a cell called Employee type: integer. I also built a program in C++ which controls all data.

Let's say I have a string like this:

string sqlString = "SELECT * FROM Customers Where Customers.Employee = '" + id + "' ";

Id passes through my function correctly and is an integer, so I get an error in compilation saying: "Invalid pointer addition".

If I declare id as a string of course there's no error but there are no results in my form also. If I declare in database cell Employee as text and build my query like this:

string sqlString = "SELECT * FROM Customers WHERE Customers.Employee = 128";

I get results, but I need that Employee as an integer cause its a foreign key from another table.

So, what should I do with my query to have results passing integer as parameter through variable id, to be ok with the cell Employee from database which is also integer? Any ideas? I would really appreciate some help here.

As I said, if I convert id to string, there are no results in my form since Employee in database is an integer. So this:

std::ostringstream buf;
buf << "SELECT * FROM Customers Where Customers.Employee = '" << id  << "' ";
string str = buf.str();

won't do the job or any other conversion.

How can I pass id as an integer in my query?

score 3 · Answer 1 · answered Dec 18 '08 at 15:47

3

You could use sprintf, but in C++ you can do:

std::ostringstream buf;
buf << "SELECT * FROM Customers Where Customers.Employee = '" << id  << "' ";
string str = buf.str();

(untested)

answered Dec 18 '08 at 15:47

Bill Zeller

1,336
1
9
13

Stirngstream is the preferred way to go. Most queries are written with sqlstream. – fasih.rana Dec 18 '08 at 15:50

score 2 · Answer 2 · edited May 23 '17 at 12:13

2

You need to convert id to a string, then your first approach should work.

See this question for how to do the conversion: Alternative to itoa() for converting integer to string C++?

edited May 23 '17 at 12:13

Community

1
1

answered Dec 18 '08 at 15:44

frankodwyer

13,948
9
50
70

score 1 · Answer 3 · answered Dec 18 '08 at 16:20

1

use

std::ostringstream buf; buf << "SELECT * FROM Customers Where Customers.Employee = " << id ; string str = buf.str();

This should work please try '12' --- quote should not be placed before and after 12

answered Dec 18 '08 at 16:20

yesraaj

46,370
69
194
251

score 0 · Answer 4 · answered Dec 18 '08 at 15:53

0

you can use boost::format with boost::str

string = boost::str(boost::format("This is a string with some %s and %d numbers") %"strings" %42);

this should be better approach since you will have all the replacement variable in one place at the end.

answered Dec 18 '08 at 15:53

yesraaj

46,370
69
194
251

C++ sql pass integer to sql string

4 Answers4