Re: Replacing a Word

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24404
interpreted = N
texte = Anup Setty wrote:> Hi, > Can anyone help me with this problem? > I need to write the data from a textarea into the database, while > I am doing that, I want to replace a word with an html tag. > The text from the textarea has [image] and when I write in the > database I want it replaced by > > [image] = > > thanks > > anup > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 This is tough, since Webcat has no true string manipulation tools. Assuming there is no more than one occurance of [image] in any given field, this should work:I assume your database is named database.db, the field it is to be written to is called field, and your string is currently stored in a textvariable called [text]variable[/text][text show=f]appended=yes[/text] [showif [text]variable[/text]^[raw][image][/raw]] [append db=database.db]field=[middle startafter=&endbefore=[raw][image][/raw]][text]variable[/text][/middle][middle startafter=[raw][image][/raw]&endbefore=][text]variable[/text][/middle][/append] [text show=f]appended=yes[/text] [/showif] [showif [text]appended[/text]=no] [append db=database.db]field=[text]variable[/text][/append] [/showif]If a variable could contain more than one instance of [image], something much more complex would be required. Contact me if you require this, and I'll have a look.Good luck,Derrick ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Replacing a Word (Anup Setty 1999)
  2. Re: Replacing a Word (Brian Boegershausen 1999)
  3. Replacing a Word (Anup Setty 1999)
  4. Re: Replacing a Word (Anup Setty 1999)
  5. Re: Replacing a Word (Rob Marquardt 1999)
  6. Re: Replacing a Word (Anup Setty 1999)
  7. Re: Replacing a Word (Derrick Puckett 1999)
  8. Re: Replacing a Word (Derrick Puckett 1999)
  9. Re: Replacing a Word (Jesse Williams Proudman 1999)
  10. Re: Replacing a Word (Derrick Puckett 1999)
  11. Replacing a Word (Anup Setty 1999)
Anup Setty wrote:> Hi, > Can anyone help me with this problem? > I need to write the data from a textarea into the database, while > I am doing that, I want to replace a word with an html tag. > The text from the textarea has [image] and when I write in the > database I want it replaced by > > [image] = > > thanks > > anup > > ------------------------------------------------------------- > Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. > To end your Mail problems go to . > > 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 This is tough, since Webcat has no true string manipulation tools. Assuming there is no more than one occurance of [image] in any given field, this should work:I assume your database is named database.db, the field it is to be written to is called field, and your string is currently stored in a textvariable called [text]variable[/text][text show=f]appended=yes[/text] [showif [text]variable[/text]^[raw][image][/raw]] [append db=database.db]field=[middle startafter=&endbefore=[raw][image][/raw]][text]variable[/text][/middle][middle startafter=[raw][image][/raw]&endbefore=][text]variable[/text][/middle][/append] [text show=f]appended=yes[/text] [/showif] [showif [text]appended[/text]=no] [append db=database.db]field=[text]variable[/text][/append] [/showif]If a variable could contain more than one instance of [image], something much more complex would be required. Contact me if you require this, and I'll have a look.Good luck,Derrick ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Derrick Puckett

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:

woops - speed results - right subject (2002) Beta (?) version of WebCatalog 2.1 (1998) Resume Catalog ? (1997) Migrating 4.0.2 to 4.5 (2002) How to append text after the sign & (1997) Variables (1999) RAM variables (1997) Grouping search fields, etc. (1997) Help! WebCat2 bug (1997) Question about links (1999) Line items in table cells (1997) Multiple fields on 1 input (1997) WebCatalog seems to choke on large (2meg) html files. (1998) Database Here, Web Site There (2001) reading a email (2000) Which GUI HTML editors work with WC ? (1997) Zip Code Lookups (1999) Nesting format tags (1997) More on the email templates (1997) [WebDNA] API Integration (2010)