Re: Can this be done?
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57246
interpreted = N
texte = Thanks Charles! Thats exactly what I was hoping todo. I figured it would be something simple as I know I still have ALOT to learn about WebDNA programming. Jesse ----- Original Message ----- From: "charles kline"
To: "WebDNA Talk" Sent: Tuesday, April 06, 2004 9:22 AM Subject: Re: Can this be done? > You could read them in as a string. Then loop over the string doing a > lookup on each value. > > [text > show=f]mls_codes=J02,J08,K07,L03,M18,N13,N18,N19,N24,S10,Q06,Q08,Q27,T08 > ,X12,Y25[/text] > [listwords words=[mls_codes]&Delimiters=,] > [lookup > db=code_to_feature.db&value=[word]&lookinfield=code&returnfield=feature] >
> [/listwords] > > - Charles > > > On Apr 6, 2004, at 10:14 AM, Jesse Crofoot wrote: > > > Hello all, and thanks in advance for any suggestions. > > > > I'm workin on setting up a MLS system for one of our realtor customers > > and > > one of the fileds in the MLS feed is a features filed where the feature > > codes are stored in the following format. > > > > J02,J08,K07,L03,M18,N13,N18,N19,N24,S10,Q06,Q08,Q27,T08,X12,Y25 > > > > I have setup another database that contains the translation of the > > code into > > the actual feature. I was curious if there was an easy way to do a > > lookup > > on the feature database to convert the codes to the actual feature > > name. I > > could do it easilly if the codes were in indvidual fields however > > since they > > are all in a single field I'm stumped. > > > > Any help will be greatly appreciated. > > > > Jesse L Crofoot > > > > > > > > ------------------------------------------------------------- > > 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/ > > ------------------------------------------------------------- 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:
Thanks Charles! Thats exactly what I was hoping todo. I figured it would be something simple as I know I still have ALOT to learn about WebDNA programming. Jesse ----- Original Message ----- From: "charles kline" To: "WebDNA Talk" Sent: Tuesday, April 06, 2004 9:22 AM Subject: Re: Can this be done? > You could read them in as a string. Then loop over the string doing a > lookup on each value. > > [text > show=f]mls_codes=J02,J08,K07,L03,M18,N13,N18,N19,N24,S10,Q06,Q08,Q27,T08 > ,X12,Y25[/text] > [listwords words=[mls_codes]&Delimiters=,] > [lookup > db=code_to_feature.db&value=[word]&lookinfield=code&returnfield=feature] >
> [/listwords] > > - Charles > > > On Apr 6, 2004, at 10:14 AM, Jesse Crofoot wrote: > > > Hello all, and thanks in advance for any suggestions. > > > > I'm workin on setting up a MLS system for one of our realtor customers > > and > > one of the fileds in the MLS feed is a features filed where the feature > > codes are stored in the following format. > > > > J02,J08,K07,L03,M18,N13,N18,N19,N24,S10,Q06,Q08,Q27,T08,X12,Y25 > > > > I have setup another database that contains the translation of the > > code into > > the actual feature. I was curious if there was an easy way to do a > > lookup > > on the feature database to convert the codes to the actual feature > > name. I > > could do it easilly if the codes were in indvidual fields however > > since they > > are all in a single field I'm stumped. > > > > Any help will be greatly appreciated. > > > > Jesse L Crofoot > > > > > > > > ------------------------------------------------------------- > > 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/ > > ------------------------------------------------------------- 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/
"Jesse Crofoot"
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:
REALLY need a hand (1999)
Keeping the cart alive through multiple add commands (2000)
[shownext] and sort (1998)
ListFiles (2000)
How to verify email address (1997)
[WebDNA] Showif Hideif If Then Case Sensitivity (2020)
[WebDNA] SOAP support (2014)
SiteEdit Pro Update Announcement (1997)
multi-paragraph fields (1997)
Listserver problem (1997)
Summ=T Problem (1997)
WebCatalog for guestbook ? (1997)
Tax Rates returns only 0.00 (2000)
Dealer locator (1998)
A multi-processor savvy WebCatalog? (1997)
Problem with updating 2.1b7 -> 2.1.1 (1998)
Maximum characters in header? (1999)
[WebDNA] A new popuated field to a DB with 700.000 records (2009)
Nested tags count question (1997)
Requiring that certain fields be completed (1997)