[ic] $db-->query inner join

Sam Batschelet sam at westbranchresort.com
Tue Mar 10 16:38:35 UTC 2009




On 3/10/09 10:05 AM, "Gert van der Spoel" <gert at 3edge.com> wrote:

> 
> -  and variants.sku="$sku"   perhaps ... because sku I expect is not a
> number, but a string
> -  if your site is based on the demo, then I expect this to not be returning
> too much as the variants.code in that case never matches an inventory.sku
> unless you did it differently ...  in the demo the variant.sku and the
> inventory.sku are the ones that are equal ...
> 
> CU,
> 
> Gert
> 
Hi Gert
Tried "$sku" and your right $sku is a string but in my setup the two fields
do match.






More information about the interchange-users mailing list