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