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 particular story are in a single record, correct? So you just need to set a variable on the story page that indicates how many photos are associated with that story. 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 the photoview.tpl page with the SKU of the article and the [x] value, along with an index [i]...
View PhotosThen build a photoviewer.tpl page that searches for the SKU and increments the 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 Davis Network 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 particular story are in a single record, correct? So you just need to set a variable on the story page that indicates how many photos are associated with that story. 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 the photoview.tpl page with the SKU of the article and the [x] value, along with an index [i]... View PhotosThen build a photoviewer.tpl page that searches for the SKU and increments the 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 Davis Network 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:
Num Found by category (2000)
America Online Issues (1998)
[ListFiles] & [loop] (1998)
WebMerchant Only reads 1.4 order files error (1997)
RE: protect tag on NT (1997)
CC: (1998)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Practice runs ? (1997)
Non-WebDNA Sites Reporting Errors When WebDNA Isn't Running (2006)
BinaryBody problem ...... (2003)
vs (1997)
Separate SSL Server (1997)
WC 2.0 frames feature (1997)
To Err or Not Custom Error (1999)
PCS Frames (1997)
Search returns all, not 20 (1997)
Problems getting parameters passed into email. (1997)
More news on 5.0 (2003)
PCS Frames (1997)
Here's an example of an applet in a tpl (1997)