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 what data you want to
transform. To start the wizard choose START > MSDE > IMPORT AND EXPORT DATA
or START > Microsoft SQL Server 7.0 > IMPORT AND EXPORT DATA.
On the first data-gathering screen (see Figure 1) you'll be prompted for
information about the data source. Choose Microsoft Access from... (more)
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 Ente... (more)
If you have used any content management systems or any of the popular
Web-based e-mail portals, you've probably had an opportunity to use something
like eWebEditPro. The idea behind this product is to make it easy for anyone
to write HTML-enhanced content right on a Web site.
When the user goes to type text, instead of a regular bland HTML
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)
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)