ShowNext - This is Killing me!

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18408
interpreted = N
texte = OK, gang, here's the problem.....heres the code that searches a database for certain criteria and returns the results as hyperlinks that in turn generate a different search when clicked......[search db=MajorCategories.db&neMajordata=0&descriptionsort=1] [foundItems][Description]
[search db=Subcategories.db&bwMajordatarq=[Major]] [foundItems][Description]
[/foundItems] [/search] [/foundItems] [/search] Here is the code on the results page (index3.tpl) that displays the results of the search....this particular search returns13 items and shows the first 6....however, the problem arises when trying to do a ShowNext....nothing shows up between the [ShowNext] and [/ShowNext] tags. All of the variables are passed to this page, BTW, and I have spent way too many hours trying to figure this out....I am throwing myself upon the mercy of this talk list...cany anyone figure out why this won't work???? Found [numFound] product(s) matching your search. [founditems] [showif [index]\2][showif [index]!6][/showif][/showif] [/foundItems]
[lookup db=VendorSpecs.db&value=[sku]&lookinfield=sku&returnfield=title¬found=Not Found]
[SKU]
[PRICE]
Click here for more info...

[shownext] Show Items [start]-[end]
[/shownext]

-- John Kennedy***************************** Pro Sound and Stage Lighting 11711 Monarch St Garden Grove, CA 92841 714.891.3990. Ext. 111 ***************************** Associated Messages, from the most recent to the oldest:

    
  1. Re: ShowNext - This is Killing me! (Kenneth Grome 1998)
  2. ShowNext - This is Killing me! (John Kennedy 1998)
OK, gang, here's the problem.....heres the code that searches a database for certain criteria and returns the results as hyperlinks that in turn generate a different search when clicked......[search db=MajorCategories.db&neMajordata=0&descriptionsort=1] [founditems][Description]
[search db=Subcategories.db&bwMajordatarq=[Major]] [founditems][username]&password=[password]&db=catalog.txt&eqMerchandiserdata=D&Category=[bothcategories]&max=12&pricesort=1&pricesdir=as&pricetype=num>[Description]
[/foundItems] [/search] [/foundItems] [/search] Here is the code on the results page (index3.tpl) that displays the results of the search....this particular search returns13 items and shows the first 6....however, the problem arises when trying to do a ShowNext....nothing shows up between the [shownext] and [/ShowNext] tags. All of the variables are passed to this page, BTW, and I have spent way too many hours trying to figure this out....I am throwing myself upon the mercy of this Talk List...cany anyone figure out why this won't work???? Found [numFound] product(s) matching your search. [founditems] [showif [index]\2][showif [index]!6][/showif][/showif] [/foundItems]
[url][lookup db=catalog.txt&value=[sku]&lookinfield=sku&returnfield=sku¬found=Not Found][/URL].gif> [lookup db=VendorSpecs.db&value=[sku]&lookinfield=sku&returnfield=title¬found=Not Found]
[SKU]
[PRICE]
Click here for more info...

[shownext] Show Items [start]-[end]
[/shownext]

-- John Kennedy***************************** Pro Sound and Stage Lighting 11711 Monarch St Garden Grove, CA 92841 714.891.3990. Ext. 111 ***************************** John Kennedy

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) Extra Text Fields (was Another question) (1997) math with multiple [founditems] (1999) Cart doesn't interpret tag! (1997) Summing fields (1997) AOL and webcat (1998) Using Plug-In while running 1.6.1 (1997) Sort Order on a page search (1997) Not really WebCat (1997) Frustration with formulas.db (1999) member access (2000) UPDATE PROBLEM (1997) SQL Error 22003 (2001) Template Security error (1997) Changes to the List (1997) [format] minus figures (2003) Null Characters (2005) Add a field to the error log? (1997) purchase.log file (1997) Authorize.Net (2003)