Cliff, The difficulty is that the new version introduced a completely and much more friendly way to maintain configuration information like your database username, password, and the database you want to use. The new version also has a completely re-written interface to the table browser, which is now used for executing queries as well. If you want a quick and dirty work-around for yourself You can use the bundle editor to create your own command: Set up the command in your own personal bundle as follows: Save: Current File (or Nothing if you prefer) Commands: mysql --html --user=<your username> --password=<yourpassword> --database=<yourdatabase> Input: Selected Text or Document Output: Show as html Assign a key equivalent like cmd-R Scope selector: source.sql Now if you are in a sql file and hit cmd-R with nothing selected the entire file will be piped to mysql and the results will appear as an html table. If you do the same thing, but with several queries selected then only the selected queries will be piped to mysql. Hope that helps people until a permanent solution within the SQL bundle is found. Brad -- Brad Miller Assistant Professor, Computer Science Luther College <div>On 7/16/07, Cliff Pruitt <<a href="mailto:lists.cpruitt@cliffpruitt.com">lists.cpruitt@cliffpruitt.com</a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> I'm a little confused (not using the bundle much). If it's working in an older version of the bundle, can't you simply re-name the old version of the command and re-introduce it to the bundle (either officially or as a user change) with the new name? Is there something else about the current version Bundle that would break the old command? - Cliff On Jul 16, 2007, at 3:41 PM, Allan Odgaard wrote: > On 16. Jul 2007, at 11:14, Jeremy Keen wrote: > >> Shame. I NEED multi-line SQL Execution. I will be sticking with a >> previous version of TM then. >> >> I can't see how the issue of SQL injection matters though... > > I am parroting Ciarán here, but the problem with injection is when > a string is taken from the user and just inserted into a query. > E.g. SELECT * FROM table WHERE text = "$string" -- here the user > would ensure that $string starts with "; and if multi-line queries > is supported, can basically do whatever SQL command he desires. > > It seems rather brutal to just cut-off the ability to do multi-line > queries in the MySQL API, but apparently that's what they decided. > >> Anyone got a work-around? Can I use the SQL bundle from a previous >> version in the latest version? > > That should work, I think r7187 is the last revision prior to the > change. So use the following command to checkout that bundle: > > svn co <a href="http://macromates.com/svn/Bundles/trunk/Bundles/">http://macromates.com/svn/Bundles/trunk/Bundles/</a> > SQL.tmbundle@7187 > > There's a lot of people who do want the multi-line query > functionality back, and I used it as well, so presumably a solution > will be found, but for now there is the old bundle for those who > want it now. > > > ______________________________________________________________________ > For new threads USE THIS: <a href="mailto:textmate@lists.macromates.com">textmate@lists.macromates.com </a> > (threading gets destroyed and the universe will collapse if you don't) > <a href="http://lists.macromates.com/mailman/listinfo/textmate">http://lists.macromates.com/mailman/listinfo/textmate</a> ______________________________________________________________________ For new threads USE THIS: <a href="mailto:textmate@lists.macromates.com">textmate@lists.macromates.com</a> (threading gets destroyed and the universe will collapse if you don't) <a href="http://lists.macromates.com/mailman/listinfo/textmate">http://lists.macromates.com/mailman/listinfo/textmate</a> </blockquote></div>