Am Sonntag, 12. Januar 2020 20:43:51 UTC+1 schrieb Jeremy Evans:
>
> On Sunday, January 12, 2020 at 2:25:10 AM UTC-8, Bernhard Weichel wrote:
>>
>> Hi
>>
>> I have an application running with ruby 1.93 and sequel 4.18.0. I have 
>> statements like
>>
>> ogdb.projectcategorys.where('Zuordnungssperre = FALSE')
>>
>> No we want to upgrade the application to Ruby 2.6 and squel 5.28 the 
>> statement now throws:
>>
>
> First upgrade to Sequel 4.49.0.  Then fix all of the deprecation 
> warnings.  Then upgrade to Sequel 5.28.0.
>

ok I will try this.
 

>
> The particular case you are running into is that you can no longer pass 
> normal Ruby strings as filter expressions as it makes it easy to introduce 
> security issues. You can use the auto_literal_strings extension that ships 
> with Sequel if you want to keep using the old behavior.
>
> Thanks,
>


I also tried to wrap the literal expression with Sequel.lit() but it did 
not work either. 

Nevertheless I tried with  4.49.0.

there It breaks with the statement

      visibility_rec   = ogdb.person_category().where(:"Personen-Nr" => 
rec[:"Nr"]).all

which eventually trhows

P:/OptigemBridge/tools_26/Ruby26-x86/lib/ruby/gems/2.6.0/gems/sequel-4.49.0/lib/sequel/adapters/ado.rb:166:in
 
`method_missing': (in OLE method `Execute': ) (WIN32OLERuntimeError)
    OLE error code:80040E14 in Microsoft JET Database Engine
      Interner Fehler bei OLE-Automatisierung
    HRESULT error code:0x80020009




Jeremy
>

Th 

-- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/c24b745a-5876-4de3-8a54-ee0ef86cf0b3%40googlegroups.com.

Reply via email to