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:

Problems with [Applescript] (1997) Cookies and webcat (1997) Size of a folder? (2003) Webcat interfering with Webstar? (1998) Emailer Problem (1999) Another bug to squash (WebCat2b13 Mac .acgi) (1997) question: webmerchant connection (1997) emailer w/F2 (1997) FORMS: Returning a specific page (1997) MacOS X upgrade pricing plan (1999) Navigator 4.01 (1997) Emailer (WebCat2) (1997) [WebDNA] Sendmail on a one page website..... (2013) Running 2 two WebCatalog.acgi's (1996) href name= link from dynamic URL possible? (1998) $Append for Users outside the ADMIN group (1997) TeaRoom Order fields email account remain empty even though thewy are filled. (1997) Release of 2.01? (1997) weird G3 happenings (1998) Calculating UPS Shipping (1999)