Syntax error with select statement

From: aravind chandu <avin_friends(at)yahoo(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: Syntax error with select statement
Date: 2008-12-17 19:59:52
Message-ID: 958696.81697.qm@web31408.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
^

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2008-12-17 20:00:51 Re: [GENERAL] A bit confused about Postgres Plus
Previous Message Peter Eisentraut 2008-12-17 19:55:40 Re: [GENERAL] A bit confused about Postgres Plus