Re: Show new
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48237
interpreted = N
texte = Now that would be too easy, wouldn't it? : )GK> 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 thatyou> > have something to sort on. You could automate the datestamp thatappends> > 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 oneshows> >> 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/-------------------------------------------------------------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:
Now that would be too easy, wouldn't it? : )GK> 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 thatyou> > have something to sort on. You could automate the datestamp thatappends> > 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 oneshows> >> 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/-------------------------------------------------------------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:
PCS Frames (1997)
SiteGuard Admin Feature ? (1997)
[convertChars] and HTML Tags (1997)
New (1998)
using showpage and showcart commands (1996)
wc 2 pro users - sites, quotes wanted (1997)
WebCat virtual postcard is done! Thanks for the help! (1998)
WebCatalog NT beta 18 now available (1997)
RE: Credit card processing - UK (1997)
carriage returns in data (1997)
Multiple fields on 1 input (1997)
Building Calendars (1997)
greater than or equal to (1997)
problem with applets embedded in tpl files (1997)
Folder Follies (1998)
RE: [WebDNA] Installing WebDNA on Windows 7 64 Bit, Home Premium (2010)
Which is Faster (1998)
Submitting ampersands in forms... (1998)
Re:2nd WebCatalog2 Feature Request (1996)
Date Formats (1997)