pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Reg: Multiplequeries pls help me
2+ messages / 2 participants
[nested] [flat]

* Reg: Multiplequeries pls help me
@ 2006-02-27 05:44  sandhya <sandhyar@amiindia.co.in>
  0 siblings, 1 reply; 2+ messages in thread

From: sandhya @ 2006-02-27 05:44 UTC (permalink / raw)
  To: pgsql-admin


Hi,

I am using multiple queries inorder to get object id from the DB.When i am executing the same query from the DB side it is working fine.
If i am using the same in my application(VC 7) it is showing"PGRES_FATAL_ERROR"
The same query i copied and pasted on server side it is executing fine.....
Why is this so?
Pls tell me what i need to do...In case of complex queries executing through my application.
Help me in solving this...

Thank You
Sandhya

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Reg: Multiplequeries pls help me
@ 2006-02-27 06:03  Michael Fuhr <mike@fuhr.org>
  parent: sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Fuhr @ 2006-02-27 06:03 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

On Mon, Feb 27, 2006 at 11:14:06AM +0530, sandhya wrote:
> I am using multiple queries inorder to get object id from the DB.
> When i am executing the same query from the DB side it is working fine.
> If i am using the same in my application(VC 7) it is showing"PGRES_FATAL_ERROR"
> The same query i copied and pasted on server side it is executing fine.....

What's the complete error message?  What do you mean by "multiple
queries"?  Several queries executed sequentially via separate
function calls?  Several queries separated by semicolons executed
via the same function call?  A single query with subqueries?  Could
you post the query or queries and explain how you're executing them?
If you're writing code then please post the code that executes the
queries.

This seems off-topic for pgsql-admin; it would probably be more
appropriate in pgsql-general, pgsql-interfaces, or pgsql-novice.

-- 
Michael Fuhr



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2006-02-27 06:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-02-27 05:44 Reg: Multiplequeries pls help me sandhya <sandhyar@amiindia.co.in>
2006-02-27 06:03 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox