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:

[showif] problem (1999) WebDNA 5 & iTools 7 (2003) RE: new cart IDs being assigned somehow (1997) Authenticate (2000) Great product and great job ! (1997) 4.5.1 upgrade fee (2003) Some Questions (1997) [WebDNA] encoding with webdna/JS, in context of various file encodings/charsets (2010) Multiple Search Fields (1998) Need help with emailer- 2 issues (1997) Browser Problem?!? NN 4.0+ and Browser Info.txt? (1997) Bug? (1997) orderfile stuff (1998) Using [Include] Context (1999) WebCat2 - many [carts] on one template page? (1997) Database Advice (1996) webcatalog plugin bug - webstar refusing connections (1999) WebCat2b13MacPlugIn - More limits on [include] (1997) Re:Realtime Transaction Processing (1999) Requiring that certain fields be completed (1997)