Re: [WebDNA] reverse rank=off

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100401
interpreted = N
texte = How much trouble would it be to add an ID field at the end of the headers and put the numbers in? Or, (I did this just last week to an old site I'm revamping) open the DB in excel and add a column at the beginning. Under the Edit menu, choose Fill, then Series, and in the dialog box, choose column, and voila - all numbered. You might have to enter a 1 in the first cell first; I don't know. Then just add the new fieldname, replace the DB, closedatabases, and away you go. This also a good chance to reorder the fields and do other cleanup. The DB I altered had about 45,000 records and was a couple of MBs big. Terry >Hi all, > >In a search context you are able to set rank=off which can give a >result where the first record ever written in the DB gets first and >the last record ends out at the end. > >How can I reverse this? > >Unfortunately the DB in this scenario does not have a unique index... > > > > > > >Venlig hilsen > >Palle Bo Nielsen >(PowerPalle) > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] reverse rank=off (Terry Wilson 2008)
  2. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  3. Re: [WebDNA] reverse rank=off (Gary Krockover 2008)
  4. Re: [WebDNA] reverse rank=off (Donovan Brooke 2008)
  5. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  6. Re: [WebDNA] reverse rank=off (Toby Cox 2008)
  7. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  8. Re: [WebDNA] reverse rank=off (Toby Cox 2008)
  9. Re: [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
  10. Re: [WebDNA] reverse rank=off (Gary Krockover 2008)
  11. Re: [WebDNA] reverse rank=off (Terry Wilson 2008)
  12. Re: [WebDNA] reverse rank=off (Donovan Brooke 2008)
  13. [WebDNA] reverse rank=off (Palle Bo Nielsen 2008)
How much trouble would it be to add an ID field at the end of the headers and put the numbers in? Or, (I did this just last week to an old site I'm revamping) open the DB in excel and add a column at the beginning. Under the Edit menu, choose Fill, then Series, and in the dialog box, choose column, and voila - all numbered. You might have to enter a 1 in the first cell first; I don't know. Then just add the new fieldname, replace the DB, closedatabases, and away you go. This also a good chance to reorder the fields and do other cleanup. The DB I altered had about 45,000 records and was a couple of MBs big. Terry >Hi all, > >In a search context you are able to set rank=off which can give a >result where the first record ever written in the DB gets first and >the last record ends out at the end. > >How can I reverse this? > >Unfortunately the DB in this scenario does not have a unique index... > > > > > > >Venlig hilsen > >Palle Bo Nielsen >(PowerPalle) > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. Terry Wilson

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:

plugin-acgi, different results (1997) Announcement-WebCatalog 2.0 Released (1997) [LOOKUP] (1997) minimalist shopping cart. (1997) listfiles-looking for slick solution (1997) displaying New products (using [date]) (1997) update on wn searching (1997) [subtotal] and others (1997) emailer settings and control questions (1997) Problems with webcat 2.01 for NT (1997) Listwords and the & (2001) [WebDNA] HMAC-SHA1 Encryption (2013) Anyone Using 4DMail (2004) Dummy Credit Card Number for debug? (1997) New commands in Final candidate (1997) Doing VALIDCARD right? (1998) Re[2]: 2nd WebCatalog2 Feature Request (1996) E-Mailer (WebCatb15acgiMac) (1997) X etc.... (1999) Bug in WC 4.02 on RH Linux with Append (2002)