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:
Updating fields from different platforms (1998)
[cart] not being interpreted inside [founditems] (1997)
Can you do this??? and other stuff (1997)
[WebDNA] decrypt appears to be hosed (2008)
Erotic Sites (1997)
FREE Stuff .. (2003)
Configuring E-mail (1997)
All questions are welcome on this list (1997)
Error handling for accountNum (1997)
Initiating NewCart (1997)
WebCat2: multiple currency support (1997)
price change help (1998)
Re:2nd WebCatalog2 Feature Request (1996)
carriage returns in data (1997)
WebCat2: Items xx to xx shown, etc. (1997)
5.0 feature request: Sort for ListWords (2001)
WebCatalog.acgi quitting with error Type 2 (1998)
Limitations on fields? Server is crashing (1997)
shipping costs (1999)
possible, WebCat2.0 and checkboxes-restated (1997)