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:

    
  1. Re: Can ShowNext do this? (Gary Krockover 2000)
  2. Re: Can ShowNext do this? (Gary Krockover 2000)
  3. Re: Can ShowNext do this? SOLVED (Clint Davis 2000)
  4. Re: Can ShowNext do this? (Clint Davis 2000)
  5. Re: Can ShowNext do this? (Mike Davis 2000)
  6. Re: Can ShowNext do this? (Clint Davis 2000)
  7. Can ShowNext do this? (Clint Davis 2000)
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:

PIXO support (1997) calculate user's age (1999) Encrypt question. (2000) strip .0 off off IPaddress (1998) Authenticate (1997) os 8.5 (1999) [Shownext] [whynot] (2000) Pithy questions on webcommerce & siteedit (1997) Where is f2? (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Bug? (1997) Secure server question (1997) Stumpted Again (1997) Shopping Cart w/Multiple Databases (1998) New Command prefs ... (1997) unable to launch acgi in WebCat (1997) SMSI (Scott) clues?? Bug fixes for next WebDNA release (2005) Please please help (2001) Summing a field full of numbers ... (1997) [WebDNA] passing a variable in an include - precedence (2017)