On Wednesday, September 24, 2014 9:38:46 PM UTC-7, henry beh wrote:
>
> My database is in different schema,
>
>
> previously i did like this, so the first connection is default, when i
> want to retrieve the data from database2, it always get it form default
> database , so it cause table not found error
> $database1 = Sequel.connect(:adapter=>'mysql2', :host=>'127.0.0.1',
> :database=>'database1 ', :user=>'root', :password=>'1234',
> :max_connections => 30,
> :logger => Logger.new('sequel-log.txt'))
>
> $database2= Sequel.connect(:adapter=>'mysql2', :host=>'127.0.0.1',
> :database=>'database2', :user=>'root', :password=>'1234',
> :max_connections => 30,
> :logger => Logger.new('sequel-log.txt'))
>
Well, other than using a global variable instead of a constant, this looks
fine. You'll have to post the code you are using to retrieve data and why
it isn't working as you suspect.
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
