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:

Problems with [Search] param - Mac Plugin b15 (Britt T. 1997) Re: Problems with [Search] param - Mac Plugin b15 (John Hill 1997)

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:

Multiple catalog databases and showcart (1997) [WebDNA] Paypal Cert (2015) Re[2]: 2nd WebCatalog2 Feature Request (1996) Country & Ship-to address & other fields ? (1997) Sorting by date (1997) Banners (1997) WebCatalog/Mac 2.1b2 - PIXO (1997) Server Freeze (1998) [WebDNA] Basic Search (2008) problems with 2 tags shakur (1997) can WC render sites out? (1997) More on the email templates (I like it) (1997) Search for dates greater than [date] (1997) Search multiple fields (1997) WebDNA 4.5.1 on OSx 10.4 (2005) Error with [applescript] (1999) I'm new be kind (1997) 'RequiredField' Question (1998) Help name our technology! I found it (1997) lockup db's (2000)