jj!
While at this, could you try to explain to me how the search system of FreeTrade
works. I know I asked this before, and I know you did answar, but I do not understand
. Maybe if take it slow and step by step? Please?
Bjarne
----- Original Message -----
From: Shannon -jj Behrens <[EMAIL PROTECTED]>
To: FreeTrade <[EMAIL PROTECTED]>
Sent: Saturday, August 12, 2000 3:06 AM
Subject: Re: [FreeTrade] How to get search results to show more info
> > I am trying to get the search results to alos show the price of an itme. I
> > don't want people to search by price, but I want them to see the price in
> > the results. I have worked at the code all afternoon and the best I can get
> > is that the item display multiple times but no prices.
>
> Prices are associated with SKUs, whereas the search results is concerned
> with items. Hence, if you get a successful search result, it is for an
> item, which may contain multiple SKUs each of a different price. If
> this is is okay by you, you should change the query that gets the items
> from the database so that it does a JOIN with the SKU table so that it
> can get the prices associated with each SKU in the item. Hence, the
> query might look something like, "SELECT i.ID, s.ID, i.Name, s.Name,
> s.ListPrice, s.SalePrice, i.Description, i.Thumbnail, i.Keywords FROM
> item i, sku s WHERE Active = 'Y' AND s.Item=i.ID ORDER BY
> i.DisplayPrecedence, s.DisplayPrecedence, i.Name, s.Name".
>
> Hope that helps. It was a good question.
>
> -jj
>
> --
> if (shannon - jj) * behrens == webEngineer["CLEAR INK�"]:
> print "<i>imagination is the only real medium(sm)</i><br>"
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
