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 AM Subject: 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 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/ > ------------------------------------------------------------- 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)
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 AM Subject: 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 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/ > ------------------------------------------------------------- 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)