Re: In theory - an alternative way to sort results
Les Mizzell wrote: >> OK, "results.narrative" isn't really a list, but a SQL "text" cell. > > Whoops - I lied. It's an nTEXT field. Found the problem - for some reason, "n" type fields won't display locally (? - ideas anyboyd - ?), but they will out on the production server. Once I moved a test file to the production server, it worked. So, now everybody gets sorted by the number of time a keyword appears in their bio first, then last/first names. Query Object to the rescue! Yeppers! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
> OK, "results.narrative" isn't really a list, but a SQL "text" cell. Whoops - I lied. It's an nTEXT field. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - an alternative way to sort results
OK, first steps to getting this to work are going well. I can run the search, set a query object, and do a CFDUMP and my expected results are there. The only problem I'm having is setting my keyCOUNT variable. The above always returns zero, regardless of what I do. OK, "results.narrative" isn't really a list, but a SQL "text" cell. But, I figured I could treat it as a large list with spaces as delimiters. Guess not. So, what do I need to do to count the number of times "req.srch" appears in "#results.narrative#" ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
> Not joking, I would'n take the responsibility of such a political issue. > Ask them to define themselves what the rank of every one should have, Well, management at the law firm has now said "I don't want those egotist controlling their rank, do a count on the search term and rank by that". (Exact quote!!!) So, there ya go, the word comes down from on high. OK, so back to my original question - do a count, read that back into a new query object, and sort from there? Or is there a better way? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
>>Does that sound like an idea, or can somebody think of a better way to do this? Tell them you must enter their earnings in the table so you can sort the list in "order of work" they do, may be they will forget about their request ;-)) Not joking, I would'n take the responsibility of such a political issue. Ask them to define themselves what the rank of every one should have, enter this rank in the table, and let to them the task to maintain this ranking system up to date. Soon, they will ask you to go back to the alphabetical list. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
On Friday 20 Jun 2008, Bilal Soylu wrote: > idea of looking into a bio and determine ranking by wording, it may be more > advisable to let the Attorneys (or whomever) determine their own rankings > by practice area and keywords among themselves and you staying safely out Yup - it sounds like there is knowledge in these guys (and gals!) heads about who is 'best' at certain things - reach in and drag it out into your application. -- Tom Chiverton, reading 'World War Z', does it show ? This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - an alternative way to sort results
Les, unfortunately when it comes to Egos the order that you determine is normally only roughly related to the order desired. Thus, though I like the idea of looking into a bio and determine ranking by wording, it may be more advisable to let the Attorneys (or whomever) determine their own rankings by practice area and keywords among themselves and you staying safely out of the fight. Then you can establish a ranking by subject (keywords) table: Attorney Subject Ranking You should be able to easily join and display the list by Ranking (high to low) and last name. Cheers, Bilal ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
In theory - an alternative way to sort results
Attorneys and their egos! Sheesh! I've got a search function (standard queries) on a site that looks for keywords in a number of fields/tables to return a list of attorneys associated with that keyword. Results are sort alphabetically. But, a couple of folks with big heads are going, "Hey, I do more work in that area than Bob does, and I want my name first on the list when you search for that"! Oh boy - so, after some head scratching, if I count the instances of the search term (keyCOUNT) in their attorney bio, and figure out how to sort by that first, and then the last name, it should do the trick as my "keyCOUNT" would give me a sort of weighing formula to use. So in theory, return my original results, use "ListValueCount" to find the number of instances, read everything back into a new query object along with my "keyCOUNT", requery and sort by keyCOUNT, lastNAME. Does that sound like an idea, or can somebody think of a better way to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
