Re: [showif] not working

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52531
interpreted = N
texte = Shouldn't this test line: [showif [mydistance]<[distance]] It works!!!! [/showif] Be: [showif [mydistance1]<[distance]] It works!!!! [/showif] ? Anyways, I've created the same db's and populated them and ran your page with only that small change above and it seems to work ok, the page shows: It works!!!! ( 1056.33 <30) It works!!!! ( 1056.33 <35) If I leave it as [mydistance], it doesn't work as [mydistance] is undefined (you have it defined as [mydistance1]). Could that be the problem? GK P.S. Why do you all have to jump on Art for, he's been here long enough - he knows what time it is....sheesh :)) -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Art Vargas Sent: Wednesday, August 27, 2003 11:38 AM To: WebDNA Talk Subject: Re: [showif] not working Kenteh: I have try debugging first, which is why I am posting in the list. I did mention in the original post that I had tested the values I was getting back, and they seemed ok. Here is the code I am having problems. [search db=location.db&neskudatarq=[blank]&zipsumm=T&distancetype=number] [founditems] [!]------------------------------------------------------------------ [zip] from search [v2] variable passed from form this portion of the code returns a distance value, I am not sure if is a text or a number variable ---------------------------------------------------------------------[/!] [text]myzipcode1=[zip][/text] [text]myzipcode2=[v2][/text] [text]mydistance1= [!]calculatedist.inc takes to values myzipcode1 and myzipcode2 and outputs a distance[/!] [search db=zips.db&eqzipcodedatarq=[myzipcode1]] [founditems] [text]latitude1=[latitude][/text] [text]longitude1=[longitude][/text] [/founditems] [/search] [search db=zips.db&eqzipcodedatarq=[myzipcode2]] [founditems] [text]latitude2=[latitude][/text] [text]longitude2=[longitude][/text] [/founditems] [/search] [Format ..2f][math]3963.0*acos(sin(([latitude1]/57.3))*sin(([Latitude2]/57.3))+cos(([ latitude1]/57.3))*cos(([Latitude2]/57.3))*cos([Longitude2]/57.3 - [longitude1]/57.3))[/math][/format] [/text] [!]-------------------------------------------------- [distance] from search [mydistance] from [text] avobe ---------------------------------------------------[/!] [showif [mydistance]<[distance]] It works!!!! [/showif] [!]used to view values[/!] ([mydistance1]<[distance]) [/founditems] [/search] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [showif] not working ( "Gary Krockover" 2003)
  2. Re: [showif] not working ( Art Vargas 2003)
  3. Re: [showif] not working ( "Gary Krockover" 2003)
  4. Re: [showif] not working ( Donovan 2003)
  5. Re: [showif] not working ( Art Vargas 2003)
  6. Re: [showif] not working ( Kenneth Grome 2003)
  7. Re: [showif] not working ( Glenn Busbin 2003)
  8. Re: [showif] not working ( Art Vargas 2003)
  9. Re: [showif] not working ( Rob Marquardt 2003)
  10. Re: [showif] not working ( Glenn Busbin 2003)
  11. Re: [showif] not working ( Art Vargas 2003)
  12. Re: [showif] not working ( Donovan 2003)
  13. Re: [showif] not working ( Art Vargas 2003)
  14. Re: [showif] not working ( Rob Marquardt 2003)
  15. Re: [showif] not working ( Glenn Busbin 2003)
  16. Re: [showif] not working ( devaulw@onebox.com 2003)
  17. [showif] not working ( Art Vargas 2003)
Shouldn't this test line: [showif [mydistance]<[distance]] It works!!!! [/showif] Be: [showif [mydistance1]<[distance]] It works!!!! [/showif] ? Anyways, I've created the same db's and populated them and ran your page with only that small change above and it seems to work ok, the page shows: It works!!!! ( 1056.33 <30) It works!!!! ( 1056.33 <35) If I leave it as [mydistance], it doesn't work as [mydistance] is undefined (you have it defined as [mydistance1]). Could that be the problem? GK P.S. Why do you all have to jump on Art for, he's been here long enough - he knows what time it is....sheesh :)) -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Art Vargas Sent: Wednesday, August 27, 2003 11:38 AM To: WebDNA Talk Subject: Re: [showif] not working Kenteh: I have try debugging first, which is why I am posting in the list. I did mention in the original post that I had tested the values I was getting back, and they seemed ok. Here is the code I am having problems. [search db=location.db&neskudatarq=[blank]&zipsumm=T&distancetype=number] [founditems] [!]------------------------------------------------------------------ [zip] from search [v2] variable passed from form this portion of the code returns a distance value, I am not sure if is a text or a number variable ---------------------------------------------------------------------[/!] [text]myzipcode1=[zip][/text] [text]myzipcode2=[v2][/text] [text]mydistance1= [!]calculatedist.inc takes to values myzipcode1 and myzipcode2 and outputs a distance[/!] [search db=zips.db&eqzipcodedatarq=[myzipcode1]] [founditems] [text]latitude1=[latitude][/text] [text]longitude1=[longitude][/text] [/founditems] [/search] [search db=zips.db&eqzipcodedatarq=[myzipcode2]] [founditems] [text]latitude2=[latitude][/text] [text]longitude2=[longitude][/text] [/founditems] [/search] [Format ..2f][math]3963.0*acos(sin(([latitude1]/57.3))*sin(([Latitude2]/57.3))+cos(([ latitude1]/57.3))*cos(([Latitude2]/57.3))*cos([Longitude2]/57.3 - [longitude1]/57.3))[/math][/format] [/text] [!]-------------------------------------------------- [distance] from search [mydistance] from [text] avobe ---------------------------------------------------[/!] [showif [mydistance]<[distance]] It works!!!! [/showif] [!]used to view values[/!] ([mydistance1]<[distance]) [/founditems] [/search] ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Gary Krockover"

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:

Help needed! (1998) WCS Newbie question (1997) [taxRate] [TaxTotal] ? (1997) listword db bolding {correction} (2002) Using [Include] Context (1999) Setting up WebCatalog with Retail Pro data (1996) Forms (1997) flushdatabases (2000) The [shownext] limitations (2002) A question on sub-categories (1997) [WebDNA] current thinking on architecture of mass email scripts? (2011) Unix DB Permission Error (2002) OSX (2002) international time (1997) [append] problem (1997) Help! WebCat2 bug (1997) [text] variable assignment within [search] context (2000) information on Vieworders.tpl (1998) Counting LineItems (2000) Updating a database once per day - An example (1998)