Re: Show new
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48235
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Gary Krockover
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:
Tiger / WebDNA (2005)
Bug? (1997)
Separate SSL Server (1997)
[WebDNA] Need someone to port CakePHP auction site to WebDNA (2010)
carriage returns in data (1997)
Sendmail html/text problem (2003)
RE: Force a number with JavaScript (1998)
and vs or vs not (1998)
Return records from another (1997)
itools (2000)
Newbie Question (2003)
Design Help Needed (1998)
URGENT - CPU usage OSXS (2001)
Date Comparison (1998)
Netscape v. IE (1997)
Authentication Box (2000)
Limiting user access to .tmpl files (1997)
WebTen? (1997)
[sendmail] v. [writefile] (2000)
Denying access by IP address (2000)