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:
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:
ListFiles (1998)
Press Release hit the NewsWire!!! (1997)
Talk List Suggestions (1997)
[Capitalize] (1998)
Looking for WebCat developer/contractor (2000)
system crashes, event log (1997)
how to do multiple prices/item? (1998)
WebCat2 several catalogs? (1997)
[OT] Changing permissions on W2003 via FTP (2007)
Virtual hosting and webcatNT (1997)
Multiple prices (1997)
Multiple prices (1997)
[REQ] Improved SQL context (2000)
If Empty ? (1997)
WebMerchant (1997)
[WebDNA] Sandbox question (2009)
typo in docs (2000)
Error Lob.db records error message not name (1997)
Discounts (1998)
CART question (2004)