Re: Commas in search

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 15915
interpreted = N
texte = 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)
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 John Hill

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:

Pricing (1998) Bug when including a db file ... ? (2000) Need help... (1997) Re:Emailer and encryption (1997) Download URL & access on the fly ? (1997) [WebDNA] Secure Cookies (2009) Mozilla/4. and Browser Info.txt (1997) Re:multiple digests, please stop (1997) problems with 2 tags (1997) no global [username] or [password] displayed ... (1997) Cart Numbers (1997) EIMS Problems (1997) Email Format (1998) Good vs. Bad; also [setHeader] (2002) OSX 10.2.6/iTools 7.0/WebDNA 5.0 installation (2003) WebCatalog2 for NT Beta Request (1997) Attn: Bug in GeneralStore example b15 (1997) automatically updating all records, one by one in a db (2000) SiteEdit NewFile.html ? (1997) PCS Frames (1997)