Query giving unexpected results.

[Bill Numerick]

Should I send it to you directly?   

Here's a question because there are several different queries similar
to this through out the app would it be worth it to use the 2 beta
instead?  Would you guys even allow distribution of a cd with the
beta?  I guess would be a good question too. :)

Thanks again Ruslan


On Fri, 10 Sep 2004 19:35:01 +0300, Ruslan Zasukhin
<sunshine at public.kherson.ua> wrote:
> On 9/10/04 7:26 PM, "Bill Numerick" <bnumerick at gmail.com> wrote:
> 
> > Thanks for the reply Ruslan.
> >
> > Ok I changed the query like you suggested and its returning even more
> > results than before.  It looks like its not taking the
> > optional_feature.of_type = 'Exteriors' .  Here's the full query with
> > the from this time ;).
> >
> > SELECT optional_feature.id,
> > optional_feature.name,model_optional_feature.msrp,model_optional_feature.paren
> > t_id
> > FROM model, optional_feature, model_optional_feature WHERE   (model.id
> > = model_optional_feature.model_id AND
> > model_optional_feature.optional_feature_id = optional_feature.id) AND
> > (model.id = '59' AND optional_feature.of_type = 'Exteriors' AND NOT
> > optional_feature.id in (16,17,18,20,21,56,99,163,203,204,242) ) ORDER
> > BY optional_feature.name ASC
> 
> Well, I need db, and I will test in in viSQL or in VStudio.
> 
> 
> > So are you saying 2 isn't as picky? :).
> 
> Yes, in 2.0 we have resolve this problem.
> 
> 
> 
> --
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
> 
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>