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:

Generating unique SKU from [cart] (1997) WC1.6 to WC2 date formatting (1997) Database Options (1997) Single Link browsing (1997) Re1000001: Setting up shop (1997) HomePage Caution (1997) Can I invoke an ssi plugin from within a webcat page (1997) [WebDNA] FCKeditor (2009) Automatically resizing mac jpg's wi applescript (2000) webcat2b12 CGI -- Date comparisons (1997) Date search - yes or no (1997) Help on how to store calculated value (2002) Request Time Out (1997) Running a store on BOTH http and https (1998) the dreaded unitShipCost (2003) POST through TCPConnect (1999) Virtual Postcard almost complete... (1998) Signal Raised Error (Part II) (1997) RE: ShowNext Command (1997) Security - 2 (1999)