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