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:

Webstar 1.3.1 PPC (1997) Purchased cart being overwritten - still !?? (1997) RE: [WebDNA] [test] (2009) using showpage and showcart commands (1996) Tracking (2004) WebCommerce: Folder organization ? (1997) Am I going senile? (Price recalc based on quantity) (1997) Re:no [search] with NT (1997) Grant, please help me ... (1997) ErrorMessages.db suggestion (1997) Sort Order on a page search (1997) Re:Variable Math (1998) 'page impression' techniques for banner ads (1999) multiple prices (1998) Date search - yes or no (1997) A question on sub-categories (1997) [WebDNA] Windows fastcgi version (2018) Emailer setup (1997) Error Lob.db records error message not name (1997) Shopping Cart Problem (1998)