Re: Using variables from c to be passed into PQexec

Don't pass in the double-quotes in your call. In other words:

strcat(querystr,"DECLARE mycursor CURSOR FOR select * from currpass
where sitename = \'tvl\'");

should work.

Tim

----- Original Message -----
From: "Vikash Badal" <vikashb(at)mweb(dot)co(dot)za>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, February 14, 2002 9:55 PM
Subject: [GENERAL] Using variables from c to be passed into PQexec

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>