public inbox for [email protected]
help / color / mirror / Atom feedFrom: Oliver Elphick <[email protected]>
To: Vutharkar Goutham <[email protected]>
Cc: [email protected]
Subject: Re: Select statement error !!!!
Date: Wed, 24 Sep 2003 12:00:49 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
On Wed, 2003-09-24 at 11:27, Vutharkar Goutham wrote:
> Hello,
>
> I am doing a simple program with PostgreSql wherein i am giving a select
> statement as an argument to PQexec like this
>
>
> char query[1024];
> strcpy(query,"Select * from Udp_Table");
> now if i try to execute the above statement it is giving me always teh
> select failed message.
In that statement you have a mixed case name for the table. If it has a
mixed case name in the database too, the name needs to be enclosed in
double quotes.
--
Oliver Elphick [email protected]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"And we know that all things work together for good to
them that love God, to them who are the called
according to his purpose."
Romans 8:28
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Select statement error !!!!
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox