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