[Lvlug] Re: SQL question

[jab at fast.net]

"Faber J. Fedor" <faber at linuxnj.com> wrote:
> On 23/08/07 11:10 -0400, jab at fast.net wrote:
> > 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.
> 
> And that's why we get paid the big bucks. :-)
> 
> > btw, Faber:
> > 
> >   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?
> 
> No clue.  I was refering to the gadgets already there.  You log in and
> go to your customized Google page; they call it iGoogle now.  One of
> the gadgets you can add let's you enter your stock tickers, basis price
> and it shows you your gain/loss.
> -- 
>  
> Regards,
>  
> Faber Fedor

While not getting paid the big bucks, that's one reason to
engage in these do-it-youself tasks ... to try to keep nuances
like that fresh in the mind (the success of which is obvious).

Regarding iGoogle ... don't I recall a discussion here sometime
back about alternate search engines? Right about that time a
friend mentioned he'd switched to using dogpile.com. I did the
same.

Someone's still collecting your searches, but at least it's
spread around a bit. I don't know if I'd care to give Google
my stock portfolio (including the basis for each issue) info,
instead of just whipping something up that goes and collects the
prices, then does the remaining calcs locally.

jim

Actually this is for mom's portfolio, so maybe I should use the
Google gadget ... they might think I'm wealthier than I really
am.