Re: Can ShowNext do this?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 27364
interpreted = N
texte = on 2/11/2000 9:36 AM, Clint Davis at cdavis@mail.grayloon.com wrote:> I'm trying to set up a page that will display a story pulled from my> database. This story has several photos associated with it. Each of> the photos is a entry into a field in the database named [photo1] -> [photo16]. I would like to display the first photo with the story and> a link to the next photo. The next page would display [photo2] with a> link to [photo3] and so on. I would like to do this with one initial> page displaying the story and [photo1]. The remaining photos would be> displayed on a different template (giving me 2 templates total).> After reaching the final available photo for the story, the user> would be given a link to return to the story.> > I found an example of this done in Cold Fusion:> http://www.realtree.com/journal/index.cfm> > I have played with [ShowNext], but since the photos are in different> fields, it was getting pretty tricky. Any ideas or examples would be> much appreciated.> I don't think shownext is what you need here. All photos for a particularstory are in a single record, correct? So you just need to set a variableon the story page that indicates how many photos are associated with thatstory.Check the [photoX] fields in a loop...[math show=f]x=0[/math][loop start=1&end=16] [showif [interpret][photo[index]][/interpret]!] [math show=f]x=x+1[/math] [/showif][/loop]Now you have [x] as the number of photos for your story. Link to thephotoview.tpl page with the SKU of the article and the [x] value, along withan index [i]...
View PhotosThen build a photoviewer.tpl page that searches for the SKU and incrementsthe index.[search your.db&eqSKUdata=[SKU]&max=1][founditems]Photo [i] for Story [title].

[showif [i]<[x]]
Next Photo[/showif][showif [i]=[x]]
No more photos. Back to the Story[/showif][/founditems][/search]Mike DavisNetwork 13, Inc.-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
on 2/11/2000 9:36 AM, Clint Davis at cdavis@mail.grayloon.com wrote:> I'm trying to set up a page that will display a story pulled from my> database. This story has several photos associated with it. Each of> the photos is a entry into a field in the database named [photo1] -> [photo16]. I would like to display the first photo with the story and> a link to the next photo. The next page would display [photo2] with a> link to [photo3] and so on. I would like to do this with one initial> page displaying the story and [photo1]. The remaining photos would be> displayed on a different template (giving me 2 templates total).> After reaching the final available photo for the story, the user> would be given a link to return to the story.> > I found an example of this done in Cold Fusion:> http://www.realtree.com/journal/index.cfm> > I have played with [shownext], but since the photos are in different> fields, it was getting pretty tricky. Any ideas or examples would be> much appreciated.> I don't think shownext is what you need here. All photos for a particularstory are in a single record, correct? So you just need to set a variableon the story page that indicates how many photos are associated with thatstory.Check the [photoX] fields in a loop...[math show=f]x=0[/math][loop start=1&end=16] [showif [interpret][photo[index]][/interpret]!] [math show=f]x=x+1[/math] [/showif][/loop]Now you have [x] as the number of photos for your story. Link to thephotoview.tpl page with the SKU of the article and the [x] value, along withan index [i]...View PhotosThen build a photoviewer.tpl page that searches for the SKU and incrementsthe index.[search your.db&eqSKUdata=[SKU]&max=1][founditems]Photo [i] for Story [title].
[interpret][photo[i]][/interpret]>
[showif [i]<[x]][thisurl]?SKU=[SKU]&x=[x]&i=[math]i+1[/math]>Next Photo[/showif][showif [i]=[x]]No more photos. Back to the Story[/showif][/founditems][/search]Mike DavisNetwork 13, Inc.-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Mike Davis
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:
Hairy Shi**ing Monster :-) (2006)
japanese characters (1997)
European Convention (2004)
test (2000)
HELP! 10K hits per hour for pages that no longer exist! (2000)
[OT] http list (2003)
Copy, Move, Create Folders (1998)
[WriteFile] problems (1997)
Databases inside [SHOWIF] (1998)
[WebDNA] Stupid question about CentOS v4 and WebDNA v6 (2008)
Nesting WebDNA in JavaScript (2003)
Problem: 3.0 doesn't update carts (1997)
Security Issues and WebCommerce Solution (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
WebCatalog for Linux users!! (2000)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Auto entering Friday's date in a field (2002)
taxTotal, grandTotal (1997)
StoreBuilder Shopping Cart (2000)
Anybody see this before? (2006)