Re: Can this be done?

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57244
interpreted = N
texte = 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Can this be done? ( "Jesse Crofoot" 2004)
  2. Re: Can this be done? ( Joe D'Andrea 2004)
  3. Re: Can this be done? ( charles kline 2004)
  4. Can this be done? ( "Jesse Crofoot" 2004)
  5. Re: Can this be done? ( Lester 2003)
  6. Re: Can this be done? ( Kenneth Grome 2003)
  7. Re: Can this be done? ( Gary Krockover 2003)
  8. Re: Can this be done? ( Lester 2003)
  9. Re: Can this be done? ( Kenneth Grome 2003)
  10. Re: Can this be done? ( Donovan Brooke 2003)
  11. Re: Can this be done? ( Lester 2003)
  12. Re: Can this be done? ( Tim Robinson 2003)
  13. Re: Can this be done? ( Tim Robinson 2003)
  14. Re: Can this be done? ( Lester 2003)
  15. Re: Can this be done? ( Tim Robinson 2003)
  16. Can this be done? ( Lester 2003)
  17. Re: Can this be done? (Kenneth Grome 1997)
  18. Re: Can this be done? (Grant Hulbert 1997)
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/ charles kline

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:

DataBaseHelper Flawed (1997) Trouble with formula.db (1997) [WebDNA] What file needs to be edited in apache to server html (2008) Nesting format tags (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Running 2 two WebCatalog.acgi's (1996) Requiring that certain fields be completed (1997) [/application] error? (1997) Protect (1997) Bug? (1997) WCS Newbie question (1997) Bug Report, maybe (1997) [WebDNA] PayPal Instant Payment Notification Guide (2009) List Last Word (2002) Cookie Crumble (1998) I think WebDNA-Talk died ... :( (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) WC2.0 Memory Requirements (1997) TaxTotal Problem (1997) Problems with date math (1997)