From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Tim X Newsgroups: gmane.emacs.help Subject: Re: Multiple SQLi buffers? (Emacs 24.0, sql-mode 2.5) Date: Fri, 20 Aug 2010 08:30:25 +1000 Organization: Unlimited download news at news.astraweb.com Message-ID: <878w428cce.fsf@puma.rapttech.com.au> References: <19564.25666.578342.680542@wingspan.sea> <34D023B6-E61B-452A-9E64-9D66F4C860C7@Web.DE> <19565.20305.927733.952479@wingspan.sea> <17A10416-CA4D-4DF7-A49B-23DDE243307A@Web.DE> NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: dough.gmane.org 1291873833 24898 80.91.229.12 (9 Dec 2010 05:50:33 GMT) X-Complaints-To: usenet@dough.gmane.org NNTP-Posting-Date: Thu, 9 Dec 2010 05:50:33 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Dec 09 06:50:29 2010 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.69) (envelope-from ) id 1PQZOe-0004a9-5q for geh-help-gnu-emacs@m.gmane.org; Thu, 09 Dec 2010 06:50:28 +0100 Original-Received: from localhost ([127.0.0.1]:46980 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PQXig-0005Rs-V8 for geh-help-gnu-emacs@m.gmane.org; Wed, 08 Dec 2010 23:03:03 -0500 Original-Path: usenet.stanford.edu!news.glorb.com!news2.glorb.com!news.astraweb.com!border5.newsrouter.astraweb.com!not-for-mail Original-Newsgroups: gnu.emacs.help User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux) Cancel-Lock: sha1:rYy1n7JvHptHjY7uUneFzFihpyw= Original-Lines: 58 Original-NNTP-Posting-Host: 9181377a.news.astraweb.com Original-X-Trace: DXC=NH^hfP@dUXKOObP71A_HVDL?0kYOcDh@JW\:Hm@YlDbJR8J33anb9@Oe=SVZlF2L6DJN0Y[=Pej\O Original-Xref: usenet.stanford.edu gnu.emacs.help:180850 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:76761 Archived-At: Wayne S writes: > WS> I upgraded emacs 20.3 to 20.4 (from emacs.orebokech.com). I then > WS> ... > > Whoops! Make that emacs 23.x -> 24.0. Note that there has been a number of changes in the sql-mode bundled with emacs 24. In particular, MySQL connections can now use a port and hyou can define multiple connection 'names'. My guess would be that these changes have affected that old behavior. It could well be a bug or it could be that a different procedure is now required to do what you want. One way to work around the problem could be to define different connection names for connecting to the same database and see if that works. I would recommend logging a bug report. Either it is a bug or a new procedure has been adopted. In either case, logging the bug report will highlight the bug or a lack of clarity in documentation if a new procedure is now required. Check the NEWS file. In particular, *** Added ability to login with a port on MySQL. The custom variable `sql-port' can be specified for connection to MySQL servers. *** Added `sql-connection-alist' to record login parameter values. An alist for recording different username, database and server values. If there are multiple databases that you connect to the parameters needed can be stored in this alist. For example, the following might be set in the user's init.el: (setq sql-connection-alist '((dev (sql-product 'sqlite) (sql-database "/home/mmaug/dev.db")) (prd (sql-product 'oracle) (sql-user "mmaug") (sql-database "iprd2a")))) This defines two connections named "dev" and "prd". *** Added `sql-connect' to use predefined connections. Sets the login parameters based on the values in the `sql-connection-alist' and start a SQL interactive session. Any values specified in the connection will not be prompted for. In the example above, if the user were to invoke M-x sql-connect, they would be prompted for the connection. The user can respond with either "dev" or "prd". The "dev" connection would connect to the SQLite database without prompting; the "prd" connection would prompt for the users password and then connect to the Oracle database. -- tcross (at) rapttech dot com dot au