From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Brett Kelly Newsgroups: gmane.emacs.help Subject: Sql-Mode - getting query results from MS SQL Server 2000 Date: Wed, 15 Jun 2005 12:29:35 -0700 Message-ID: <20050615192935.GC14624@inkedmn.com> NNTP-Posting-Host: main.gmane.org Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1360037560==" X-Trace: sea.gmane.org 1118863898 29874 80.91.229.2 (15 Jun 2005 19:31:38 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Wed, 15 Jun 2005 19:31:38 +0000 (UTC) Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Wed Jun 15 21:31:32 2005 Return-path: Original-Received: from lists.gnu.org ([199.232.76.165]) by ciao.gmane.org with esmtp (Exim 4.43) id 1DidaZ-0002Nf-JV for geh-help-gnu-emacs@m.gmane.org; Wed, 15 Jun 2005 21:30:15 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Didfq-0002ap-3L for geh-help-gnu-emacs@m.gmane.org; Wed, 15 Jun 2005 15:35:42 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1DidfN-0002VZ-Jk for help-gnu-emacs@gnu.org; Wed, 15 Jun 2005 15:35:13 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1DidfF-0002SJ-GJ for help-gnu-emacs@gnu.org; Wed, 15 Jun 2005 15:35:05 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1DidfE-0002Pj-7w for help-gnu-emacs@gnu.org; Wed, 15 Jun 2005 15:35:04 -0400 Original-Received: from [68.168.78.202] (helo=mta10.adelphia.net) by monty-python.gnu.org with esmtp (Exim 4.34) id 1DidbY-0005CZ-Fw for help-gnu-emacs@gnu.org; Wed, 15 Jun 2005 15:31:16 -0400 Original-Received: from toulouse.inkedmn.com ([69.172.208.59]) by mta10.adelphia.net (InterMail vM.6.01.04.01 201-2131-118-101-20041129) with ESMTP id <20050615192937.WGDP17140.mta10.adelphia.net@toulouse.inkedmn.com> for ; Wed, 15 Jun 2005 15:29:37 -0400 Original-Received: from christian.inkedmn.com (christian.inkedmn.com [192.168.1.100]) by toulouse.inkedmn.com (Postfix) with ESMTP id F2E356E434 for ; Wed, 15 Jun 2005 12:15:47 -0700 (PDT) Original-Received: by christian.inkedmn.com (Postfix, from userid 1000) id 36DF34A63B; Wed, 15 Jun 2005 12:29:35 -0700 (PDT) Original-To: help-gnu-emacs@gnu.org User-Agent: Mutt/1.5.9i X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:27489 X-Report-Spam: http://spam.gmane.org/gmane.emacs.help:27489 --===============1360037560== Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="TRYliJ5NKNqkz5bu" Content-Disposition: inline --TRYliJ5NKNqkz5bu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hello All, Let me preface by saying that I'm pretty new to emacs, so I apologize in advance if I've missed something obvious. I'm using emacs 21.3.1 on windows xp professional. I've read the SqlMode page on the wiki as well as the sql-help from within emacs, but I still can't figure out how to do this. I'd like to be able to type in a sql query and have it return a resultset i= n a different buffer (a la Query Analyzer). Here's what I'm doing now: - Create a new buffer, do M-x sql-ms RET, then enter the relevant connection information (user, password, server, dbname). This gives me no errors. - Type in my SQL statement (I've tried simple "select" statements, as well = as more complicated "create proc" type stuff) - Highlight the relevant code with the mouse, and choose Send Region from t= he SQL menu. Now, if I'm understanding this correctly, I should see the results in a new buffer, but I'm not. Can anybody tell me what I'm doing wrong? Thanks! --=20 Brett Kelly inkedmn@inkedmn.com http://inkedmn.com:8000 GPG Public Key: http://inkedmn.com:8000/stuff/inkedmn.asc --TRYliJ5NKNqkz5bu Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFCsIGfoB4gV36UerERAtoCAJ0Zd4mTeGriD8hoIzfGirw3DfT5GACeMgcb VXkM2ncOvSkPPdnGt6ctYYA= =fIiV -----END PGP SIGNATURE----- --TRYliJ5NKNqkz5bu-- --===============1360037560== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Help-gnu-emacs mailing list Help-gnu-emacs@gnu.org http://lists.gnu.org/mailman/listinfo/help-gnu-emacs --===============1360037560==--