[Lvlug] Re: SQL question

[jab at fast.net]

Scott Ferguson <scottwferg at gmail.com> wrote:
> On 8/23/07, Faber J. Fedor <faber at linuxnj.com> wrote:
> >
> > Looks okay to me.  My guess is sq.symbol != sp.symbol, IOW, you might
> > have something like sq.symbol = 'ALU' and sp.symbol = 'ALU  ' or some
> > other nonprintable character.  Knowing how persnickety PostgreSQL can
> > be, that'd be the first place I look.
> >
> 
> I would agree with this.  The SQL query looks fine to me.
> 

Gents,

Fantastic, that was it: trailing spaces.

The Ruby script that populates the stock_quote table was
putting in the symbol right-padded to the field length with
spaces.

Time to test the updated script.

Thanks guys!
jim

btw, Faber:
  I haven't played with Google gadgets and this is more of a
  roll-your-own exercise that grew out of some http Ruby play.

  I did do some Google maps using their API. I seem to recall
  that merely required getting a key to embed in your HTML.

  Checking gadgets, it looks like you have to use their SDK to make
  your own gadgets ... but can you give a brief description of
  how you run them? I saw a couple financial oriented gadgets
  on their page, but the download for them was a binary file.
  Are they simply browser plugins?