Re: ConverChars
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23819
interpreted = N
texte = >I don't actually want to replace the value in the database itself. I have >simplified the logic to using only one character, so now all I am really >trying to do is something like the following:OK, so when you said I need to convert some of my database fields from a text string to a '1' you didn't really mean it? ;)Anyway, I am reading between the lines on your recent postings and getting the idea that maybe you've got some idea in mind about how something should work, and perhaps there's a different way built into WebCatalog that solves your need. I'd hate to think that we're all trailing down this path trying to convert your database fields when there's some better way to solve your *real* need. It would help to know in plain english what you're trying to accomplish.And to answer your original question, there is indeed a way to translate a single long string of text into another one. Use a lookup in a database like so:-- WordMapper.db -- BigWord LittleWord FunBoard 1 DogFood 2 SleepyTech 3[lookup db=WordMapper.db&lookInField=BigWord&value=FunBoard&returnField=LittleWord]The lookup here will return 1, but you can change FunBoard to [fieldname] to get anything you like.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I don't actually want to replace the value in the database itself. I have >simplified the logic to using only one character, so now all I am really >trying to do is something like the following:OK, so when you said I need to convert some of my database fields from a text string to a '1' you didn't really mean it? ;)Anyway, I am reading between the lines on your recent postings and getting the idea that maybe you've got some idea in mind about how something should work, and perhaps there's a different way built into WebCatalog that solves your need. I'd hate to think that we're all trailing down this path trying to convert your database fields when there's some better way to solve your *real* need. It would help to know in plain english what you're trying to accomplish.And to answer your original question, there is indeed a way to translate a single long string of text into another one. Use a lookup in a database like so:-- WordMapper.db -- BigWord LittleWord FunBoard 1 DogFood 2 SleepyTech 3[lookup db=WordMapper.db&lookInField=BigWord&value=FunBoard&returnField=LittleWord]The lookup here will return 1, but you can change FunBoard to [fieldname] to get anything you like.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Showing once on a founditems (1997)
not interpreting Q (2001)
Anyone have a one-to-one messageing system? (1999)
listword db bolding (2002)
Clearing orders and database help! (1997)
unitshipcost vs shipcosts (1997)
Ok here is a question? (1997)
[WebDNA] Adding Graphics to Directory (2009)
NT beta ReadMe missing (b12-b15) (1997)
Running _every_ page through WebCat ? (1997)
WebCat2 as a chat server? (1997)
[format 40s]text[/format] doesn't work (1997)
Emailer update for Mac? (1998)
absolute paths for databases? (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Help!!!! (1997)
WebDNA Feature Request (2006)
Showif Error Generated... (2003)
Protect (1997)
New Command prefs ... (1997)