| 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: | Whole Thread | Raw Message | 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 |