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:

carriage returns in data (1997) Announce: WebMerchant 3.0 for Mac shipping now (1998) WebCatalog NT beta 18 problem (1997) E-Mail (1998) Virtual hosting and webcatNT (1997) Setting up shop (1997) Email and name capture (1999) WebCommerce: Folder organization ? (1997) WebCatalog for guestbook ? (1997) Problems with [Applescript] (1997) Document Contains No Data! (1997) passwords (2000) multiple databases (1997) emailer on Windows Beta 18 (1997) WEBDNA tags don't process in a .js file (2002) WebCommerce: Folder organization ? (1997) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) Running _every_ page through WebCat ? (1997) Country & Ship-to address & other fields ? (1997) Just Testing (1997)