Using variables from c to be passed into PQexec

From: vikashb(at)mweb(dot)co(dot)za (Vikash Badal)
To: pgsql-general(at)postgresql(dot)org
Subject: Using variables from c to be passed into PQexec
Date: 2002-02-15 05:55:00
Message-ID: b42d7fe.0202142154.3707e73c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

I am a novice programmer and I am now totally lost,
I've been through the web trying to find a solution,
If I've posted on the wrong place please advise.

If I have this line in the code, I get there desired result.
res = PQexec(conn, "DECLARE mycursor CURSOR FOR select * from currpass
where sitename = 'tvl'");
I get :
------------------------------------------------------------------
sitename password date time

tvl Zb0sj1sds 2002-02-13 12:21:00
------------------------------------------------------------------

If I do this:
strcat(querystr,"\"DECLARE mycursor CURSOR FOR select * from currpass
where sitename = \'tvl\'\");
fprintf(stdout,"%s\n", querystr);
res = PQexec(conn, querystr);

I get
---------------------------------------------------------------------------
Output of fprintf:
"DECLARE mycursor CURSOR FOR select * from currpass where sitename =
'tvl'"

Error Message:
NOTICE: identifier "DECLARE mycursor CURSOR FOR select * from
currpass where si
tename = 'tvl'" will be truncated to "DECLARE mycursor CURSOR FOR sel"
DECLARE CURSOR command failed

-----------------------------------------------------------------------------

What am I missing ?

Please assist

Vikash

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger Marzen 2002-02-15 06:18:08 Re: influenceing the optomizers choice on where clause
Previous Message Gavin M. Roy 2002-02-15 05:33:33 Re: Report generation