Random Sort Problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52878
interpreted = N
texte = Hi For some reason this is not working and I can't think why. All I want is to search a db for all the records that have MOREDETAIL=T and return one random record. What am I doing wrong? (This is all in one line in case the email splits it) [search db=Admin/People.db&eqMOREDETAILdatarq=T&SURNAMEsort=1&SURNAMEdir=ra&max=1] I am always getting the same record returned. If I increase the max number I get the 4 records that correctly have T in the MOREDETAIL field but there always sorted in the same order. Any help much appreciated - OSX 10.2.6 with WC 5.0.0 and iTools7 Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Random Sort Problem ( Steve Craig 2003)
  2. Re: Random Sort Problem ( Donovan 2003)
  3. Random Sort Problem ( Steve Craig 2003)
Hi For some reason this is not working and I can't think why. All I want is to search a db for all the records that have MOREDETAIL=T and return one random record. What am I doing wrong? (This is all in one line in case the email splits it) [search db=Admin/People.db&eqMOREDETAILdatarq=T&SURNAMEsort=1&SURNAMEdir=ra&max=1] I am always getting the same record returned. If I increase the max number I get the 4 records that correctly have T in the MOREDETAIL field but there always sorted in the same order. Any help much appreciated - OSX 10.2.6 with WC 5.0.0 and iTools7 Cheers ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1224 642960 Fax +44 1224 642962 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com ======================================== ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Steve Craig

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:

WebCat2: Items xx to xx shown, etc. (1997) Can someone help? (2000) lookup and two records? (1997) Text data with spaces in them... (1997) syntax question, not in online refernce (1997) Listserver problem (1997) Append again (1999) [OT] Bad Cookie / Internet Option / Internet Explorer (2004) [LOOKUP] (1997) Email notification to one of multiple vendors ? (1997) Extra Text Fields (was Another question) (1997) OS X and Emailer (2002) Sitebuilder (2004) WebCat and WebTV (1997) Shopping Cart Deletion (2000) info (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Searching for all records (1998) searchable list archive (1997) showif with math? (2000)