Both of these work fine for me:
Marshal.load("\x04\b{\x10:\x0Epricedateu:\tTime\r\x04^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x06:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0")[:weekendday]
== 1
=> true
Marshal.load("\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0")[:weekendday]
== 1
=> true
On Fri, Sep 25, 2009 at 12:46 PM, David Jenkins <[email protected]> wrote:
>>Perhaps you can post the results of p(Marshal.dump(r)) for both cases:
>>with the select, and with the stored procedure.
> Here are the outputs (p(Marshal.dump(r)) of the last 4 recs from the stored
> proc:
> "\x04\b{\x10:\x0Epricedateu:\tTime\r\x04^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x06:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0"
> "\x04\b{\x10:\x0Epricedateu:\tTime\r$^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.319999694824201\x00\xFF\xFB:\x0Ehighpricef\x1A23.600000381469702\x00\xFF\xF9:\rlowpricef\x1823.2299995422363\x00\xFF\xF8:\x0Fclosepricef\n23.25:\vvolumei\x04\xD8\x1A\x88\x02:\x11openinteresti\x00"
> "\x04\b{\x10:\x0Epricedateu:\tTime\rD^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.290000915527301\x00\xFF\xF4:\x0Ehighpricef\x1A23.649999618530298\x00\x00\a:\rlowpricef\x1823.2700004577637\x00\x00\b:\x0Fclosepricef\x1A23.579999923706101\x00\x00\r:\vvolumei\x04P%Q\x02:\x11openinteresti\x00"
> "\x04\b{\x10:\x0Epricedateu:\tTime\rd^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\n23.25:\x0Ehighpricef\x1A23.719999313354499\x00\x00\x02:\rlowpricef\n23.25:\x0Fclosepricef\x1A23.649999618530298\x00\x00\a:\vvolumei\x040'~\x02:\x11openinteresti\x00"
>
> and here are the last 4 from the select
> "\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0"
> "\x04\b{\x11:\x0Epricedate0:\fholidayi\x00:\x0Fweekenddayi\x06:\rexchange0:\vsymbol0:\x13instrumenttype0:\x0Eopenprice0:\x0Ehighprice0:\rlowprice0:\x0Fcloseprice0:\vvolume0:\x11openinterest0"
> "\x04\b{\x11:\x0Epricedateu:\tTime\r$^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\rexchange\"\tNASD:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.319999694824201\x00\xFF\xFB:\x0Ehighpricef\x1A23.600000381469702\x00\xFF\xF9:\rlowpricef\x1823.2299995422363\x00\xFF\xF8:\x0Fclosepricef\n23.25:\vvolumei\x04\xD8\x1A\x88\x02:\x11openinteresti\x00"
> "\x04\b{\x11:\x0Epricedateu:\tTime\rD^\e\x80\x00\x00\x00\x00:\fholidayi\x00:\x0Fweekenddayi\x00:\rexchange\"\tNASD:\vsymbol\"\tMSFT:\x13instrumenttype\"\x06S:\x0Eopenpricef\x1A23.290000915527301\x00\xFF\xF4:\x0Ehighpricef\x1A23.649999618530298\x00\x00\a:\rlowpricef\x1823.2700004577637\x00\x00\b:\x0Fclosepricef\x1A23.579999923706101\x00\x00\r:\vvolumei\x04P%Q\x02:\x11openinteresti\x00"
>
> here's the stored proc:
> CREATE definer=`ro...@`localhost` PROCEDURE `GetInstRecs`(SYM varchar(28),
> INSTTYPE varchar(2))
> BEGIN
> declare FROMDATE date;
> declare TODATE date;
> call GetMinMaxDates(SYM,INSTTYPE, FROMDATE,TODATE );
> SELECT m.pricedate , m.holiday, m.weekendday, p.symbol, p.instrumenttype,
> p.openprice,
> p.highprice, p.lowprice, p.closeprice, p.volume, p.openinterest
> FROM masterdates m left join pricedata p
> on m.pricedate = p.pricedate and p.symbol = SYM and p.instrumenttype =
> INSTTYPE
> where m.pricedate >= FROMDATE and m.pricedate <= TODATE;
> END
> and here's how I call it:
>
> dataset = DB['call GetInstRecs(\'MSFT\', \'S\')']
>
>
> and here's the sequel select version
>
> dataset = DB[:masterdates].left_outer_join(:pricedata, :pricedate =>
> :pricedate, :symbol => 'MSFT', :instrumenttype =>
> 'S').filter('(masterdates.pricedate > ?) and (masterdates.pricedate < ?)',
> '2000-01-01', '2009-08-19')
>
> On Fri, Sep 25, 2009 at 3:27 PM, Aman Gupta <[email protected]>
> wrote:
>>
>> Perhaps you can post the results of p(Marshal.dump(r)) for both cases:
>> with the select, and with the stored procedure.
>>
>> Aman
>>
>> On Fri, Sep 25, 2009 at 12:19 PM, David Jenkins <[email protected]>
>> wrote:
>> > Hi, John
>> >
>> > Thanks for the suggestions. Using :holiday does the same thing, i.e., I
>> > can't use it in an "if" test. I also tried setting a variable,
>> > "some_var"
>> > to r[:weekendday], and sure enough it gets set to 0 or 1, and its class
>> > is
>> > Fixnum.
>> >
>> > Again, since this works with a select statement and not when I use a
>> > stored
>> > proc that returns a dataset, it seems to be a problem with the latter.
>> > I'm
>> > am trying to debug the sequel code in NetBeans 6.7, but I'm getting
>> > weird
>> > results: it keeps stopping on comment lines, as if the file it's showing
>> > is
>> > not the file it's running (and the file its actually running has actual
>> > non-comment code on those lines) -- the file in question being mysql.rb.
>> >
>> >
>> >
>> > On Fri, Sep 25, 2009 at 3:10 PM, John W Higgins <[email protected]>
>> > wrote:
>> >>
>> >>
>> >> On Fri, Sep 25, 2009 at 11:49 AM, David Jenkins <[email protected]>
>> >> wrote:
>> >>>
>> >>> tried p r[:weekendday].class, all Fixnum
>> >>> :(
>> >>
>> >> Try using :holiday instead - looks like the same semantics in terms of
>> >> data type but it might help figure out if it's a field issue or
>> >> something
>> >> else.
>> >>
>> >> Also try setting another variable with the value and then testing that
>> >> to
>> >> see if there is something else funky going on with the local
>> >> representation.
>> >> I would say at this point you're down to documenting every stage and
>> >> seeing
>> >> where this goes off track.
>> >>
>> >> Most times these types of things are nothing more then some weird
>> >> anomaly
>> >> but if you poke and prod around the issue sometimes you get the right
>> >> clue.
>> >>
>> >> Sorry I don't have a silver bullet - but sometimes the bullet companies
>> >> are on strike :)
>> >>
>> >> John
>> >>
>> >>
>> >
>> >
>> > >
>> >
>>
>>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
