[TxMt] sql bundle and the keychain?

[tuesi]

I can select a query, execute the SQL and the Database Browser shows up.  But
from the Database Browser, if I click on "Next" to retrieve the subsequent
pages of records, I'm prompted for my password every time.  Also, if I click
on another table name or database name, it prompts me for the password.



In addition I get this error message...let me describe what I'm doing

(1) I highlight the following sql from a text file.

"SELECT
	geo_entities.short_code
FROM 
	geo_entities
"

(2) I "Execute the Selection as Query

(3) The Database Browser shows up with...
"
SELECT geo_entities.short_code FROM geo_entities

Records 1 to 10 Next »

short_code    
AFG
AKR
ALB
DZA
ASM
AND
AGO
AIA
ATG
ARG
"

(4) Then when I click on the Next link...I'm prompted for my password...I
enter it and then I get this error.  It seems that the newline character is
removed...

"SELECTgeo_entities.short_codeFROM geo_entities

#42000You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SELECTgeo_entities.short_codeFROM geo_entities LIMIT 10 OFFSET 10' at line
1"

So I try the same query...but this time w/o new lines...I highlight this and
I don't get the error.
"SELECT geo_entities.short_code FROM geo_entities"


-James



jcolson wrote:
> 
> I found a question on this posed in the dev mailing list, but am posting
> in
> the user mailing list, because it is now a user issue :-)
> 
> Any luck with this... I see the release notes mention using the keychain
> to
> store passwords, but I'm not sure how to go about doing this...
> 
> 
> 
> Brad Miller wrote:
>>
>> I've been trying to get the new browser to work.  But I get the following
>> error:
>>
>> ERROR 1045 (28000): Access denied for user 'bmiller'@'localhost' (using
>> password: NO)
>>
>> It looks like I should be prompted for a password? There is no place to
>> enter one in the configuration dialog.  I've searched  my keychain and
>> cannot find one.  Is there some variable I should be setting to tell the
>> SQL
>> bundle that I want to use a password?
>>
>> Brad
>>
>> --
>> Brad Miller
>> Assistant Professor, Computer Science
>> Luther College
>>
>> On 7/7/07, Ciarán Walsh <ciawal at gmail.com> wrote:
>>>
>>> Switching in new SQL bundle from WIP branch
>>>
>>> Changed:
>>> D   branches/WIP/Bundles/SQL.tmbundle/
>>> A   trunk/Bundles/SQL.tmbundle/
> 

-- 
View this message in context: http://www.nabble.com/sql-bundle-and-the-keychain--tf4043562.html#a11521931
Sent from the textmate users mailing list archive at Nabble.com.