From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: Roger Mason Newsgroups: gmane.emacs.help Subject: Re: sql-mode and LaTeX Date: Wed, 25 Feb 2004 16:49:22 -0330 Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Message-ID: References: NNTP-Posting-Host: deer.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1077740575 8051 80.91.224.253 (25 Feb 2004 20:22:55 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Wed, 25 Feb 2004 20:22:55 +0000 (UTC) Cc: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Wed Feb 25 21:22:39 2004 Return-path: Original-Received: from monty-python.gnu.org ([199.232.76.173]) by deer.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1Aw5YE-0003Yg-00 for ; Wed, 25 Feb 2004 21:22:39 +0100 Original-Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.30) id 1Aw5Xw-0006k6-K9 for geh-help-gnu-emacs@m.gmane.org; Wed, 25 Feb 2004 15:22:20 -0500 Original-Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.30) id 1Aw5Vl-0006JB-T9 for help-gnu-emacs@gnu.org; Wed, 25 Feb 2004 15:20:05 -0500 Original-Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.30) id 1Aw5VE-0006B2-7f for help-gnu-emacs@gnu.org; Wed, 25 Feb 2004 15:20:03 -0500 Original-Received: from [134.153.37.4] (helo=minnie.esd.mun.ca) by monty-python.gnu.org with esmtp (Exim 4.30) id 1Aw5V9-0006Af-0m for help-gnu-emacs@gnu.org; Wed, 25 Feb 2004 15:19:27 -0500 Original-Received: from minnie.esd.mun.ca (minnie.esd.mun.ca [134.153.37.4]) by minnie.esd.mun.ca (8.8.7/8.8.7) with ESMTP id QAA28708; Wed, 25 Feb 2004 16:49:23 -0330 Original-To: Joe Corneli In-Reply-To: (Joe Corneli's message of "Wed, 25 Feb 2004 11:33:51 -0600") User-Agent: Gnus/5.1002 (Gnus v5.10.2) Emacs/21.1 (gnu/linux) X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.2 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: main.gmane.org gmane.emacs.help:17217 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:17217 Joe Corneli writes: > What query were you talking about? I think you omitted that. I > don't know sql, but your code does sounds interesting. However it > is going to be too hard for me to help debug when I can't see it. This is the query (it was embeded in my original post): -- This outputs the preamble select'\\documentclass{article} \\title{GAC Budget 2004} \\author{Roger Mason \\\\ (with help from Karen Johnston \\& Karen Dawe)} \\usepackage{float} \\begin{document} \\maketitle\n'; Not a very interesting query perhaps, but a simple one that demonstrates the problem. It just outputs the preamble to a LaTeX document. I don't think there is anything wrong with the SQL statement itself. The issue is that RET is prepended to the first line of output, which contains table headings from the database. In an sql-mode buffer the RET is displayed as '^M' and the (first line of) output from the database follows. This is easy to clean up to leave behind only the SQL output. If the output is instead redirected to a buffer that is in LaTeX mode the RET is displayed as '...' and the output from the SQL query is lost - the line ends after '...'. I would like to be able to filter out the prepended RET so it never reaches the LaTeX buffer or, failing that, have it displayed in a form that preserves the SQL output and can be removed manually. I hope my question clearer now. Thanks for your interest. Roger