Re: Feature req.

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41704
interpreted = N
texte = Well, you could have a single database of date conversions in globals, and use it everywhere you did a conversionEx 13 three third Wed Wednesday Then you could convert [date %d] to three or third or Wed depending on your moodYou can't really use format here, if for example you got a db from an (unamed stupid source) with 'March 3,5,9' as a 'date' (and sometimes we can't control how the data comes to us.)You could get real fancy and put things like 'offset' currently used in the dayplanner in there too.Ex 2I want to convert hex colors to 'friendly' names to display to the user. But write the hex to the db. Currently I use a database like>From to Red FF0000 FF0000 RedIt would cut the size of the db in half and I think make it easier if I could name those fields 'friendly' and 'hex' (or whatever the programmer choses)ex3 is that I have a real estate DB with like 10 separate conversion databases that could probably be combined into one. Just making it simpler to remember in eight months which db does what. (particularly when you often have two doing virtually the same thing. ex4 is that sometimes you want to convert more than one thingCity county state Seattle King WASo now you could convert seattle to 'king', but you'd have to either make a new DB or double the data to convert seattle to waYou can't really use search for this, because if you had a list of seattle,tacoma,yakimaYou'd have to do a listwords, then a lookup to get a list of counties Like: king,pierce,yakima On 7/18/02 9:01 AM, John Peacock mashed the following keys :> Aaron Lynch wrote: >> What if you could: >> [convertwords words=[words]&db=some.db&from=fromfield&to=tofield] ? >> > > Could you show us an example of how you visualize this working; I have no idea > what you are suggesting (but that may be me)? I don't know what problem you > are > trying to solve. > > FWIW, having more DB's open is not (in general) a bad thing; if you have more > databases but no duplicated data, this is called normalized databases. This > is > a Good Thing (TM). > > John ------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Feature req. (Kenneth Grome 2002)
  2. [table] (was Re: Feature req.) (Rob Marquardt 2002)
  3. Re: Feature req. (Brian Fries 2002)
  4. Re: Feature req. (Andrew Simpson 2002)
  5. Re: Feature req. (Scott Anderson 2002)
  6. Re: Feature req. (Andrew Simpson 2002)
  7. Re: Feature req. (Donovan Brooke 2002)
  8. Re: Feature req. (Donovan Brooke 2002)
  9. Re: Feature req. (Scott Anderson 2002)
  10. Re: Feature req. (Kenneth Grome 2002)
  11. Re: Feature req. (Kenneth Grome 2002)
  12. Re: Feature req. (Alain Russell 2002)
  13. Re: Feature req. (Scott Anderson 2002)
  14. Re: Feature req. (Brian Fries 2002)
  15. Re: Feature req. (Clint Davis 2002)
  16. Re: Feature req. (Stuart Tremain 2002)
  17. Re: Feature req. (Kenneth Grome 2002)
  18. Re: Feature req. (John Peacock 2002)
  19. Re: Feature req. (Jesse Williams-Proudman 2002)
  20. Re: Feature req. (John Peacock 2002)
  21. Re: Feature req. (Brian Fries 2002)
  22. Re: Feature req. (dale's stuff 2002)
  23. Re: Feature req. (Jesse Williams-Proudman 2002)
  24. Re: Feature req. (John Peacock 2002)
  25. Re: Feature req. (Aaron Lynch 2002)
  26. Re: Feature req. (Nitai @ ComputerOil 2002)
  27. Re: Feature req. (John Peacock 2002)
  28. Re: Feature req. (Jesse Williams-Proudman 2002)
  29. Re: Feature req. (Brian Fries 2002)
  30. Re: Feature req. (Nitai @ ComputerOil 2002)
  31. Feature req. (Aaron Lynch 2002)
Well, you could have a single database of date conversions in globals, and use it everywhere you did a conversionEx 13 three third Wed Wednesday Then you could convert [date %d] to three or third or Wed depending on your moodYou can't really use format here, if for example you got a db from an (unamed stupid source) with 'March 3,5,9' as a 'date' (and sometimes we can't control how the data comes to us.)You could get real fancy and put things like 'offset' currently used in the dayplanner in there too.Ex 2I want to convert hex colors to 'friendly' names to display to the user. But write the hex to the db. Currently I use a database like>From to Red FF0000 FF0000 RedIt would cut the size of the db in half and I think make it easier if I could name those fields 'friendly' and 'hex' (or whatever the programmer choses)ex3 is that I have a real estate DB with like 10 separate conversion databases that could probably be combined into one. Just making it simpler to remember in eight months which db does what. (particularly when you often have two doing virtually the same thing. ex4 is that sometimes you want to convert more than one thingCity county state Seattle King WASo now you could convert seattle to 'king', but you'd have to either make a new DB or double the data to convert seattle to waYou can't really use search for this, because if you had a list of seattle,tacoma,yakimaYou'd have to do a listwords, then a lookup to get a list of counties Like: king,pierce,yakima On 7/18/02 9:01 AM, John Peacock mashed the following keys :> Aaron Lynch wrote: >> What if you could: >> [convertwords words=[words]&db=some.db&from=fromfield&to=tofield] ? >> > > Could you show us an example of how you visualize this working; I have no idea > what you are suggesting (but that may be me)? I don't know what problem you > are > trying to solve. > > FWIW, having more DB's open is not (in general) a bad thing; if you have more > databases but no duplicated data, this is called normalized databases. This > is > a Good Thing (TM). > > John ------------------------------------------------------------- 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://search.smithmicro.com/ Aaron Lynch

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:

Kaaaaahhhhhhhnnnnnnn! (1997) SiteEdit NewFile.html ? (1997) Interfacing WebMerchant to www.fedex.com (1997) EIMS & emailer conflicts? (1999) Which is Faster (1998) Email Formatting and Encryption (1998) Note added to [sendmail] in Docs (2004) Uploading files with 3.0/4.0 (2000) Multiple Merchant Accounts? (1997) Plugin or CGI or both (1997) same bill to and ship to? (1998) forms and variables (1998) NewCart+Search with one click ? (1997) no template caching (1997) Getting total number of items ordered (1997) [tcp connect]-dumb question? (1998) Date Sorting (1997) [WebDNA] SMTP via gmail is NOT POSSIBLE (2013) Problem: 3.0 doesn't update carts (1997) Webcat data and graphing (2000)