Received: from bubba.NMSU.Edu (bubba.NMSU.Edu [128.123.3.39]) by hub.org (8.8.8/8.7.5) with ESMTP id QAA09280 for ; Wed, 9 Sep 1998 16:46:29 -0400 (EDT) Received: from dns1.NMSU.Edu (dns1.NMSU.Edu [128.123.3.5]) by bubba.NMSU.Edu (8.9.0/8.9.0) with ESMTP id OAA08058 for ; Wed, 9 Sep 1998 14:47:34 -0600 (MDT) Received: from nestor.NMSU.Edu (nestor.NMSU.Edu [128.123.34.146]) by dns1.NMSU.Edu (8.9.0/8.9.0) with ESMTP id OAA17546 for ; Wed, 9 Sep 1998 14:46:23 -0600 (MDT) Received: from nbif16 (nbif16.NMSU.Edu [128.123.15.254]) by nestor.NMSU.Edu (8.8.6/8.7) with SMTP id OAA77612 for ; Wed, 9 Sep 1998 14:46:23 -0600 Message-ID: <35F6EBFA.4FC0@cs.nmsu.edu> Date: Wed, 09 Sep 1998 14:58:34 -0600 From: rhayhow Reply-To: rhayhow@cs.nmsu.edu Organization: National Biotechnology Information Facility X-Mailer: Mozilla 3.03Gold (WinNT; I) MIME-Version: 1.0 To: pgsql-interfaces@hub.org Subject: Getting embedded SQL to return html tables Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, Now that I have successfully compiled and run a C program with embedded SQL I am moving on to the next step of my project, getting the program to output html tables (my long term goal is to interface the embedded SQL with a CGI library to create a simple web/database interface). I have looked at the information on libpq and it seems possible that html output might be controlled by setting some PGOPTIONS. Sadly, I have not been able to find any documentation on what these options are or how to use them. None of the examples provided with the release use any PGOPTIONS. I am convinced that it is possible to get tables because I see that there is a 'html3' boolean variable in the libpq-fe.h (contained in the PQprintOpt structure). Any pointers and/or sample code would be a great help. Reid Hayhow