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:

Speeding up my [showif] performance (1999) Protect (1997) RE: AccountAuthorizer doesn't seem to work (1997) Where has WebDNA shown up in your life? (2003) Help! WebCat2 bug (1997) WC1.6 to WC2 date formatting (1997) The code, one more time. (2003) sandboxes with 6.0 (2004) Malformed Pages (1999) Removing [showif] makes a big difference in speed (1997) sort problems....bug or brain fart? (1997) [WebDNA] Using WebDNA with MAMP (2010) OT: Flash developer needed (2007) UPS QuickCost and More (2000) [decrypt seed=seed][getchars (1999) Need help with form (1998) RE: Cart Template (1997) ShipTotal Yet Again (1998) [shell]? (2000) CommandSecurity? (1997)