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:
Here's an example of an applet in a tpl (1997)
WebCatalog 3.0.4 alias crash bug? (2000)
displaying New products (Yikes! it's Fixed!) (1997)
Emailer Problem (2000)
Newbie problem blah blah blah (1997)
[WebDNA] Upgrade from OS 10.7.5 WebDNA 6.2 to Mavericks (2014)
webcat restarting script on Linux? (1999)
Group search doesn't work. (1997)
Spaces in sendmail (1998)
Redirect me home please? (2000)
Has anyone integrated ZipBurst with WebCat? (2000)
Help name our technology! I found it (1997)
Generating unique SKU from [cart] (1997)
PCS Emailer's role ? (1997)
[sendmail] on NT? (1997)
Too Much Rootbeer Free Offer (1997)
Order not created error (1997)
Duplicate Items in the Cart (1998)
multi-paragraph fields (1997)
security (1997)