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 MitchellE-Business Specialist, PrintWest / PW Group Ltd.Saskatoon, SK CANADATel: (306) 665-3557Toll-free: (800) 291-9935Fax: (306) 653-1255E-Mail: d.mitchell@pwgroup.caWeb: 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:
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 MitchellE-Business Specialist, PrintWest / PW Group Ltd.Saskatoon, SK CANADATel: (306) 665-3557Toll-free: (800) 291-9935Fax: (306) 653-1255E-Mail: d.mitchell@pwgroup.caWeb: 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)