What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: Sorting error

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13462
interpreted = N
texte = Just for clarity it might be good to prepend as (ascending) to the YRsort, MTHsort, DYsort (asYRsort etc.) so the direction is clear. Second, in addition to viewing the titles, view the YR, MTH, DY fields with each record - how are they sorted? Your WebDNA looks fine.John.>I have yet *another* problem, this one with sorting my search results. > >For the sake of simplicity (and trying to isolate any errors), I've created >a small database with 5 fields (sku, title, mth, day, yr) and 12 records >(all of which have titles that start with Will to Power, like Will to >Power #1, Will to Power #2, etc.). MTH, DAY, and YR are all numeric >values that, when sorted by YR, then MTH, then DAY in Excel, give me the >order that I want (Will To Power #1 first, Will to Power #12 last). > >When I sort the same way using WebCat (below), I get a seemingly random >order (#6, #8, #5, #9, ...) The sorted order doesn't even match the order >of records in the database. > >[SEARCH >db=DB/Test.db&bwtitledata=Will&allhit=1&YRsort=1&MTHsort=2&DAYsort=3&YRtype=num >& >MTHtype=num&DAYtype=num] >[FOUNDITEMS] >[TITLE] ([MTH]/[DAY]/[YR])
>[/FOUNDITEMS] >[/SEARCH] > >Is this a bug, or have I misread the docs? > >Michael > >Michael Winston *By Phone!: (503)/652/8815 x341 >Internet Coordinator *By e-mail!: michaelw@dhorse.com >Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ John A. Hill Pacific Coast Software 11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT * San Diego, CA 92128 http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting error (John Hill 1997)
  2. Re: Sorting error (Kenneth Grome 1997)
  3. Re: Sorting error (Michael Winston 1997)
  4. RE: Sorting error (Marc Eagle 1997)
  5. Re: Sorting error (Michael Winston 1997)
  6. Re: Sorting error (Michael Winston 1997)
  7. Re: Sorting error (John Hill 1997)
  8. Sorting error (Michael Winston 1997)
  9. Re: Sorting error (Kenneth Grome 1997)
  10. Re: Sorting error (Kenneth Grome 1997)
  11. Re: Sorting error (John Hill 1997)
Just for clarity it might be good to prepend as (ascending) to the YRsort, MTHsort, DYsort (asYRsort etc.) so the direction is clear. Second, in addition to viewing the titles, view the YR, MTH, DY fields with each record - how are they sorted? Your WebDNA looks fine.John.>I have yet *another* problem, this one with sorting my search results. > >For the sake of simplicity (and trying to isolate any errors), I've created >a small database with 5 fields (sku, title, mth, day, yr) and 12 records >(all of which have titles that start with Will to Power, like Will to >Power #1, Will to Power #2, etc.). MTH, DAY, and YR are all numeric >values that, when sorted by YR, then MTH, then DAY in Excel, give me the >order that I want (Will To Power #1 first, Will to Power #12 last). > >When I sort the same way using WebCat (below), I get a seemingly random >order (#6, #8, #5, #9, ...) The sorted order doesn't even match the order >of records in the database. > >[SEARCH >db=DB/Test.db&bwtitledata=Will&allhit=1&YRsort=1&MTHsort=2&DAYsort=3&YRtype=num >& >MTHtype=num&DAYtype=num] >[founditems] >[TITLE] ([MTH]/[DAY]/[YR])
>[/FOUNDITEMS] >[/SEARCH] > >Is this a bug, or have I misread the docs? > >Michael > >Michael Winston *By Phone!: (503)/652/8815 x341 >Internet Coordinator *By e-mail!: michaelw@dhorse.com >Dark Horse Comics, Inc. *By web!: http://www.dhorse.com/ John A. Hill Pacific Coast Software 11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT * San Diego, CA 92128 http://www.smithmicro.com 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:

serial number generation (1997) HELP WITH DATES (1997) Nesting format tags (1997) Firesite and [referrer] atg broke (1997) Summing fields (1997) Execute Applescript (1997) [date format] w/in sendmail (1997) [WebDNA] WebDNA 7.1 (2012) PSC recommends what date format yr 2000??? (1997) Browser Info.txt (1997) Custom buttons using site builder (2005) Next (1997) Webcatalog, Webstar and Crasharama (1999) Help! WebCat2 bug (1997) [Webcat 2]Next (1997) HomePage Caution (1997) A Global Variable (1997) Looking For WebCatalog Migration Assistance (2003) WebCat2b15MacPlugin - showing [math] (1997) Request for page test (2003)