Searches not returning correct results

Chuck Neal chuck at mediamacros.com
Fri Mar 31 15:59:06 CST 2006


Do you mean the single/double quotes are the problem?  This does not 
work in Studio.

I finally did an export and was able to get a clean import that now 
works in Director but Studio still returns invalid results

I have not been able to identify exactly why but it seems that in 
programming, over time stops and starts cause bad data in the database. 
  Often this shows with it thinking there are supposed to be more 
records than there are. Enough of these and it gets unstable and 
corrupted.  Not fun...

-Chuck
--------------------------
Chuck Neal
CEO, MediaMacros, Inc.
chuck at mediamacros.com
http://www.mediamacros.com
http://www.mediamacros.net


Ivan Smahin wrote:
> 
> On Mar 31, 2006, at 11:10 PM, Chuck Neal wrote:
> 
>> I have a program that started acting up.  I traced it down to the 
>> SELECT searches not returning the correct results.  Here is an example...
>>
>> SELECT * FROM Technique_Option WHERE option = "I2G8L5-11Q5GIK-T47Q0I-2T"
>>
> 
> But it seems the query should be next:
> 
> SELECT * FROM Technique_Option WHERE option = 'I2G8L5-11Q5GIK-T47Q0I-2T'
> 
> 
> 
> 
> Best regards
> Ivan Smahin
> 
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 


More information about the Valentina mailing list