Re: Search and Change
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49255
interpreted = N
texte = Your lookup is all wrong. Put it with in the listwords, not around it.[listwords words=[lookup statement here] [/listwords]----- Original Message -----From: Paul Berman
To: WebDNA Talk Sent: Monday, April 07, 2003 11:40 AMSubject: Re: Search and Change> Hi>> Its 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+ - 5>> What it should be is the result of the lookup of 135 in the sections.db> which is Mobile Phones>> I 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 fieldand> > > using the result to search a database> > >> > > At the moment when I look up the section from my products.db itreturns,> > > +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 yearsago> > > > > 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/>-------------------------------------------------------------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:
Your lookup is all wrong. Put it with in the listwords, not around it.[listwords words=[lookup statement here] [/listwords]----- Original Message -----From: Paul Berman To: WebDNA Talk Sent: Monday, April 07, 2003 11:40 AMSubject: Re: Search and Change> Hi>> Its 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+ - 5>> What it should be is the result of the lookup of 135 in the sections.db> which is Mobile Phones>> I 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 fieldand> > > using the result to search a database> > >> > > At the moment when I look up the section from my products.db itreturns,> > > +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 yearsago> > > > > 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/>-------------------------------------------------------------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/
Brian Boegershausen
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:
The evolved Server Configuration Queston (2000)
Locking up with WebCatalog... (1997)
syntax question, not in online refernce (1997)
Subject: Authenticating users without dialog box (1997)
Hiding HTML and page breaks (1997)
hideif glitch (2003)
More than one db with the same namn (was: WC2f3) (1997)
WebCat2 beta 11 - new prefs ... (1997)
Logging purchases (1997)
OT: Processor Speed (2002)
More on the email templates (1997)
Emailer setup (1997)
RE: ASP and Web DNA (1998)
WebCat2b12plugin - [search] is broken ... not! (1997)
[UPPERCASE] (1997)
Bug Report, maybe (1997)
Requiring that certain fields be completed (1997)
simple answer? [hideif] (1997)
WebCatalog can't find database (1997)
emailer on Windows Beta 18 (1997)