Re: Show new

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48234
interpreted = N
texte = There are number of ways you can do it, and it can depend on what your field names are. Basically, search for this: [Search db=database.db&neFIELDNAMEdatarq=find_all&deFIELDNAME2sort=1&max=1]First it finds all, then it sorts in descending order on FIELDNAME2 (which has to sort in a first to last order), and max=1 means the last one shows up.If you have a DBDATE field and a DBTIME field (for when the entry was appended), then you would do this: [Search db=database.db&neFIELDNAMEdatarq=find_all&deDBDATEsort=1&deDBTIMEsort=2&max= 1]Regards, Tim> From: Craig Forest > Reply-To: (WebDNA Talk) > Date: Fri, 28 Feb 2003 18:15:01 > To: (WebDNA Talk) > Subject: Show new > > Hello, > > This is a very basic question but I just can't seem to figure it out. > I have an article system set up, and I want to be able to search and > show only the newest article. It appends to a database so how would I > go about searching the database and only returning the newest record? > > > Thanks, > > Craig Forest > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Show new (lb Lawrence 2003)
  2. Re: Show new (Craig Forest 2003)
  3. Re: Show new (Gary Krockover 2003)
  4. Re: Show new (Tim Robinson 2003)
  5. Re: Show new (Gary Krockover 2003)
  6. Re: Show new (Tim Robinson 2003)
  7. Show new (Craig Forest 2003)
There are number of ways you can do it, and it can depend on what your field names are. Basically, search for this: [Search db=database.db&neFIELDNAMEdatarq=find_all&deFIELDNAME2sort=1&max=1]First it finds all, then it sorts in descending order on FIELDNAME2 (which has to sort in a first to last order), and max=1 means the last one shows up.If you have a DBDATE field and a DBTIME field (for when the entry was appended), then you would do this: [Search db=database.db&neFIELDNAMEdatarq=find_all&deDBDATEsort=1&deDBTIMEsort=2&max= 1]Regards, Tim> From: Craig Forest > Reply-To: (WebDNA Talk) > Date: Fri, 28 Feb 2003 18:15:01 > To: (WebDNA Talk) > Subject: Show new > > Hello, > > This is a very basic question but I just can't seem to figure it out. > I have an article system set up, and I want to be able to search and > show only the newest article. It appends to a database so how would I > go about searching the database and only returning the newest record? > > > Thanks, > > Craig Forest > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Tim Robinson

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:

Assigning new CART number (1997) Re:Emailer and encryption (1997) RE: Missing contexts on NT (1997) (thx) automating a POST (2002) Shipping still a problem!! (1998) WCS Newbie question (1997) [WebDNA] OT survey .... (2012) Big Databases (1997) Resume Catalog ? (1997) Grant, please help me ... (1997) [shownext] and sort (1998) Force a search at the default.tmpl page? (1997) build a select list from a db search (2004) [WebDNA] Order that emailer sends emails? (2009) HomePage Caution (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Projects & Contractors (1997) searching for last file in a directory (1999) show all problem (1997)