how to insert string into sql query?

Question

below is part of my code,

 ...
 char hashvalue[]="somehash"; // or i can use std::string

 SQLCHAR* query = (SQLCHAR*)"SELECT username FROM users WHERE hash = ..." ;
 SQLExecDirectA( hStmt, query, SQL_NTS );
 ...

In the code above I have no idea how to insert into query hashvalue to execute my query like this:

 SQLCHAR* query = (SQLCHAR*)"SELECT username FROM users WHERE hash = "somehash"" ;

I 'm very new to sql, thanks in advance for help.

Use std::string and bask in the glory of overloaded operators. — Captain Obvlious
– Captain Obvlious, Commented Jun 16, 2014 at 21:20

Thomas Matthews · Accepted Answer · 2014-06-16 21:22:38Z

2

Use std::string

std::string query_string = "SELECT username FROM users WHERE hash = ";
query_string += hashvalue;
SQLExecDirectA(hStmt, query_string.c_str(), SQL_NTS);

Another method:

char query_buffer[1024];
snprintf(query_buffer,
         "SELECT username FROM users WHERE hash = %s",
         hashValue);
SQLExecDirectA(hStmt, query_buffer, SQL_NTS);

Basically, your question is how to create a formatted string and has nothing to do with SQL.

answered Jun 16, 2014 at 21:22

Thomas Matthews

58k18 gold badges105 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to insert string into sql query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related