DaniWeb Forum Index > Software Development > C++

C++ RSS

MySQL++ query question

Please support our C++ advertiser: Intel Parallel Studio Home

•

Join Date: Mar 2007

Posts: 35

Reputation: Tales is an unknown quantity at this point

Solved Threads: 1

Tales

Online

Light Poster

MySQL++ query question

Apr 3rd, 2007

I want to make a query in C++ using the MySQL++ API.

Here is my problem, in PHP for example I make something like this:

$query = "SELECT * FROM table1 WHERE id = " . $value;

In C++ I can't do that. I need a way to make $value be part of the query string. I know it is a silly question, but can someone help me find this answer?

Thank You

•

Join Date: Aug 2005

Posts: 15,334

Reputation: Ancient Dragon has a reputation beyond repute

Solved Threads: 1454

Ancient Dragon Ancient Dragon is offline

Offline

Still Learning

Re: MySQL++ query question

Apr 3rd, 2007

you could use std::string class and just concantinate the value with the string

Help with Code Tags

C++ Syntax (Toggle Plain Text)

std::string query = "SELECT * FROM table1 WHERE id = ";
query += value;

now the problem is that if value is a string you will probably have to enclose it in quotes

 Help with Code Tags 
 C++ Syntax (Toggle Plain Text) 
std::string query = "SELECT * FROM table1 WHERE id = '";
query += value;
query += "'";
std::string query = "SELECT * FROM table1 WHERE id = '";
query += value;
query += "'";