INSERT query with MySQL problem

[timmyg]

hey everybody
im a bit of a newb to Qt so keep that in mind
I'm trying to make an application that sends data to a MySQL database
i can successfully send data using the INSERT INTO statement, but it does not compile when i try to use variables for the data values
the variables i am using are strings and the fields i am trying to insert them into are all varchar(20)
here is my code (which i found by searching this forum):

QSqlQuery query;
query.exec("INSERT INTO TradeData (symbol,price,size,time) "
                "VALUES ( '"+symbol+"' , '"+price+"' , '"+size+"' , '"+timestamp+"' )");

QSqlQuery query;
query.exec("INSERT INTO TradeData (symbol,price,size,time) "
                "VALUES ( '"+symbol+"' , '"+price+"' , '"+size+"' , '"+timestamp+"' )");

To copy to clipboard, switch view to plain text mode 

attached is a screencap of my compile error

thanks

[jacek]

You pass std::string to QSqlQuery::exec(), but it expects a QString.


P.S. Don't construct your queries like that, use QSqlQuery::bindValue().

[timmyg]

You pass std::string to QSqlQuery::exec(), but it expects a QString.

P.S. Don't construct your queries like that, use QSqlQuery::bindValue().

ok
how do i do the bindvalue with variables?

[Raccoon29]

QSqlQuery query;
query.prepare("INSERT INTO TradeData (symbol,price,size,time) VALUES ( :symbol, :price, :size, :timestamp)");
query.bindValue(":symbol",symbol);
query.bindValue(":price",price);
query.bindValue(":size",size);
query.bindValue(":timestamp",timestamp);
query.exec();

QSqlQuery query;
query.prepare("INSERT INTO TradeData (symbol,price,size,time) VALUES ( :symbol, :price, :size, :timestamp)");
query.bindValue(":symbol",symbol);
query.bindValue(":price",price);
query.bindValue(":size",size);
query.bindValue(":timestamp",timestamp);
query.exec();

To copy to clipboard, switch view to plain text mode 

It replaces corresponding strings with the value you want (formatting it accordingly to the database formats)

Greetings,
Raccoon29

[timmyg]

thats exactly what i tried and i got compile error

error: no matching function for call to 'QSqlQuery::bindValue(const char[8], std::string&)'

error: no matching function for call to 'QSqlQuery::bindValue(const char[8], std::string&)'

To copy to clipboard, switch view to plain text mode 

is this also because im using strings instead of Qstrings?
how do i convert a string to a Qstring?

thanks

[jpn]

how do i convert a string to a Qstring?

You might want to take a look at QString docs. Hint: search for "std::string" or "StdString".

[Raccoon29]

Yes, the problem is exactly that std::string.
I never tried with std::string, but usually it is very easy to convert to QString:

QString var=other_string;

QString var=other_string;

To copy to clipboard, switch view to plain text mode 

so try putting your std::string in QString variables and try putting those in the bindValue, then let us know how it goes.

[timmyg]

Yes, the problem is exactly that std::string.
I never tried with std::string, but usually it is very easy to convert to QString:

QString var=other_string;

QString var=other_string;

To copy to clipboard, switch view to plain text mode 

so try putting your std::string in QString variables and try putting those in the bindValue, then let us know how it goes.

i get compile error:

error: conversion from 'std::string' to non-scalar type 'QString' requested

error: conversion from 'std::string' to non-scalar type 'QString' requested

To copy to clipboard, switch view to plain text mode 

im going to look into the QString documentation like jpn suggested and see if i can find anything

[timmyg]

i got it to work by doing this

QString var = stdstringvar.c_str();

QString var = stdstringvar.c_str();

To copy to clipboard, switch view to plain text mode 

thanks for the help

[Raccoon29]

IMHO the Qt one is a great documentation, most of answers are in there; every documentation should learn by this one.

Glad you found your solution
Greetings

[The Storm]

This is the way to convert it correct:
QString::fromStdString(your_std_string);