that worked thanks.
On Thursday, March 20, 2014 9:08:46 PM UTC-7, Jeremy Evans wrote:
>
> On Thursday, March 20, 2014 3:44:55 PM UTC-7, Hillary Hueter wrote:
>>
>> In order into insert into a table i need to be able to set the following
>> settings:
>>
>> SET QUOTED_IDENTIFIER ON
>>
>> SET ANSI_NULLS ON
>>
>> I've been looking through the documentation for both the sequel adaptor
>> and tinytds, but i don't see a way to set this either within the insert
>> statement or globally (preferred).
>>
>>
>>
> You want to do this in an after connect proc:
>
> DB = Sequel.connect(..., :after_connect=>lambda{|c| c.execute('SET QUOTED
> IDENTIFIER ON'); c.execute('SET ANSI_NULLS ON')})
>
> Thanks,
> 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.
