Re: random sorting broken (was Re: Re[2]: php vs WebCatalog)

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27159
interpreted = N
texte = >[Search db=Greetings.db&negreetingdata=nada&greetingsort=1&greetingsdir=ra&max=1] > [FoundItems][interpret][greeting][/interpret][/FoundItems][/Search] > >where the Greeting.db has only one field (named greeting) with records like- >hello [username]...¬ >(no record's field is equal to nada) > >But I find that I can force reload the page repeatedly (like 100 times over 5 different >days) and only get one of >2 greetings returned out of 12 possible. I NEVER get the other records returned - EVER! >(not in weeks of testing.) >That seems much more broken than simply not very random to me. You guys think my code >is done correctly? How can I improve it while still using the random function?I put together a quick test page and database identical to yours. The only difference is that I added the ALLHIT=1 parameter to the search. Although this isn't really necessary in this instance, in general, you should add it to searches like this. Remember, sorting only happens among results with the SAME hitcount (the hitcount is what is use to determine the automatic best result ranking for a given search).You can hit the test page and see the results for yourself at:http://search.smithmicro.com/random.tplNote that the page does 1000 searches so it may take a few seconds to come up.John.--------------------------------- John A. Hill Smith Micro Software Internet Solutions Division eCommerce / Consulting / Hosting http://www.smithmicro.com (formerly Pacific Coast Software)------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
>[Search db=Greetings.db&negreetingdata=nada&greetingsort=1&greetingsdir=ra&max=1] > [founditems][interpret][greeting][/interpret][/FoundItems][/Search] > >where the Greeting.db has only one field (named greeting) with records like- >hello [username]...¬ >(no record's field is equal to nada) > >But I find that I can force reload the page repeatedly (like 100 times over 5 different >days) and only get one of >2 greetings returned out of 12 possible. I NEVER get the other records returned - EVER! >(not in weeks of testing.) >That seems much more broken than simply not very random to me. You guys think my code >is done correctly? How can I improve it while still using the random function?I put together a quick test page and database identical to yours. The only difference is that I added the ALLHIT=1 parameter to the search. Although this isn't really necessary in this instance, in general, you should add it to searches like this. Remember, sorting only happens among results with the SAME hitcount (the hitcount is what is use to determine the automatic best result ranking for a given search).You can hit the test page and see the results for yourself at:http://search.smithmicro.com/random.tplNote that the page does 1000 searches so it may take a few seconds to come up.John.--------------------------------- John A. Hill Smith Micro Software Internet Solutions Division eCommerce / Consulting / Hosting http://www.smithmicro.com (formerly Pacific Coast Software)------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to John Hill

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Mac OS X ODBC (2002) Encrypt question. (2000) [WebDNA] Strange error (2014) Job Hunting (1999) corrupted jpgs (2003) Textarea Breaks (2000) [WebDNA] math date issues? (2013) WebCatalog for LinuxPPC/SusePPC? (2000) no template caching (1997) WebCatalog for Postcards ? (1997) Emailer file formats (1998) Redirect frame targets (1998) [searchString] (1997) PSC recommends what date format yr 2000??? (1997) WebCat2b15MacPlugin - [protect] (1997) new PurgeDatabase command? (was NT vs Mac) (1997) WebCat2_Mac RETURNs in .db (1997) [WebDNA] mod_WebDNA_apache2.2.so: mach-0, but wrong architecture (2010) textarea input (2002) matching shipto and others (1998)