I just realized that I can pass in a :server option to execute, so that
should solve my sharding problem, but I still can seem to get results back,
even from a simple select:
irb(main):003:0> DB.execute('select * from SomeTable', server: :config,
return: :each)
=> []
Any ideas?
On Monday, July 29, 2013 1:25:41 PM UTC-4, Trevor Little wrote:
>
> I'm having a little trouble getting this to work and I'm hoping you all
> can help me. We're using Sequel 3.44.0 with sharding and TinyTDS to
> interact with our MS SQL Server database. I can't figure out how I'm
> supposed to call stored procs. It seems like I'm going to have to do
> something like:
>
> result = DB.execute("EXEC proc_Name", return: :each)
>
> but I can't get that to work and I'm not sure how I would specify a shard
> name.
>
> I'd really appreciate any light you could shed. This is the first thing
> I've come across that looks pretty easy in AR but has me stumped in Sequel.
>
> Trevor
>
--
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/groups/opt_out.
