Re: Weird problems with [SHOWIF]s

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13283
interpreted = N
texte = >I'm getting strange results ... >When I use just one of the [SHOWIF]s, I get the error message >Error: the database ':DB:Description.db' could not be found or >opened:>[SEARCH db=DB/Comics.db&....] >FOUND [NUMFOUND] items. Showing items >[MATH][K]+1[/MATH]-[MATH][K]+[DISP][/MATH].

>[FOUNDITEMS] >[SHOWIF [INDEX]<[K]+[DISP]] >... >[LOOKUP >db=DB/Description.db&value=[SKU]&LookInField=SKU&ReturnField=description] >... > >[/SHOWIF]>[/FOUNDITEMS] >[/SEARCH]>When I use both [SHOWIF]s, *nothing* displays:>[SEARCH db=DB/Comics.db&....] >FOUND [NUMFOUND] items. Showing items >[MATH][K]+1[/MATH]-[MATH][K]+[DISP][/MATH].

>[FOUNDITEMS] >[SHOWIF [INDEX]>[K]] >[SHOWIF [INDEX]<[K]+[DISP]] >... >[LOOKUP >db=DB/Description.db&value=[SKU]&LookInField=SKU&ReturnField=description] >... > >[/SHOWIF] >[/SHOWIF] >[/FOUNDITEMS] >[/SEARCH]When you use only the *first* showif, WebCat's telling you one of two things:Either it cannot find the Descriptions.db because it's not in the same folder as the comics.db (which is where you're saying it is), or else you need to allocate more memory to WebCat so it will have enough memory to actually open the Descriptions.db file.When you use *both* showifs, WebCat's telling you that the value if [index] is NOT greater than the value of [k], so it is NOT showing you anything inside that showif context. What's the value of [k] anyways? Are there any records found in the comics.db file when you do this search?Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Associated Messages, from the most recent to the oldest:

    
  1. Re: Weird problems with [SHOWIF]s (Michael Winston 1997)
  2. Re: Weird problems with [SHOWIF]s (Michael Winston 1997)
  3. Re: Weird problems with [SHOWIF]s (Michael Winston 1997)
  4. Re: Weird problems with [SHOWIF]s (Kenneth Grome 1997)
  5. Re: Weird problems with [SHOWIF]s (grichter@panavise.com (Gary Richter) 1997)
  6. Re: Weird problems with [SHOWIF]s (Kenneth Grome 1997)
  7. Weird problems with [SHOWIF]s (Michael Winston 1997)
>I'm getting strange results ... >When I use just one of the [showif]s, I get the error message >Error: the database ':DB:Description.db' could not be found or >opened:>[SEARCH db=DB/Comics.db&....] >FOUND [NUMFOUND] items. Showing items >[math][K]+1[/MATH]-[math][K]+[DISP][/MATH].

>[founditems] >[SHOWIF [INDEX]<[K]+[DISP]] >... >[LOOKUP >db=DB/Description.db&value=[SKU]&LookInField=SKU&ReturnField=description] >... > >[/SHOWIF]>[/FOUNDITEMS] >[/SEARCH]>When I use both [showif]s, *nothing* displays:>[SEARCH db=DB/Comics.db&....] >FOUND [NUMFOUND] items. Showing items >[math][K]+1[/MATH]-[math][K]+[DISP][/MATH].

>[founditems] >[SHOWIF [INDEX]>[K]] >[SHOWIF [INDEX]<[K]+[DISP]] >... >[LOOKUP >db=DB/Description.db&value=[SKU]&LookInField=SKU&ReturnField=description] >... > >[/SHOWIF] >[/SHOWIF] >[/FOUNDITEMS] >[/SEARCH]When you use only the *first* showif, WebCat's telling you one of two things:Either it cannot find the Descriptions.db because it's not in the same folder as the comics.db (which is where you're saying it is), or else you need to allocate more memory to WebCat so it will have enough memory to actually open the Descriptions.db file.When you use *both* showifs, WebCat's telling you that the value if [index] is NOT greater than the value of [k], so it is NOT showing you anything inside that showif context. What's the value of [k] anyways? Are there any records found in the comics.db file when you do this search?Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html Kenneth Grome

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:

RE: [WebDNA] WebDNA 8.6 announced - New features (2018) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) New Mac Public Beta Available (1997) Can't Update records (1997) using showpage and showcart commands (1996) Strange search... (2001) How many lookups does it take ... (2003) Debugging (2005) Separate SSL Server (1997) How do you cause a new window to appear behind the current window? (1999) Re:my First Ship table (1998) Sorting by date (1997) Plugin or CGI or both (1997) [referrer] tag (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Problems setting MIME Headers (1998) Date Formats (1997) Adding up weights (1998) sorted cart? (1998) search vs lookup (1998)