Re: Need help!! on searching in two databases.
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19616
interpreted = N
texte = >I want to find all records matching an id number in the first table, the >sort all the found records _alphabetically_ based on the name related to >the id number in the second table. By doing it the way it is described in >the link above, I am not able to do so. The order is determined in the >first search.I must not understand what you're trying to do. What's wrong with telling the interior [search] to sort?>This DOES work when the search doesnt >return to many records, and its pretty fast to, but when the first search >returns about 50 records or more, the second search returns more records >than the first. And this should surely not be so. Is there a way around >this, or is this a misbehaveour of webcatalog?Probably it is accidentally finding substrings of text that *happen* to match. Try adding
WORD=ww to force only Whole Word matches.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I want to find all records matching an id number in the first table, the >sort all the found records _alphabetically_ based on the name related to >the id number in the second table. By doing it the way it is described in >the link above, I am not able to do so. The order is determined in the >first search.I must not understand what you're trying to do. What's wrong with telling the interior [search] to sort?>This DOES work when the search doesnt >return to many records, and its pretty fast to, but when the first search >returns about 50 records or more, the second search returns more records >than the first. And this should surely not be so. Is there a way around >this, or is this a misbehaveour of webcatalog?Probably it is accidentally finding substrings of text that *happen* to match. Try adding WORD=ww to force only Whole Word matches.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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:
Make sure I understand this??? (1997)
The beginning (1997)
really wierd browser truncating (1997)
Why would prices no appear in cart (2000)
RE: Signal Raised (1997)
Spell Check (2000)
WebCatalog 2.0 b 15 mac (1997)
WebCatalog Hosting (1996)
Need help with emailer- 2 issues (1997)
shipCost problems (2000)
2cd pair of eyes please. (2003)
[OT] XServe networking PITA (2004)
Shipping charges depending on tax rate? (1997)
Range Comparisons (2000)
Error Log (2000)
Blog Aggregator (2006)
Show shoppingcart after remove last item (1997)
Only charge card when product shipped ? (1997)
[WebDNA] WebDNA on W2k3 (2009)
Relay link (2002)