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:

2nd try:Webcat interfering with Webstar? (1998) WebCat2 as a chat server? (1997) Multiple Items (1998) A little syntax help (1997) [WebDNA] mail header timezone problem (2008) Replacing a Word (1999) WC2f3 (1997) Confessions of a new user - please be kind it's Friday (2000) Some Advise needed (1997) MacFinder -- a new WebDNA web site (1998) Credit card processing - UK (1997) lineitems context in sendmail context (1998) WebDNA Forum show n tell (test request).. (2007) Members register & gain access system (1998) WebCatalog Plug-in for Webstar. (1997) Emailer problems. (1998) WebCat2b12 forgets serial # (1997) Replace Statement (1997) Which is Faster (1998) Ariba XML support help needed (2004)