----- Original Message -----
From: "Miles Thompson" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, July 09, 2006 8:10 PM
Subject: Re: How to look for balanced parenthesis?
At 03:48 PM 7/9/2006, Rhino wrote:
----- Original Message ----- From: "mos" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Sunday, July 09, 2006 1:35 PM
Subject: How to look for balanced parenthesis?
I have a complicated SQL statement with around a dozen
"if(this,val1,val2)" embedded in it and there are even nested If clauses.
I'm getting syntax errors because I'm not balancing the "( )" properly.
Is there any free software out there for Windows that I can copy and
paste the SQL statement into that will show me where the parenthesis are
unbalanced? It doesn't have to know about SQL, I just to either highlight
the parenthesis range or find out when the parenthesis become out of
sync.
I'm going to give you one answer that you almost certainly won't like:
Eclipse. Eclipse is an IDE for developing programs, especially Java, and
it has a parenthesis matcher which also handles braces and square
brackets. Installing Eclipse solely for the bracket matcher is a bit like
using atomic weapons to kill mosquitos but if you were going to develop
applications anyway and wanted a great IDE, it might be the answer to your
problem. It's free by the way. You can get it at http://eclipse.org.
Another editor that can also match brackets is PFE, Programmer's File
Editor. It's also free and is a good editor. You can find it many places,
including http://www.lancs.ac.uk/staff/steveb/cpaap/pfe/pfefiles.htm. It
only runs on Windows though.
Another decent little editor that has the feature is TextPad. It's also
free and can be found at http://www.textpad.com/.
There are probably more basic editors out there that have bracket matchers
but I can't name any for you. I'm not even sure what the feature you want
is supposed to be called: "bracket matcher", "parenthesis balancer", or
whatever. It's getting to be a pretty standard feature in editors in
recent years, although it doesn't seem to be in NotePad or WordPad.
--
Rhino
Rhino,
Eclipse can't edit files on the server, can it?
I used to use UltraEdit, but then switched to EditPlus because it can edit
remote files almost transparently. (Opening a file FTP's it down, you edit
local copy, Saving FTP's it back.)
I really don't know if Eclipse can edit files on a server. My workspace is
on my local PC so I've never tried editing a file on a server.
I can certainly see that it would be convenient to be able to edit a file on
a server without having to manually transfer the file back and forth! But
Eclipse is pretty smart so I'd be a little surprised if they forced you to
transfer the file manually.
--
Rhino
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.9/382 - Release Date: 2006-07-04
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
