Date: Tue, 29 Feb 2000 22:45:54 +1300
From: Rob Brown-Bayliss <rob@ZOOstation.cc>
To: PostgreSQL <pgsql-interfaces@postgreSQL.org>
Subject: useing strings for cursors with libpq
Message-ID: <20000229224554.A9931@ZOOstation.cc>
Reply-To: Rob Brown-Bayliss <rob@ZOOstation.cc>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

Hi all.  

I am trying to pass a cursor to a function like so:


void Begin_DB(gchar *cursor)
{
	GString *tempstring;
	gchar *thecursor;

	tempstring = g_string_new("DECLARE mycursor CURSOR FOR ");
					g_string_append(tempstring, cursor);
					
					thecursor = tempstring->str;
					g_string_free(tempstring, FALSE);
	
	printf("%s",thecursor);
	res = PQexec(conn, "BEGIN");
			if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)
				{
					fprintf(stderr, "BEGIN command failed\n");
					PQclear(res);
					exit_nicely(conn);
				}
			PQclear(res);

			/*
			 * fetch instances from the players.
			 */
			res = PQexec(conn, thecursor);
			if (!res || PQresultStatus(res) != PGRES_COMMAND_OK)
				{
					fprintf(stderr, "DECLARE CURSOR command 
failed\n");
					PQclear(res);
					exit_nicely(conn);
				}
			PQclear(res);
}


but it always fails.  Is it possible to pass a cursor like this?  (I am 
a long way from being a C expert but it appears to me that thecursor has 
the string I am looking for)


  Rob Brown-Bayliss
  ---====<*>====---

  live from ZOOstation
  http://www.ZOOstation.cc