Hello Mathew,
You can find the command by opening your Bundle Editor (Bundles>Bundle Editor>Show Bundle Editor or by ⌃⌥⌘B) and navigate to SQL>Database Browser there just change the command
from: db_browser.rb to: db_browser.rb --rows 50
This should work.
Regards, Alex
On Jan 19, 2008, at 12:12 AM, mathew wrote:
thank you alex, but i don't actually understand how to do that, i'm not familiar with how the bundles work
can you please explain to me what you mean?
thank you for your help
mathew
On 19/01/2008, at 2:32 AM, Alex Podaras wrote:
Hello Mathew,
I haven' t tried the following but it should work, try changing the command for Database Browser to something like:
db_browser.rb --rows 50
this will probably solve your problem.
Regards, Alex
On Jan 18, 2008, at 3:55 PM, mathew wrote:
Hello,
when i use the sql bundle to create a mysql view such as the following:
CREATE VIEW cp_qry_offset AS select O.offset_id, O.account_id, O.calculation_id O.quantity, O.type,
T.description as type_descriptionfrom cp_offset O
join cp_offset_type T on O.type = T.type_id
for reasons unknown to me, but suspiciously related to the sql bundle's habit of returning 10 rows of a select at a time in the database browser, it seems the bundle is appending:
limit 0,10to the view definition.
which means i then have to edit the view with another tool to remove this limit before it will work
do you know why that is happening?
i'm guessing its related to this in db_browser.rb in the sql bundle, but i don't know how to change it
if not query=~ /\bLIMIT\b/i and run_query =~ /\s*SELECT/i run_query << ' LIMIT %d OFFSET %d' % [@page_size, offset] @limited = false end
can anyone help?
thanks mathew
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate