MySQL++ query question

Expand Post »

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

Similar Threads

test mysql query for no results in PHP
Double MySQL Query in PHP
Python Tuples and Mysql Query in MySQL
MySQL query's in MySQL
Change MySQL Query Timeout Period in MySQL

Tales

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

37 posts
since Mar 2007

Permalink

Apr 3rd, 2007

Re: MySQL++ query question

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

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

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 += "'";

Ancient Dragon

Sponsor

Team Colleague

Featured Poster

Reputation Points: 5608

Solved Threads: 2282

Retired and Enjoying Life

Offline

21,953 posts
since Aug 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C++ Forum Timeline: Dev C++ --> URGENT PLZ

Next Thread in C++ Forum Timeline: User-Defined Function - setup right?

DaniWeb Message

Cancel Changes

User Name
Password