Following up on a post from a week or so ago, I've created a "mysql"
snippet to run MySQL commands within TM. (This probably works best if
you have a ~/usr/.my.cnf file configured with a default login and
password on localhost.)
The snippet simply is the following: /usr/local/mysql/bin/mysql
${1:database} -e "${2:SELECT}"
... so I hit mysql, tab, then enter the DB name and then the command.
Some sample queries are appended below.
My problem is that the output begins directly after the final " in the
-e statement. What's the easiest way to insert a carriage return here?
Or is this better run as a command and not a snippet?
I've already got macros to convert DESCRIBE TABLE output into all sorts
of PHP elements... TM is great :)
Paul
> /usr/local/mysql/bin/mysql iedb -e "show tables"
> Tables_in_iedb
> clients
> firms
> iedbdata
> irt_metadata
> metadata
> sections
> stock
> /usr/local/mysql/bin/mysql iedb -e "describe
> metadata"Field Type Null Key Default Extra
> field_id int(11) PRI NULL auto_increment
> section_id int(2) YES NULL
> category varchar(100) YES NULL
> subcategory varchar(100) YES NULL
> section varchar(100) YES NULL
> subsection varchar(100) YES NULL
> field varchar(255) YES NULL
> descr tinytext YES NULL
> type varchar(100) YES NULL
> avail varchar(100) YES NULL
> comments text YES NULL
> fieldcode varchar(100) YES NULL
> /usr/local/mysql/bin/mysql iedb -e "select * from
> clients"clno fname lname job account_balance
> 10 sam smith auditor 5525.75
> 20 james jones manager 8960.25
Just downloaded the new beta to see what everyone was talking about,
but ctrl-s does nothing for me (no line in status bar, and if i hit
ctrl-s then start typing, it is just inserted as text). Going to
Textmate->About shows that I am definitely using 1.0.2b8....is there
something that I am doing wrong?
ben
I was wondering if it would be possible to not have the page scroll when a
string being searched for is found on the currently visible page.
I find that when this happens it causes me to think that the found string is
outside of the visible region and so I try to locate it's context within the
document. Somethings it's only 10 lines away but it may not be obvious
because my mental map of the document is disrupted.
Many other apps do not normally scroll if the found string is within the
visible region.
Thanks,
Ed Wong
I just downloaded the new beta...
Allan and team, I have to say I am growing more and more impressed with every release. Amazing work.
=====
http://www.velodev.com/
Hi,
Just a small request: please provide a feedback menu when dragging
seperate files into a project that are masked by the default file pattern?
I was trying to drag a file beginning with . into a project and it didn't
work, nothing happened. It's that I know of the existence of the default
file mask that I understood what happened, but other users might not know
about this...
Jeroen.
The new beta looks *very* nice. The preferences and menu
reorganization are great, and the incremental-search is oh-so-great!
Keep up the good work, Macromateys!
--
__ ____
/ / / __/ Brian Lalor
/ _ \/__ \ blalor(a)bravo5.org
/_.__/____/ http://bravo5.org/
Downloaded, installed. I do C-s and get nothing.
I have a heavily-remapped keyboard (and a MS Wireless one, at that), but resetting it to the defaults produced no changes. I scrolled through the menus, and saw no conflicting commands, and checked my MenuMaster config for conflicts.
Anyone else seeing this?
According to Ollivier Robert:
> > Very minor nit, when one select the Preferences menu, no tab is selected
> > and the window is bare till one tab is selected.
>Weird: hitting ctrl-s doesn't do anything here :(
I have the same problem: I don't get anything in the status bar
(using a British keymap)
--
Jackie Chappell
jmchappell(a)mac.com
Fugu with TextMate is fab; I'm using it now in preference to Cyberduck.
The new beta is amazing!
> Added incremental search. Press ctrl-s to open a text field on top of
> the status bar. When you enter something in this text field it will
> immediately try to find it in the text. Press escape, tab, return, or
> enter when you're done. The search is case sensitive if the string
> entered is in mixed case, otherwise it's case insensitive. The search
> will wrap around, and it will start from the caret. It's a forward
> search, use ctrl-S to make it a backwards search. While the text field
> is up, you can press ctrl-s to go to the next match or ctrl-S for the
> previous match.
cool! I can't believe how fast this is progressing... And the new Prefs!
cheers, Allan!
Paul
Allan wrote:
> TextMate v1.0.2b8 (2004-12-01) ==============================
>
> Added \U and \L escape codes to the (regex) format string. Everything
> following these escape codes to the next \E escape code will be converted
> to upper- or lowercase.
Great! All our dreams come true: we asked for it and we got it!
Thanks a lot,
--
Jo <W:00°04'37" ; N:47°15'36">
1....'....12.....'....24.....'....36.....'....48.....'....60.....'....72
