Re: Search and Change
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49254
interpreted = N
texte = HiIts been a long day and my Brain has definately died[Replace db=products.db&eqSKUdata=[sku]]thecats=[lookup db=sections.db&value=[listwords words=[selectedCategory]&delimiters=+] [text show=F]Searchword[Index]=[word][/text] [/listwords]&lookInField=S_ID&returnField=S_NAME¬Found=[url][selectedCate gory][/url] - [CountChars][selectedCategory][/CountChars]][/Replace]thecats Gives the not found value of +135+, i was using the Countchars to see, it give a value of 5 so my database entry is +135+ - 5What it should be is the result of the lookup of 135 in the sections.db which is Mobile PhonesI know its obvious buts its Monday and I have lost it!Thanks Paul ----- Original Message ----- From: Brian Boegershausen
To: WebDNA Talk Sent: Monday, April 07, 2003 5:25 PM Subject: Re: Search and Change > [listwords words=[YourField]&delimiters=+] > [text show=F]Searchword[Index]=[word][/text] > [/listwords] > > or if you want them in the same varaible without a + sign: > > [text show=F]Searchword=[listwords words=[YourField]&delimiters=+][word] > [/listwords][/text] > > > Brian > ----- Original Message ----- > From: Paul Berman > To: WebDNA Talk > Sent: Monday, April 07, 2003 11:19 AM > Subject: Re: Search and Change > > > > 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/ > > > > > ------------------------------------------------------------- > 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/
Associated Messages, from the most recent to the oldest:
HiIts been a long day and my Brain has definately died[Replace db=products.db&eqSKUdata=[sku]]thecats=[lookup db=sections.db&value=[listwords words=[selectedCategory]&delimiters=+] [text show=F]Searchword[Index]=[word][/text] [/listwords]&lookInField=S_ID&returnField=S_NAME¬Found=[url][selectedCate gory][/url] - [countchars][selectedCategory][/CountChars]][/Replace]thecats Gives the not found value of +135+, i was using the Countchars to see, it give a value of 5 so my database entry is +135+ - 5What it should be is the result of the lookup of 135 in the sections.db which is Mobile PhonesI know its obvious buts its Monday and I have lost it!Thanks Paul ----- Original Message ----- From: Brian Boegershausen To: WebDNA Talk Sent: Monday, April 07, 2003 5:25 PM Subject: Re: Search and Change > [listwords words=[YourField]&delimiters=+] > [text show=F]Searchword[Index]=[word][/text] > [/listwords] > > or if you want them in the same varaible without a + sign: > > [text show=F]Searchword=[listwords words=[YourField]&delimiters=+][word] > [/listwords][/text] > > > Brian > ----- Original Message ----- > From: Paul Berman > To: WebDNA Talk > Sent: Monday, April 07, 2003 11:19 AM > Subject: Re: Search and Change > > > > 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/ > > > > > ------------------------------------------------------------- > 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/
Paul Berman
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:
A question on sub-categories (1997)
[WebDNA] Mass email using WebDNA (2008)
Re:no [search] with NT (1997)
Best way to add data to .db (1999)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
How To question on setting up downloads (1997)
[ShowNext] (1997)
shownext (1997)
Browser Check for WebDNA compatability (1999)
searching multiple databases in single search (1997)
Re(2): Share Bulletin Board? (1998)
question: Eudora 3.1.1 (1997)
format_to_days on NT (1997)
Re:Merging databases (1997)
WebCatalog as a ListServ (1998)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
Generating and appending SKU to a db automatically (1998)
Single Link browsing (1997)
Merging databases (1997)