[thelist] "Smart Tags"

[Brian King]

Hi Darren, I also belong to the ASPlist.  Glad to see you used my comments
from it.  Cool!

Brian W. King
Impact Technologies

 -----Original Message-----
From: 	thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]
On Behalf Of Darren Neimke
Sent:	Thursday, June 14, 2001 12:04 AM
To:	thelist at lists.evolt.org
Subject:	RE: [thelist] "Smart Tags"

	> IE 6 may insert links to MSN sites and other sites into your
web pages.

Here's some feedback from another list that I'm involved in:

<snip>
I think there will be a number of ways to use this technology to our
benefit and limit the links list attached to the tags.  Who out there
ever gets the results they want on a search engine in the first page?
If the links list was based on third party results such as that, no one
will use it.  I am sure that they will be configurable.
</snip>



<TIP TYPE="sql" product="SQL7">

To include all records that are ranked equally within a resultset when
using the TOP clause also include the WITH TIES clause.

As an example the 1st statement could actually return more than 10
results, whereas the 2nd will always be abbreviated to first* 10
results.

SELECT TOP 10 WITH TIES
	asr.application_id AS ApplicationID,
	COUNT(asr.application_id) AS CountOfApplicationID
FROM Application_security_rel AS asr
GROUP BY asr.application_id
ORDER BY 2 DESC

SELECT TOP 10
	asr.application_id AS ApplicationID,
	COUNT(asr.application_id) AS CountOfApplicationID
FROM Application_security_rel AS asr
GROUP BY asr.application_id
ORDER BY 2 DESC

</TIP>


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !