Re: Show new

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48236
interpreted = N
texte = If there's no date field or similar you could always do this...[Search db=database.db&neSKUdatarq=find_all&rank=off] [text show=f]final_total=[numfound][/text] [founditems] [showif [index]=[final_total]] All found data that you want goes here. [/showif] [/founditems] [/search]Regards, Tim> From: Gary Krockover > Reply-To: (WebDNA Talk) > Date: Fri, 28 Feb 2003 21:28:00 -0600 > To: (WebDNA Talk) > Subject: Re: Show new > > I'm thinking that Craig doesn't have a date field in his database, so > nothing to sort on datewise. Off-hand, I can't think of way to search a > database and return the last append if there is no date information also > being saved with it. Craig, you may need to add such a field so that you > have something to sort on. You could automate the datestamp that appends > with each record and then sort on that: > > [append db=somedatabase.db][!] > [/!]sku=[url][sku][/sku][!] > [/!]&dateindb=[date][!] > [/!]&timeindb=[time][!] > [/!][/append] > > GK > > > > >> 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/ > > > ------------------------------------------------------------- > 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)
If there's no date field or similar you could always do this...[Search db=database.db&neSKUdatarq=find_all&rank=off] [text show=f]final_total=[numfound][/text] [founditems] [showif [index]=[final_total]] All found data that you want goes here. [/showif] [/founditems] [/search]Regards, Tim> From: Gary Krockover > Reply-To: (WebDNA Talk) > Date: Fri, 28 Feb 2003 21:28:00 -0600 > To: (WebDNA Talk) > Subject: Re: Show new > > I'm thinking that Craig doesn't have a date field in his database, so > nothing to sort on datewise. Off-hand, I can't think of way to search a > database and return the last append if there is no date information also > being saved with it. Craig, you may need to add such a field so that you > have something to sort on. You could automate the datestamp that appends > with each record and then sort on that: > > [append db=somedatabase.db][!] > [/!]sku=[url][sku][/sku][!] > [/!]&dateindb=[date][!] > [/!]&timeindb=[time][!] > [/!][/append] > > GK > > > > >> 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/ > > > ------------------------------------------------------------- > 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:

Cart ID Duplication (2001) Using Applescript to process WebCatalog functions (1998) spawn (1998) Guest Book (2002) Can't Update records (1997) Still More on EudoraPro Email (1998) Strange Date happenings (2007) Search-context (1999) Longer .extensions with Windows? (1998) Add htmlarea 3 to SiteBuilder (2004) Calculating multiple shipping... (1997) [WebDNA] To Commitdatabase or Not to Commitdatabase (2012) Dr. Watson Error (1998) ListWords passing multi values in one form field (2000) WebCommerce: Folder organization ? (1997) Practice runs ? (1997) THANKS!!! ShipCosts.db and debugging (1997) back button problem (1999) Founditems (1998) Strange Search Results (2004)