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:
Blank orders after update to 5.1 (2003)
searchable list archive (1997)
Out of the woodwork (2007)
Generating Report Totals (1997)
Press Release hit the NewsWire!!! (1997)
Plugin or CGI or both (1997)
Date search - yes or no (1997)
About WebCatalog and iTools 7 (2003)
WebCat2b15MacPlugin - [protect] (1997)
Help! WebCat2 bug (1997)
EIMS Problems (1997)
Building Calendars (1997)
Before I Can Begin . . . (1998)
Problem 2: Prefs file... (1997)
Search returns all, not 20 (1997)
What if SSL server down? MAC (1997)
Shopping cart now bad (1997)
Limit on nested [ShowIf]'s? (1997)
Price problem (1997)
multiple databases (1997)