When performing full-text searches you usually want not just results, but a ranking indicating how close a match is to what you are looking for. In SQL Server 2005, ranks are accessed via ranking functions - FULLTEXT searches are ranked using function FULLTEXTTABLE() and CONTAINS searches are...
SQL Server 2005 supports two forms of full-text search, FREETEXT and CONTAINS. CONTAINS is used to search for rows that contain words, phrases, partial phrases, words with the same stem, proximity searches, synonyms (using a thesaurus lookup), and more. Here is a simple example: SELECT note_id,...
FREETEXT provides a simple mechanism by which to perform SQL Server 2005 full-text searches, matching by meaning as opposed to exact text match. Here is a simple example: SELECT * FROM my_table WHERE FREETEXT(column1, 'rabbit food'); FREETEXT(column1, 'rabbit food') means perform a FREETEXT lookup...
SQL Server 2005 features an integrated full-text search engine, which several people have e-mailed me to ask about recently. (ColdFusion users can use to perform queries using SQL Server full-text searches). If you want to play with SQL Server 2005 full-text search capabilities, you need to do the...
My On The Road page has finally been brought up to date (just in time to hit the road again).
I am not a big fan of storing CLIENT variables in the registry (I thought doing so was a hack when we first introduced CLIENT variables close to a decade ago, and still think that using the registry as a data store was a mistake). Actually, I am not a big fan of CLIENT variables altogether. But...
A new hot fix addresses an issue when using in ColdFusion to send a large number of emails (usually more than 500) and the emails contain attachments with long filenames, some of the emails do not get sent and are moved to the Undeliverable folder.
WebProNews is running an article by Ben Cortese entitled Consuming RSS Feeds With ColdFusion , a good basic introduction to working with RSS in ColdFusion.
Ugh, I did it again. The CF Docs Bots were offline the past few days because my serial number for JBuddy-CF expired at the end of 2006. I've updated the serial number, and the bots are all back online. Sorry about that. The addresses remain the same: AIM: cflivedocs Google Talk: cfdocs@gmail.com...
The Seattle Times Company is looking for a full-time developer who must know or learn (among other thing) ColdFusion. Details posted online .