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 SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
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 SoftwareeCommerce / 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)