Eron Cohen

Subscribe to Eron Cohen: eMailAlertsEmail Alerts
Get Eron Cohen via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Eron Cohen

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 Truth About Verity

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)

Ektron Turns Up The Heat

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