Re: Is there a way to just get to the last record in the database?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12962
interpreted = N
texte = >Is there any construct in webcat that allows you to get access to the >last record of the database, other than by sorting in order to append a >new record based upon the last record?I believe you can use startAt=15&max=1 to get the 15th record of whatever the current sort is. Set rank=off to turn sorting off entirely (to get records in the order they are physically stored in the database file).[NumFound] gives you the total number of found records, but be careful that your preference for maximum number of records returned is set high enough, otherwise all search results will be capped at that number.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Is there a way to just get to the last record in the database? (Grant Hulbert 1997)
  2. Is there a way to just get to the last record in the database? (w curt eggemeyer 1997)
>Is there any construct in webcat that allows you to get access to the >last record of the database, other than by sorting in order to append a >new record based upon the last record?I believe you can use startAt=15&max=1 to get the 15th record of whatever the current sort is. Set rank=off to turn sorting off entirely (to get records in the order they are physically stored in the database file).[NumFound] gives you the total number of found records, but be careful that your preference for maximum number of records returned is set high enough, otherwise all search results will be capped at that number.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

Upgrading old WebCat Database Files (1997) WebCat2final1 crashes (1997) problems with 2 tags shakur (1997) Forms Search Questions (1997) remove line item (2000) WCS Newbie question (1997) Referring URL (1998) 9 digit zip (2002) re:check boxes (1997) WebCat2 beta 11 - new prefs ... (1997) interesting Unix bug (2000) # fields limited? (1997) Paths relative to root not working (2000) Replace context problem ... and answers (1997) WebCat2 - [format thousands] (1997) aol not showing cart (1998) Loss in form (1998) founditems / writefile (2005) sorting dates (1999) Thanks Grant (1997)