unable to find string literal operator ‘operator""ID’ with ‘const char [56]’, ‘long unsigned int’ arguments

[suslucoder]

I have the line below in my code.
I got this error :
unable to find string literal operator ‘operator""ID’ with ‘const char [56]’, ‘long unsigned int’ arguments.
I must write ID with " " because its uppercase, postgresql accept it with double quotes.
How can i solve this error?

res = PQexec(conn,  "UPDATE public.epp_commands SET unique_id='5' WHERE "ID"='2'");

[Ganado]

If the string itself has double-quotes in it, you need to escape those, with \" instead of just ".

See example at bottom of page: https://en.cppreference.com/w/cpp/language/escape

[suslucoder]

I try to do it but im still getting this error
I couldnt find my mistake :((

error: unable to find string literal operator ‘operator""command_group_id’ with ‘const char [76]’, ‘long unsigned int’ arguments
ress = PQexec(conn,("UPDATE public.epp_group_commands SET \"command_flag\" ='1' WHERE \"group_id\"='"command_group_id+"'").c_str());

[coder777]

A + is missing if command_group_id is actually a std::string:

ress = PQexec(conn,("UPDATE public.epp_group_commands SET \"command_flag\" ='1' WHERE \"group_id\"='"+command_group_id+"'").c_str()); // Note: +command_group_id

[suslucoder]

command group id is not a string. i want to convert it a string in this query
I try to use std::to_string but its not work

error: cannot convert ‘std::__cxx11::basic_string<char>’ to ‘const char*’ for argument ‘2’ to ‘PGresult* PQexec(PGconn*, const char*)’

      res = PQexec(conn,"UPDATE public.epp_group_commands SET \"command_flag\" ='1' WHERE \"group_id\"='"+std::to_string(command_group_id)+"'");

[coder777]

You forgot the ).c_str() at the end of the string.

[salem c]

You need to build the whole thing up as std::string then convert to c_str at the last moment.

// also uses string folding to keep long strings readable
std::string cmd = "UPDATE public.epp_group_commands "
       "SET \"command_flag\" ='1' "
       "WHERE \"group_id\"='";
cmd += command_group_id;
cmd += "'";
res = PQexec(conn, cmd.c_str());

[suslucoder]

thank you so much