Re: Commas in search

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 15911
interpreted = N
texte = Perfect! ws inplace of eq finds the info with no problem.Thanx, Mike At 08:50 AM 1/5/98 -0800, you wrote: >Michael: > >There's nothing wrong with the code you posted (from what I could see). The search routines will look for an exact match (case insensitive) to the text (including commas): CYCLE, MOPED RENTALS. Is it possible that there are not any fields that match this exactly (they might have additional spaces or words). A quick test is to use ws instead of eq. This finds all sub-string matches within the field. I hope this helps. > >John. > >>Aloha: >> >>I'm searching a field which contains commas in its data and nothing shows >>up in the results. Is this because I'm using a comma in the search and >>WebCat can't handle that? I can always change the commas to a / but I was >>wondering if this is a limitition of WebCat. >> >>Here's the code: >> >>>HREF=dhtranresults.tpl?command=search&db=listings/dbs/transportation.db&eqh >>ead1datarq=[URL]CYCLE, MOPED RENTALS[/URL]&companysort=1 >>target=content>CYCLE, MOPED RENTALS >> >>Thanx for any help ahead of time, >>Mike >>------------------------------------------------------------ >>Michael DeLorenzo (v)(808)539-3932 >>Manager of Website Creation mailto:delo@worldpoint.com >>WorldPoint http://www.worldpoint.com > > > John A. Hill, V.P. Marketing > Pacific Coast Software >eCommerce / Web Developer Tools > http://www.smithmicro.com > > > > Associated Messages, from the most recent to the oldest:

    
  1. Re: Commas in search (John Hill 1998)
  2. Re: Commas in search (Sandra L. Pitner 1998)
  3. Re: Commas in search (Michael A. DeLorenzo 1998)
  4. Commas in search (Michael A. DeLorenzo 1998)
Perfect! ws inplace of eq finds the info with no problem.Thanx, Mike At 08:50 AM 1/5/98 -0800, you wrote: >Michael: > >There's nothing wrong with the code you posted (from what I could see). The search routines will look for an exact match (case insensitive) to the text (including commas): CYCLE, MOPED RENTALS. Is it possible that there are not any fields that match this exactly (they might have additional spaces or words). A quick test is to use ws instead of eq. This finds all sub-string matches within the field. I hope this helps. > >John. > >>Aloha: >> >>I'm searching a field which contains commas in its data and nothing shows >>up in the results. Is this because I'm using a comma in the search and >>WebCat can't handle that? I can always change the commas to a / but I was >>wondering if this is a limitition of WebCat. >> >>Here's the code: >> >>>HREF=dhtranresults.tpl?command=search&db=listings/dbs/transportation.db&eqh >>ead1datarq=[url]CYCLE, MOPED RENTALS[/URL]&companysort=1 >>target=content>CYCLE, MOPED RENTALS >> >>Thanx for any help ahead of time, >>Mike >>------------------------------------------------------------ >>Michael DeLorenzo (v)(808)539-3932 >>Manager of Website Creation mailto:delo@worldpoint.com >>WorldPoint http://www.worldpoint.com > > > John A. Hill, V.P. Marketing > Pacific Coast Software >eCommerce / Web Developer Tools > http://www.smithmicro.com > > > > Michael A. DeLorenzo

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:

[LOOKUP] (1997) Using WC for Bulk Emailings (1997) using showpage and showcart commands (1996) Templates for Customer Database? (1997) Extended [ConvertChars] (1997) [WebDNA] Emailer breaking format (2015) oops private message leaked into talk list (1997) slow site (2003) WebTen and WebCat (1997) [cart]'s ever get recycled? (2000) Hide Cart ID in URL? (2003) WebCat2 several catalogs? (1997) Snippet for finding unused Header Fields in the Orders.db (2003) Site Search Concepts (2003) Re:EMail not being sent (1999) [WebDNA] params_string ? (2011) Mac 2.1b2 speed (1997) switching users (1998) validatin on NT (1998) WebCat2b13MacPlugin - nested [xxx] contexts (1997)