Re: Problems with [Search] param - Mac Plugin b15
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10682
interpreted = N
texte = Two things that I noticed that would explain your results:1. make the category search required (it must match) by appending rq toit: eqcategorydatarq=...2. because of our sophisticated ranking, not all the records may rankequally. Only equally ranked records are sorted. For all the results to beranked the same by setting the maximum hit count for each record to be1: &allhit=1 (append to the end).Hope this helps.John.>I am trying to get the search to pull from certain catagories, that the>time and date are equal to or less then the current time and date, and sort>them by the time and date.>>I am currently running the b15 plugin.>>Here is the code I am using:>>[search db=News.db&eqCatagoryData=2&leReleaseDateData=[DATE>%Y%m%d]&leReleaseTimeData=[TIME>%H%M%S]&max=10&ReleaseTimesort=2&ReleaseDatesort=1&ReleaseDateType=num&ReleaseT>i>meType=num]>[founditems][Title]
[/founditems][/search]>>What is happening when I do this is it returns everything in the database,>it does not look to see if the catagory data is equal to 1, 2, 3 or>anything, and it is not sorting it at all.>>BTW, has anyone tried WebCat with WebTen yet? If so, any success stories?>>TIA.>>----------------------------->Britt T.>>Britt@fishingworld.com>Britt@easttexas.com>>World Masters - Web Design,>Maintenance and Hosting>>Phone: (903) 882-8877>Fax: (903) 882-3110John A. Hill, V.P. Marketing *********************************Pacific Coast Software * Home of the Web's best11770 Bernardo Plaza Ct. #462 * Catalog and Merchant softwareSan Diego, CA 92128 * http://www.smithmicro.comPhone: 619-675-1106 Fax: 675-0372 *********************************
Associated Messages, from the most recent to the oldest:
Two things that I noticed that would explain your results:1. make the category search required (it must match) by appending rq toit: eqcategorydatarq=...2. because of our sophisticated ranking, not all the records may rankequally. Only equally ranked records are sorted. For all the results to beranked the same by setting the maximum hit count for each record to be1: &allhit=1 (append to the end).Hope this helps.John.>I am trying to get the search to pull from certain catagories, that the>time and date are equal to or less then the current time and date, and sort>them by the time and date.>>I am currently running the b15 plugin.>>Here is the code I am using:>>[search db=News.db&eqCatagoryData=2&leReleaseDateData=[DATE>%Y%m%d]&leReleaseTimeData=[TIME>%H%M%S]&max=10&ReleaseTimesort=2&ReleaseDatesort=1&ReleaseDateType=num&ReleaseT>i>meType=num]>
[founditems][Title]
[/founditems][/search]>>What is happening when I do this is it returns everything in the database,>it does not look to see if the catagory data is equal to 1, 2, 3 or>anything, and it is not sorting it at all.>>BTW, has anyone tried WebCat with WebTen yet? If so, any success stories?>>TIA.>>----------------------------->Britt T.>>Britt@fishingworld.com>Britt@easttexas.com>>World Masters - Web Design,>Maintenance and Hosting>>Phone: (903) 882-8877>Fax: (903) 882-3110John A. Hill, V.P. Marketing *********************************Pacific Coast Software * Home of the Web's best11770 Bernardo Plaza Ct. #462 * Catalog and Merchant softwareSan Diego, CA 92128 * http://www.smithmicro.comPhone: 619-675-1106 Fax: 675-0372 *********************************
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:
Repeating Fields (1997)
Popup Menu Options (1998)
Security & Query Strings (2004)
[WebDNA] OS Maverick, Server App and WebDNA 6.2 (2013)
Email notification to one of multiple vendors ? (1997)
Emailer help....! (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Taxes shipcost (2003)
External RAID (2005)
Is there an easier way? (1998)
Encyption mail was Suggestions for Topics ... (1998)
WebCat for mass emailings (1997)
[ot] Bluetooth Phones That Allow SSH (2004)
Trouble with adding multiple items to cart (1999)
Multiple SSL Keys (1998)
WebCatalog for guestbook ? (1997)
Re:Merging databases (1997)
question about checkboxes (1999)
Laying an egg. (1998)
Safe command=append (1999)