Thanks a lot rudy, I'll be implementing that today. I'm nearly finished with the classes and all...
Cheers Paul | -----Original Message----- | From: rudy [mailto:[EMAIL PROTECTED] | Sent: Thursday, January 08, 2004 4:36 PM | To: [EMAIL PROTECTED] | Subject: [wdvltalk] Re: Search Results Relevancy | | | > Rudy, | > You're a champion. You know that, right? Yes I'm sure you do... | | thanks for the kind words | | i try | | > Anyway, I'll try to implement that asap. Is that standard SQL? | | yes | | > Will that work in access2k and MySQL4?? | | in mysql, yes, in access, no (why are you not surprised?) | | in access you have to change the standard CASE expressions | to the microsoftian IIF expressions | | also, the wildcard in access is * instead of % | | select * | , iif( name like '*str1*', .50, 0 ) | + iif( desc like '*str2*', .30, 0 ) | + iif( features like '*str3*', .20, 0 ) | as relevancy | from tbl | where name like '*str1*' | or desc like '*str2*' | or features like '*str3*' | order | by relevancy | | | rudy | | ____ . The WDVL Discussion List from WDVL.COM . ____ | To Join wdvltalk, Send An Email To: | mailto:[EMAIL PROTECTED] | Send Your Posts | To: [EMAIL PROTECTED] | To set a personal password send an email to | [EMAIL PROTECTED] with the words: "set WDVLTALK | pw=yourpassword" in the body of the email. To change | subscription settings to the wdvltalk digest version: | http://wdvl.internet.com/WDVL/Forum/#sub | | ________________ http://www.wdvl.com _______________________ | | You are currently subscribed to wdvltalk as: | [EMAIL PROTECTED] To unsubscribe send a blank email to | %%email.unsub%% | | To unsubscribe via postal mail, please contact us at: | Jupitermedia Corp. | Attn: Discussion List Management | 475 Park Avenue South | New York, NY 10016 | | Please include the email address which you have been contacted with. | | | ____ � The WDVL Discussion List from WDVL.COM � ____ To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED] To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email. To change subscription settings to the wdvltalk digest version: http://wdvl.internet.com/WDVL/Forum/#sub ________________ http://www.wdvl.com _______________________ You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
