Re: [showif] not working
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52532
interpreted = N
texte = Gary you are my hero!!!!!!1 Thanks. _\\///_ (' o-o ') _______ooOo_( )oOoo__________ Arturo Vargas Programmer/System Integration The Sports Section (818) 998-6200 Art@SportsSection.com ________________Oooo_________ oooO ( ) ( ) \ / \ / (_/ \_) -----Original Message----- From: Gary Krockover [mailto:gary@garykrockover.com] Sent: Wednesday, August 27, 2003 10:18 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: [showif] not working 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/ ------------------------------------------------------------- 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:
Gary you are my hero!!!!!!1 Thanks. _\\///_ (' o-o ') _______ooOo_( )oOoo__________ Arturo Vargas Programmer/System Integration The Sports Section (818) 998-6200 Art@SportsSection.com ________________Oooo_________ oooO ( ) ( ) \ / \ / (_/ \_) -----Original Message----- From: Gary Krockover [mailto:gary@garykrockover.com] Sent: Wednesday, August 27, 2003 10:18 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: [showif] not working 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/ ------------------------------------------------------------- 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/
Art Vargas
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:
FORMS: Returning a specific page (1997)
Removing [showif] makes a big difference in speed (1997)
[WebDNA] German e-shop company proclaims "In Memory Computing" (2010)
Deleting Orders (1997)
[LOOKUP] (1997)
More on [lookup] (1999)
os 8.5 (1999)
orders being printed (1998)
Searching (1998)
relational db question (2002)
Weird bug, or is there something amiss? (1997)
Getting total number of items ordered (1997)
WebCat2b12 - nesting [tags] (1997)
Shopping Cart variation... (1997)
Help! Missing [showif] or [hideif] (2000)
Emailer port change (1997)
[WebDNA] users.db (2009)
authorizenet and netscape (2002)
[UPPERCASE] (1997)
pop up menu's (1998)