The Verity text search engine is one of ColdFusion's great features although
it is often totally ignored by developers. This article tells you how to use
ColdFusion code to add the power of an internet-style Verity search engine to
the front door of your Web application and covers all the Verity search
engine basics with a focus on indexing SQL queries. If you are also
interested in using Verity to search documents or other text such as CFHTTP
result sets, you will find that the same principles apply.
Verity: What it is
Verity is a free add-on to the ColdFusion Server Pro and Enterprise versions.
It provides a full-text search service that can be directed at Web pages,
documents, and database queries. It can also incorporate your own custom
textual searches, such as those against CFHTTP result sets.
The award-winning Verity search engine was created by the Verity Corp... (more)
One of the most common database-driven applications on the Internet is the
Internet forums are used for product support, organizational announcements,
and corporate discussion areas, and as a place to talk about the theme of a
given Web site. They're popular because they offer a convenient way to
discuss interests and ideas while keeping a sense of history - something a
typical e-mail list doesn't have. They also have the advantage of offering
site administrators a high level of control over what's being talked about
and how it's discussed.
If you've been cons... (more)
If you're using ColdFusion with Access today, then it's likely you'll be
using it with SQL Server tomorrow. Luckily, Microsoft has provided some tools
that make upgrading to SQL Server a relatively easy process. You'll be
surprised to learn how simple it is to upgrade and how easy it is to work
This article covers the basics of using these tools and helps you plan an
easy database upgrade. You'll learn when and how to upgrade, and how to work
with the Microsoft Access 2000 "front end" to SQL Server to make your
transition as painless as possible.
Knowing When to Upgrade
Many of us have used the CFCONTENT tag that comes with ColdFusion to serve up
files to browsers, but very few ColdFusion developers are aware that the
CFCONTENT tag can be used in conjunction with the HTML tag to serve up
graphics, such as JPEGs and GIFs. In this case, the why of doing this is
perhaps just as interesting as the how.
It turns out that using this technique is perfect for use with creating an
advertising banner server, controlling access to graphic files, or - on the
more sinister side - creating "Web bugs."
If you don't recall, a Web bug is a graphic (usually... (more)
In March (CFDJ, Vol.3, issue 5) we covered reasons to upsize your Access
database to SQL Server and the tools you'll use to do it. Here we explain in
detail how to copy data to SQL Server and troubleshoot your upsizing project.
The IMPORT AND EXPORT data wizard (aka the DTS Wizard - Data Transformation
Services) certainly helps get you going with building tables in SQL Server.
It takes an Access database (as well as many other database types) to import
its table structures and data to a Microsoft SQL Server. Since it uses a
wizard format, it's simple to use as long as you know wha... (more)