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:

[isfolder] and [filename] (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Checkboxes (1998) Too Much Rootbeer Free Offer (1997) Authenticating users without dialog box (1997) Adding Header Values with [SetHeader] (1998) database visibility (2000) Deleting Orders (1997) Documentation Feedback (1997) Forbidden CGI Error (1997) Shopping Cart Questions (1998) WC 2.0 frames feature (1997) To Use Cookies or Not To Use Cookies (2003) ShowNext Command (1997) Calendar (1997) Generating Report Totals (1997) How true is this? (1999) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) dumb questions. (2000) [WebDNA] test (2009)