Re: Syntax error with select statement

aravind chandu wrote:

Hello,
          I have problem with select statement in c++ program I am using pqxx library to connect to postgresql database.My query is

          result R(T.exec(" select * from dbtable where username =  ' "+user+" ' and password = ' "+st+" ' "));

         here st is in encrypted format and the string is st = M^fuo|`sjyo|`so|>-?z  this is the string i stored in the table .

        The error I was encountered is "terminate called after throwing an instance of 'pqxx::syntax_error'
  what():  ERROR:  unterminated quoted string at or near "'M^fuo|`sjyo|`so|>-?z"
LINE 1: ...table where username = 'achandana' and password = 'M^fuo|`sj...
                                                                                                  ^    "

 I am not able to identify what the actual problem is can you guys please help to solve this problem?Your help is greatly appreciated.

Thank You,
Aravind

Well its telling you in the error the quotes are flaky.  It apears that the password portion contains another sing quote.

I would move to double dollar quoting when dealing with strings that contain special characters

example
R(T.exec(" select * from dbtable where username =  $UserName$ " + user + " $Username$ and password = $Password$ " + st + " $Password$ "));

see http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html
on dollar quoting