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:

Problems with SELECT MULTIPLE (1999) Paymethod question (1999) Help name our technology! (1997) [WebDNA] Now: Listfields does not work with tables - Was: [OT] (2011) [WebDNA] maybe silly suggestion? [founditems] (2015) Emails are Stuck (2003) Review comparison by PC Magazine: Open for On-line Business (1997) LetterRip and WebCat (1998) [group] ? (1997) Problems getting parameters passed into email. (1997) denied access (1997) [taxRate] [TaxTotal] ? (1997) Instability Problem (1999) Edit Plus and webcat code library - Gary Krockover (2003) Webcat interfering with Webstar? (1998) lookup and two records? (1997) Missing something simple?? (1998) [Replace] really replaces? (2000) 'bot Q (2000) More on the email templates (1997)