Re: Search and Change

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49252
interpreted = N
texte = Take the results of your search and stick it in a text variable (for example, search_results), then try this:[listwords words=[search_results]&delimiters=+] [text]section[index]=[word][/text] [/listwords]So with your values you would end up with:[section1]=135 [section2]=1>Hi > >I need to find a quick and simple way of removing the + from a field and >using the result to search a database > >At the moment when I look up the section from my products.db it returns, >+135+1+ > >What I need is to take the 135 and the1 and search for them in another >database > >Any ideas appreciated > >Thanks >Paul >----- Original Message ----- >From: Donovan >To: WebDNA Talk >Sent: Monday, April 07, 2003 4:31 PM >Subject: Re: Capitalize > > >> the Mc's like: >> McGhie >> McCann >> McCormick >> >> I suppose if you wanted to gather a list you could use [convertwords db=] >> >> Donovan >> >> >> John Peacock wrote: >> >> > Stuart Tremain wrote: >> > >> >> Is there a way that O'Connor will show correctly, ie not O'connor >> >> when using [Capitalize] >> >> >> > >> > I had an extensive 'discussion' with Grant about this some years ago >> > and the end result was there was too many ways to mess it up (think >> > Don'T as a good counter example). You'll have to ask the user to key >> > in the proper capitalization in the first place. >> > >> > John >> >> -- >> -Donovan Brooke >> -Administrator of IT / >> -Assc. Art Director >> -Creative Services >> -Epsen Hillmer Graphics >> >> >> >> >> ------------------------------------------------------------- >> 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/ -- Daryl Mitchell E-Business Specialist, PrintWest / PW Group Ltd. Saskatoon, SK CANADA Tel: (306) 665-3557 Toll-free: (800) 291-9935 Fax: (306) 653-1255 E-Mail: d.mitchell@pwgroup.ca Web: http://www.pwgroup.ca/------------------------------------------------------------- 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: Search and Change (Paul 2003)
  2. Re: Search and Change (John Peacock 2003)
  3. Re: Search and Change (Brian Boegershausen 2003)
  4. Re: Search and Change (Paul Berman 2003)
  5. Re: Search and Change (Daryl Mitchell 2003)
  6. Re: Search and Change (Brian Boegershausen 2003)
  7. Re: Search and Change (Paul Berman 2003)
Take the results of your search and stick it in a text variable (for example, search_results), then try this:[listwords words=[search_results]&delimiters=+] [text]section[index]=[word][/text] [/listwords]So with your values you would end up with:[section1]=135 [section2]=1>Hi > >I need to find a quick and simple way of removing the + from a field and >using the result to search a database > >At the moment when I look up the section from my products.db it returns, >+135+1+ > >What I need is to take the 135 and the1 and search for them in another >database > >Any ideas appreciated > >Thanks >Paul >----- Original Message ----- >From: Donovan >To: WebDNA Talk >Sent: Monday, April 07, 2003 4:31 PM >Subject: Re: Capitalize > > >> the Mc's like: >> McGhie >> McCann >> McCormick >> >> I suppose if you wanted to gather a list you could use [convertwords db=] >> >> Donovan >> >> >> John Peacock wrote: >> >> > Stuart Tremain wrote: >> > >> >> Is there a way that O'Connor will show correctly, ie not O'connor >> >> when using [capitalize] >> >> >> > >> > I had an extensive 'discussion' with Grant about this some years ago >> > and the end result was there was too many ways to mess it up (think >> > Don'T as a good counter example). You'll have to ask the user to key >> > in the proper capitalization in the first place. >> > >> > John >> >> -- >> -Donovan Brooke >> -Administrator of IT / >> -Assc. Art Director >> -Creative Services >> -Epsen Hillmer Graphics >> >> >> >> >> ------------------------------------------------------------- >> 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/ -- Daryl Mitchell E-Business Specialist, PrintWest / PW Group Ltd. Saskatoon, SK CANADA Tel: (306) 665-3557 Toll-free: (800) 291-9935 Fax: (306) 653-1255 E-Mail: d.mitchell@pwgroup.ca Web: http://www.pwgroup.ca/------------------------------------------------------------- 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/ Daryl Mitchell

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:

New to WebDNA.. Dreamweaver Extensions? (2005) [convertchars] on potential malicious input even in a link? (2000) RE: EXTERNAL EMAIL: RE: [WebDNA] [BULK] SQL ODBC 00000 Error (2019) Share Bulletin Board? (1998) [cart] not being interpreted inside [founditems] (1997) Anyone integrate askimet with webdna? (2007) Sorting by date (1997) weird G3 happenings (1998) Setting up shop (1997) Can't Search field (1998) Summary search -- speed (1997) Order not created error (never mind) (1997) listfiles sort by moddate (2002) WC2.0 Memory Requirements (1997) multi condition with showif (2005) [WebDNA] Dealing with age and birth day (2017) Strange search... (2001) RAM variables (1997) Running on Empty (1999) MacWEEK article help needed (1996)