Database
Tracking the Popularity of Your Database Content
by Steven Seiller - 21-Jul-08
Reader Level: 
If you have database content which you share, you may wish to track the number of times each record is requested or viewed. Be it an article, an image, a link or a video, counting the number of times that record has been accessed or requested will provide a measure of its popularity relative to the rest of the records in your database. You have likely seen this tracking in action in the form of the "Most Viewed" search option, such as those found on news sites or You Tube. You might choose to keep the tracking count to yourself for private statistical analysis or allow visitors to view the record counts.
Top Ten Tips for Creating a Database for the Web
by Tom Muck - 12-Feb-07
Reader Level: 
Many web developers also design their own databases. I don't know how many times I've heard something like "I'm a designer...I don't know how to add a user" or "I'm only the web site administrator...I don't know how to write SQL." There are a few simple things that someone designing a database should know. I'll try to cover them for the developer/designer who also is in charge of handling the database implementation.
Using the asp:Calendar Control - Part 5
by Heidi Bautista - 27-Dec-06
Reader Level: 
In this installment of the Using the asp:Calendar control series you'll build on the previous part that showed how to display information retrieved from a SQL Server database. In this part you'll learn how to add a OnSelectionChanged handler that displays additional details about the event(s) on the selected day.
Along the way, you'll learn about optimizing your application to enhancement its performance.
The asp:Calendar Control Series:
Using the asp:Calendar Control - Part 1 - introduction to the control, describes basic functions and defaults. Shows the control embedded on a page.
Using the asp:Calendar Control - Part 2 - using the control in a popup page. Transferring the value from the popup to the main page.
Using the asp:Calendar Control - Part 3 - allowing the user to select an entire week or month. Additional styling options to customize both the look of the calendar and how it functions.
Using the asp:Calendar Control - Part 4 - displaying event data that's pulled from a database.
Using the asp:Calendar Control - Part 5 - displaying additional details for event(s) on the selected day. Performance tuning, too.
Using the asp:Calendar Control - Part 4
by Heidi Bautista - 08-Dec-06
Reader Level:
In this installment of the Using the asp:Calendar control series you'll learn how to add information retrieved from a SQL Server database to the Calendar control. Along the way, you'll learn how to use a parameter with the SqlDataSource control to refine the SELECT statement used to retrieve the data for the month currently displayed in the calendar. You'll also learn how to use a RowFilter to extract event data for a particular day. And, finally, you'll learn one technique for displaying the retrieved event data in your calendar.
There are lots of possibilities when it comes to displaying the data. This tutorial will show you how to use a Literal control to display and style the event title.
The asp:Calendar Control Series:
Using the asp:Calendar Control - Part 1 - introduction to the control, describes basic functions and defaults. Shows the control embedded on a page.
Using the asp:Calendar Control - Part 2 - using the control in a popup page. Transferring the value from the popup to the main page.
Using the asp:Calendar Control - Part 3 - allowing the user to select an entire week or month. Additional styling options to customize both the look of the calendar and how it functions.
Using the asp:Calendar Control - Part 4 - displaying event data that's pulled from a database.
A Simple Multi-language ColdFusion Content Management System - Part 2
by Tom Muck - 24-Oct-06
Reader Level:
There are various ways to create a data-driven multi-language site, but the method I will show in this article series uses an underused technique involving ColdFusion custom tags.
Basically, the technique shown will turn any simple, well-formed HTML or XHTML page into a content management system with only one tag required on the page. This first part of this series showed the principles behind the custom tag technique.
This part will implement the database tables and custom ColdFusion functionality to turn HTML tags into database-driven dynamic tags to implement the multi-language aspect.
The Multi-Language ColdFusion Content Management System Series:
A Simple Multi-language ColdFusion Content Management System - Part 1
A Simple Multi-language ColdFusion Content Management System - Part 2
A Simple Multi-Language ColdFusion Content Management System - Part 3
A Simple Multi-language ColdFusion Content Management System - Part 1
by Tom Muck - 11-Oct-06
Reader Level:
There are various ways to create a data-driven multi-language site, but the method I will show in this article series uses an underused technique involving ColdFusion custom tags. Basically, the technique shown will turn any simple, well-formed HTML or XHTML page into a content management system with only one tag required on the page.
This first part will show the principles behind the custom tag technique. The next part will show how to implement the multi-language aspect. The third part will create an administrative interface to administer the system.
The Multi-Language ColdFusion Content Management System Series:
A Simple Multi-language ColdFusion Content Management System - Part 1
A Simple Multi-language ColdFusion Content Management System - Part 2
A Simple Multi-Language ColdFusion Content Management System - Part 3
Full-Text Searching with MySQL and PHP
by Gordon Mackay - 13-Jul-06
Reader Level:
As a general rule of thumb, web sites that contain a large amount of content adopt some form of fuctionality that allows users to search through content held within their database.
The methods for searching database content vary from server model to server model and can often be rather complicated. However, if your web site holds its content in a MySQL database, you can very quickly add a simple but effective search mechanism using MySQL's FULLTEXT indexing.
In this tutorial we will look at using FULLTEXT indexing to create a simple content search engine that can quickly be implemented on any web site running PHP and pulling content from a MySQL database.
Extract Links from a Web Page Using ColdFusion
by Tom Muck - 06-Jul-06
Reader Level:
ColdFusion provides a lot of functionality in the form of tags, but some of the more powerful features require a bit of programming knowledge, like the use of regular expressions, XML functions, and the recursive function construct.
This tutorial will show how to use a regular expression to find all given elements in a string, then use an XML function to extract HTML attributes, and use a recursive function (calling a function from within the function until finished) to streamline the coding. In this case, we'll be searching for all links within a page, but the technique could be used to find email addresses, HTML tags, phone numbers, or other formatted pieces of text.
Creating a Registration Page: Part 3
by Tom Muck - 21-Jun-06
Reader Level: 
Dreamweaver contains many built-in tools to aid in quickly building dynamic sites. Part 1 of this series showed the Record Insertion Form Wizard to set up a simple user registration form on a web site. The registration form allows a user to register for a site.
Part 2 showed validation and the user agreement, using more built-in tools of Dreamweaver and a little rudimentary JavaScript. The tutorial will apply equally to PHP, ASP, ColdFusion, and JSP using built in tools.
Part 3 will show how to pass registration details to Paypal or other payment processor for a paid membership-type of site.
The Creating a Registration Page Series:
Creating a Registration Page: Part 1
Creating a Registration Page: Part 2
Creating a Registration Page: Part 3
Creating a Registration Page: Part 2
by Tom Muck - 07-Jun-06
Reader Level:
Dreamweaver contains many built-in tools to aid in quickly building dynamic sites. Part 1 of this series showed how to use the Record Insertion Form Wizard to set up a simple user registration form on a web site. The registration form allows a user to register for a site.
Part 2 will show validation and the user agreement, using more built-in tools of Dreamweaver and a little rudimentary JavaScript. The tutorial will apply equally to PHP, ASP, ColdFusion, and JSP using built in tools.
Part 3 will show how to pass registration details to PayPal or other payment processor for a paid membership-type of site.
The Creating a Registration Page Series:
Creating a Registration Page: Part 1
Creating a Registration Page: Part 2
Creating a Registration Page: Part 3
ASP.NET v2.0 - Using the SqlDataSource and GridView Controls
by Heidi Bautista - 17-Mar-06
Reader Level:
In this tutorial you'll learn how to connect to the SQL Server database using VWD and how to get the connection string needed for the web.config. You'll learn how to use the SqlDataSource control to retrieve data from a SQL Server database. You'll see how the SqlDataSource can be used with a SELECT statement and with a stored procedure. And you'll learn how to create a SqlDataSource with or without parameters. You'll learn how to tell data-bound controls (DropDownList and GridView) where to get the data with which to populate the controls. Last but not least you'll learn how the process of getting data and binding the data to controls in ASP.NET v2.0 (and VWD) differs from the way you did it in DW with ASP.NET v1.1.
Introducing CMX Jumpstart Inverness
by Sheri German - 21-Dec-05
Reader Level:
We are pleased to announce Community MX JumpStart Inverness, a design you can use to create your own Web blog. CMX JumpStart Inverness was designed and coded by new CMX partner Gordon Mackay. It is a centered, two-column, fixed-width design that makes use of background images to achieve its faux column appearance. The page is constructed using valid XHTML 1.0 Strict markup and formatted using valid CSS 2.1 styling. Inverness also follows the WAI and Section 508 accessibility guidelines to provide you with a solid foundation for any design. Read on to find out what the Inverness package includes and how you can make it your own.
The Complete JumpStart Catalog
by Sheri German - 20-Dec-05
Reader Level:
We now have a healthy portfolio of JumpStarts, and sometimes so much choice can be overwhelming. This article outlines the features of all the JumpStarts, offers guidance in choosing the right JumpStart for your project, and provides a complete catalog of our first thirteen JumpStarts.
Searching for Data Using Wildcards in a Stored Procedure
by Heidi Bautista - 09-Nov-05
Reader Level:
This tutorial demonstrates how to create an ASP.NET page that searches for data in specific columns of a table. The technique described has the added advantage that the user can enter just a fragment corresponding to the data that resides in the table. You'll learn how to use the LIKE keyword and % wildcard in a stored procedure. And you'll see how the use of three Dreamweaver server behaviors nearly eliminates the need for you to write any code yourself!
Teaching Dreamweaver Part 2
by Sheri German - 11-Oct-05
Reader Level:
Part two of my Dreamweaver course series is devoted to how I teach students to create database-driven web pages and web applications. During the course of the semester we put together a form that is processed by a script, a login system based on access level that uses Dreamweaver's Authentication Server Behaviors, and a blog as introduced in a tutorial by Tom Muck. In the process, the students learn the basics of the various skills they'll use: form construction, SQL, database and web application design, and server model concepts.
What's with the Question Marks? Or: Where are my Curly Quotes?
by Arman Danesh - 14-Sep-05
Reader Level:
If you work with ColdFusion and popular databases such as MySQL you my find yourself geting strange results. Even if you don't use non-Roman scripts such as Chinese or Arabic you may find curly quotes or other extended characters magically becoming question marks. This article discusses techniques you can use to resolve this common problem.
Using the ASP.NET Insert Record Server Behavior - Part 2
by Heidi Bautista - 10-Jun-05
Reader Level:
This article picks up where Part 1 left off. You'll get a better understanding of how to use the Insert Record server behavior with datatypes other than just strings and you'll learn how to add the necessary modifications to the MM:Insert tag so that it handles the ASP.NET validators that have been added to the form. The sample pages are provided in C# and VB.NET.
Using the ASP.NET Insert Record Server Behavior - Part 1
by Heidi Bautista - 31-May-05
Reader Level:
This article shows you how to use the Insert Record server behavior to take data collected with a form and insert it into a table in a SQL Server database. It's fast and easy. You're likely to spend more time styling the form than doing the coding!
Using DTS Packages with ColdFusion
by Tom Muck - 25-May-05
Reader Level:
Many people use SQL Server to store their data, however SQL Server is much more involved than simply a server that allows storage for data. Data Transformation Services (DTS) is part of SQL Server and allows you to import and export data, manipulate files on the system, use FTP, among other things. Using some of SQL Server's built-in DTS functionality along with ColdFusion gives your web application access to some of this functionality.
Do-It-Yourself Database Administration: 10 Biggest Mistakes
by Tom Muck - 15-Feb-05
Reader Level:
Web developers are frequently called upon to wear many hats. Mom-and-pop shops, small development companies, and small Internet service providers are frequently called upon to perform the task of database administrator.
This article will show ten of the biggest mistakes that inexperienced database administrators make. Database administrators make good money because the job is not an easy one and requires knowledge and experience. This article shows ten common mistakes when managing your own database.
Using DropdownLists, CheckBoxes, and TextBoxes in an Editable ASP.NET DataGrid
by Heidi Bautista - 09-Feb-05
Reader Level:
Learn how to easily add data-bound dropdown lists, checkboxes, and single and multi-line textboxes to your editable DataGrids. If you stick with these three types of controls you can still leverage Dreamweaver's built-in functionality provided by DreamweaverCtrls.dll to handle updating and deleting from your database. It's easier than you might think. Read on to learn this "trick of the trade."
Announcing CMX JumpStart: Liverpool
by Sheri German - 20-Jan-05
Reader Level:
It was the early sixties, and all the world was in a frenzy over a new group from Liverpool, England called The Beatles. They revolutionized rock 'n' roll music, and the world has never been the same. Maybe the Web Standards movement doesn't stir quite that much excitement, but it is changing the Web world all the same. And because we "love you, yeah, yeah, yeah" we're here to help you join the revolution.
Community MX is pleased to announce the release of its fifth CMX JumpStart: Liverpool. This time we're giving you more than a CSS layout, however. We're also giving you a dynamic ColdFusion login application built with Dreamweaver's User Authentication server behaviors that will allow you to quickly and easily edit the login.
This article will tell you all about what this fantastic package includes--bundled tutorials, an authentication system, a two-column, fixed width layout (with a little bit of a twist), original PNG files, and more.
Creating Dependent Dropdown Lists with Dreamweaver MX04 and ASP.NET - Part 2
by Heidi Bautista - 11-Jan-05
Reader Level: 
Make smarter ASP.NET pages by implementing data-bound dependent dropdown lists. The selection in the first dropdown list dictates the contents of the second dropdown list and the selection in the second dropdown list dictates the contents of the third dropdown list.
Part 1 showed how to make the data-bound dropdown lists plus how to make the second one dependent on the first.
Here in Part 2, we first extend the paradigm to three dropdown lists and then generalize the technique so that you can add as many dependent dropdown lists as you wish.
Creating Dependent Dropdown Lists with Dreamweaver MX04 and ASP.NET - Part 1
by Heidi Bautista - 30-Dec-04
Reader Level:
Make smarter ASP.NET pages by implementing data-bound dependent dropdown lists. The selection in the first dropdown list dictates the contents of the second dropdown list.
Here in Part 1 you'll learn how to make the data-bound dropdown lists plus how to make the second one dependent on the first.
In Part 2, we'll extend the paradigm to three or more dropdown lists. Along the way you'll get a better understanding of view state and the Dreamweaver MM:DataBind custom tag.
eCommerce and ASP.NET - Part 1: Create a Product Catalog and Use PayPal's Shopping Cart
by Heidi Bautista - 02-Nov-04
Reader Level:
eCommerce is easier than you might think - when you have help from Dreamweaver and PayPal.
This is the first in a series of articles that describe how to use ASP.NET to develop eCommerce sites. In this installment, you'll learn how to build a simple, but effective, product catalog based on products in the Northwind sample database and hook your product catalog into PayPal to take advantage of their payment processing systems as well as their shopping cart.
In future articles we'll explore:
- Adding features to your catalog (e.g., displaying one or more product images and using a paged catalog),
- Taking advantage of other PayPal features (e.g., Instant Payment Notification and subscription services), and
- Building your own shopping cart instead of relying on PayPal's cart.
Indexing a Database Table
by Tom Muck - 29-Sep-04
Reader Level:
Indexes are one of the most important aspects of database design, yet one of the most underused in web applications. A database index can speed up a query by hundreds or thousands of times. Imagine, for example, if the phone book was not alphabetized and you had to find a name. It would takes hours or days to find a name. This is exactly the kind of inefficiency that a database with no index has to contend with. The article will show where to put indexes.
MySQL Command Line Tips
by Thomas Pletcher - 24-Aug-04
Reader Level:
MySQL is all the rage these days, and with good reason: its price/power ratio can't be matched. And there are a lot of well-engineered GUI interfaces to make MySQL administration easy. But the fact remains that MySQL's native interface is the command line, and sometimes the command line is the only way to go.
This article walks you through basic MySQL command-line options on diverse operating systems, and shows you how to get up close and personal with MySQL on your local machine and your remote server.
cmxBean.cfc: A Very Simple Bean Implementation in ColdFusion, Part I
by Arman Danesh - 29-Jul-04
Reader Level:
This article is the first in a series of of articles detailing an extremely simple implementation of a Bean framework in ColdFusion. This framework will allow the simple creation of reusable data components which can be used to access and manipulate data in a database table without writing any new database code. This article provides a high-level overview of the framework which will be detailed in future articles.
Batch Updates in ASP.NET - Part 2
by Heidi Bautista - 26-Jul-04
Reader Level: 
This tutorial explains how to perform a batch update in ASP.NET using strictly the .NET Framework. You can accomplish the same goal with Dreamweaver's Update Record server behavior, too. (See Using Dreamweaver and .NET For Batch Updates - Part 1.) Which method is best for you? Read both tutorials to learn the pros and cons of each approach.
Manipulating Images On The Fly With PHP
by Rob Williams - 21-Jul-04
Reader Level:
Server-side scripting has made HTML pages dynamic and adaptable, but for the most part has left the tasks of graphic updates and manipulation up to the hard working web developer. Thanks to the simple, yet powerful, image manipulation functions built into PHP though, those hours of repetitive graphic updates can be spent on better things. This article provides an introduction to PHP's image capabilities and gives you a solid foundation of how to create, work with, and save images from within PHP.
Case Study: Using the New Flash Remoting Classes
by Paul Newman - 15-Jul-04
Reader Level:
Recently, one of our subscribers made me an offer I couldn't refuse. He created a ColdFusion component (CFC) that sends mail using CFMAIL, and queries an Access database. But he was having difficulty getting the data into Flash, and sending the results of a contact form to the CFC. He offered to send me the database, CFC, and FLA source file if I could use the new Flash Remoting classes to tie it all together.
In this article, you'll learn how to call methods on a Flash Remoting service and return the results to Flash MX 2004 components. Includes coverage of the following Flash Remoting classes: Service, PendingCall, RelayResponder, ResultEvent, FaultEvent, Log, RecordSet, DataGlue.
Support Files: ColdFusion component, Microsoft Access database, Flash document, ActionScript file.
Using Dreamweaver and .NET For Batch Updates - Part 1
by Heidi Bautista - 14-Jul-04
Reader Level:
The Update Record server behavior is convenient and easy to use when you need to update a single row of a table using values collected from a form. But what if you want to update many rows simultaneously and don't want to bother with filling out a form for each and every item? In this tutorial you'll learn how to modify Dreamweaver's Update Record server behavior to perform a batch update. With a bit of hand-coding you can still take advantage of Dreamweaver's built-in server behavior.
Planning An Efficient Database
by Rob Williams - 08-Jul-04
Reader Level:
Database-driven websites are quickly becoming the "way of doing things" on the net these days, but for developers new to the database way of thinking, things often end up being far more complicated and confusing than they should be. In this article we'll work through the basic concepts of databases, and develop an easy and effective method of planning databases that will not only make things easy to understand, but will also help to improve the speed and efficiency of the databases you create.
Dynamic Duo: JSP and MySQL
by Val Tobin - 21-Jun-04
Reader Level:
These days, no one would argue that a dynamic site is far more powerful, flexible, and scalable than a static site. But if you have a lot of static pages in your existing site, you might not know how to convert them in order to take advantage of the benefits of a dynamic site. This tutorial will show you how to do just that, by taking some existing static HTML pages, and converting them to Java Server Pages (JSP) using Dreamweaver MX 2004 and a MySQL database.
Get Connected
by Val Tobin - 14-Jun-04
Reader Level:
These days few web sites are left that aren't dynamic, and some might even be classified as true web applications. When you have a database backend, your site is much easier to update and maintain, because so much of its functionality can be automated. If you're in the process of creating a dynamic web site using Java Server Pages (JSPs), then using Dreamweaver to set up the connections will make the whole process that much simpler and quicker.
This tutorial will guide you through the process of creating a database connection for a JSP site using Dreamweaver MX 2004 (DWMX 2004). Future articles and tutorials will cover related topics such as working with dynamic data in JSPs using Dreamweaver MX 2004 and setting up servers for JSP sites.
Affiliate Tracking System For ColdFusion
by Tom Muck - 11-Jun-04
Reader Level:
ColdFusion users have an application.cfm file which makes building an application much easier in many respects. The reason is that this file can do a variety of different things because it is always the first file executed no matter what page was requested in your application. You can use this to your advantage in an affiliate tracking application, such as in an e-store. This article will show how to build it.
Working with the asp:ListBox
by Heidi Bautista - 14-May-04
Reader Level:
In this article, we are going to explore the
SQL Injection Attacks
by Heidi Bautista - 10-May-04
Reader Level:
Security is the current favorite buzzword. Are your sites secure? Read on to learn about a popular, easy-to-learn, and extremely dangerous, security loophole - SQL injection attacks - used by hackers to compromise your database.
Advanced User Authentication with .NET and Dreamweaver - Part 3
by Heidi Bautista - 04-May-04
Reader Level:
This is Part 3 of the Advanced User Authentication with .NET and Dreamweaver series. You've created a great two-role authentication scheme using the first two parts of this tutorial series, but now your boss says you actually need three roles. Well, maybe four or five, he's not really sure. No problem. This tutorial takes you through the process of how to store and use role information from a database. And, while you're at it, impress your boss by throwing in some nifty site personalization, which is also covered in this tutorial.
Toggle Between Showing All Rows and Showing a Paged View of Results
by Heidi Bautista - 22-Apr-04
Reader Level:
Learn how to enhance the usability of a page of data by including a link that the allows the user to toggle between showing all rows and showing a subset of rows over a series of pages. This tutorial uses the Macromedia custom Dataset tag as well as several server behaviors (repeat region, dataset paging, show region) and the DataGrid tag to display data on the page. Two sample pages written in C# are included.
Creating a Guestbook - Part I
by Bill Horvath - 06-Apr-04
Reader Level:
Guestbooks are a way for people to leave comments on your website for other folks to see. In this series, we'll build a guestbook from the ground up. Part I will cover the very basics and at the end we will have a functional guestbook. Part II will cover a couple of advanced concepts to add more functionality to the guestbook, like disallowing "bad" words and supplying "Next" and "Previous" navigation links.
Creating a Simple Blog Part 2
by Tom Muck - 30-Mar-04
Reader Level:
One of the frequent questions in the forums is "How do I create a blog?". There are many commercial blog systems out there, and many full-featured blog providers, like Blogger, but you can also create a simple blog using the standard tools of Dreamweaver. This tutorial will be equally applicable to ColdFusion, ASP, PHP, ASP.NET, or JSP because we will be using standard Dreamweaver server behaviors to create the blog. Part 1 of the tutorial can be found at http://www.communitymx.com/abstract.cfm?cid=7CC52. Part 2 will focus on adding more features to the blog, such as a system for adding and viewing comments, and more administration options.
Using An asp:CheckBoxList Control With Dynamic Data - Part 2
by Heidi Bautista - 24-Mar-04
Reader Level:
In Part 1 of this series, we learned how to populate an asp:CheckBoxList control with data from a SQL Server database. Part 2 covers how to update the database using a stored procedure that takes as input the selections made in the CheckBoxList control.
Creating a Simple Blog Part 1
by Tom Muck - 22-Mar-04
Reader Level:
Many people ask "how can I build my own blog?" This tutorial will show how to create a simple blog using point-and-click features of Dreamweaver. For that reason, this tutorial can be followed for any server model that Dreamweaver supports.
Using An asp:CheckBoxList Control With Dynamic Data - Part 1
by Heidi Bautista - 17-Mar-04
Reader Level:
Learn how to populate an asp:CheckBoxList control with data from a SQL Server database in Part 1. Part 2 covers how to update the database using a stored procedure that takes as input the selections made in the CheckBoxList control.
Searching Unrelated Database Tables
by Tom Muck - 20-Feb-04
Reader Level:
Most data-driven sites include a search option, where a user is able to search a database table or a related table for a specific value. An example of this is a site like Amazon.com, where you might want to search on a book subject, or a book author. Most likely, the author name is stored in a separate table. You can easily search on title, author, subject, or any of the above by writing a SQL statement that joins the related data. What if you want the user to be able to search multiple tables that do not relate, however? This article will address joining unrelated tables for a database search.
Customized ASP.NET DataGrid: Making One Column Dependent Upon Another
by Heidi Bautista - 10-Feb-04
Reader Level:
Learn how to use Dreamweaver to customize the display and functionality of your DataGrid. Along the way you'll learn about these other useful techniques:using the DataSet tag's Expression attribute to control when it gets executed; using a Free form column in a DataGrid; using a ternary expression (C#) / IIf function (VB) to control logic flow; using the MM:If server behavior to control what gets displayed.
Using UUIDs for Database Record IDs
by Arman Danesh - 04-Feb-04
Reader Level:
Auto-incrementing numeric fields are a useful way to create unique IDs for records in a database table, but they have their limits. UUIDs provide a powerful alternative that is scalable, transportable and easy-to-implement.
Using the Stored Procedure Server Behavior on ASP.NET Pages
by Heidi Bautista - 29-Dec-03
Reader Level:
It's well known that using stored procedures is better practice over using embedded SELECT statements in your code. Dreamweaver has a built-in server behavior called Stored Procedure that makes this process much easier on ASP.NET pages. Read on to learn how.
Export Recordsets to Excel - Part 2
by Bill Horvath - 09-Dec-03
Reader Level:
In Part 1 of this tutorial, we learned how to export the contents of a recordset to an Excel spreadsheet, and then email that report to a specific email address. In Part 2, we'll look at ways to adjust our query in ColdFusion so that we can build customized reports that can then be exported to Excel.
We'll also go over how to email the report to any email address you like, rather than just the one email address we used in Part 1 of the tutorial.
Check New Username Server Behavior
by Bill Horvath - 19-Nov-03
Reader Level:
A lot of people in the Dreamweaver forums ask "How can I make sure when someone registers on my website that their username is not the same as someone else's?"
Server behaviors can save you time, sweat, energy and frustration. The Check New Username server behavior is one of those behaviors that has been a part of Dreamweaver since UltraDev, but folks glance by it somehow.
In a few simple steps, you'll learn how to use this server behavior, and also how to modify it a bit to offer greater flexibility.
Setting the SelectedIndex of an asp:DropdownList
by Heidi Bautista - 05-Sep-03
Reader Level:
Dive deeper into Dreamweaver MX and ASP.NET with this tutorial showing how to populate a DropdownList from a database, set the SelectedIndex of the dropdown, and retrieve specific information from the database based on either the dropdown's SelectedIndex or a query string. Throw in some additional info regarding order of events and data binding in ASP.NET and you've got one interesting ap!
Fun with the DataGrid tag, Part 3
by Heidi Bautista - 19-Aug-03
Reader Level:
The ASP.NET DataGrid is a data-bound list control that uses a table to display and/or modify information. In this three-part tutorial, we'll take a look at creating DataGrids using Dreamweaver's DataGrid server behavior. You'll learn how to customize the look of the DataGrid and make it editable. In addition, you'll pick up some useful tips regarding the inter-relation between Dreamweaver's custom DataSet tag and the DataGrid control.
In part 1, we'll go over setting up your Dreamweaver site, connecting to the database, creating the data source for the DataGrid, and creating a simple DataGrid. Part 2 describes several techniques you can use to customize the appearance of the DataGrid. And Part 3 will cover making your DataGrid editable.
Upsizing from Access to SQL Server
by Ray West - 13-Aug-03
Reader Level:
As your web site grows and your traffic increases you will need to address the scalability of your application to keep up. Moving your database from Access to SQL Server offers significant increases in performance, security, and reliability. Learn the tricks to a seamless upgrade.
Fun with the DataSet tag, Part 2
by Heidi Bautista - 13-Aug-03
Reader Level:
Learn how to build your dynamic ASP.NET pages even faster by employing the power of the MM:DataSet tag to get and manipulate data prior to displaying it on your pages. In part one of this two-part article you'll learn the nuances of this custom tag's attributes and methods, including some performance tips. Part 2 will be all about examples; seeing the DataSet tag in action.
Fun with the DataGrid tag, Part 2
by Heidi Bautista - 30-Jul-03
Reader Level:
The ASP.NET DataGrid is a data-bound list control that uses a table to display and/or modify information. In this three-part tutorial, we'll take a look at creating DataGrids using Dreamweaver's DataGrid server behavior. You'll learn how to customize the look of the DataGrid and make it editable. In addition, you'll pick up some useful tips regarding the inter-relation between Dreamweaver's custom DataSet tag and the DataGrid control.
In part 1, we'll go over setting up your Dreamweaver site, connecting to the database, creating the data source for the DataGrid, and creating a simple DataGrid. Part 2 describes several techniques you can use to customize the appearance of the DataGrid. And Part 3 will cover making your DataGrid editable.
Fun with the DataGrid tag, Part 1
by Heidi Bautista - 17-Jul-03
Reader Level:
The ASP.NET DataGrid is a data-bound list control that uses a table to display and/or modify information. In this three-part tutorial, we'll take a look at creating DataGrids using Dreamweaver's DataGrid server behavior. You'll learn how to customize the look of the DataGrid and make it editable. In addition, you'll pick up some useful tips regarding the inter-relation between Dreamweaver's custom DataSet tag and the DataGrid control.
In part 1, we'll go over setting up your Dreamweaver site, connecting to the database, creating the data source for the DataGrid, and creating a simple DataGrid. Part 2 describes several techniques you can use to customize the appearance of the DataGrid. And Part 3 will cover making your DataGrid editable.
Fun With the DataSet Tag: Part 1
by Heidi Bautista - 11-Jul-03
Reader Level:
Learn how to build your dynamic ASP.NET pages even faster by employing the power of the MM:DataSet tag to get and manipulate data prior to displaying it on your pages. In part one of this two-part article you'll learn the nuances of this custom tag's attributes and methods, including some performance tips. Part 2 will be all about examples; seeing the DataSet tag in action.
Creating the database connection for your ASP.NET application
by Heidi Bautista - 07-Jul-03
Reader Level:
One of the very first hurdles to cross when developing a new dynamic ASP.NET application is creating the connection to your database. In this tutorial you'll learn how to make both a SQL Server connectin and an OLE DB connection in Dreamweaver. You'll see how Dreamweaver takes you through a series of dialogs prompting you for information, provides a mechanism for you to test the connection, and writes the required code to your web.config file.
Advanced User Authentication with .NET and Dreamweaver, Part 2
by Heidi Bautista - 27-Jun-03
Reader Level:
This tutorial takes you step-by-step through the implementation of Forms-based Authentication using ASP.NET, Macromedia's custom DataSet tag, SQL Server 2000, and C#. Part 1 shows you how to set up a simple authentication scheme with a single type of user. Part 2 goes further. You'll learn how to examine the user's role to enable/disable access to your site's protected content.
Advanced User Authentication with .NET and Dreamweaver, Part 1
by Heidi Bautista - 26-Jun-03
Reader Level:
This tutorial takes you step-by-step through the implementation of Forms-based Authentication using ASP.NET, Macromedia's custom DataSet tag, SQL Server 2000, and C#. Part 1 shows you how to set up a simple authentication scheme with a single type of user. Part 2 goes further. You'll learn how to examine the user's role to enable/disable access to your site's protected content.
A Quick Introduction to the Structured Query Language (SQL)
by Arman Danesh - 19-Jun-03
Reader Level:
When you make the move from building static HTML pages to developing dynamic sites with ColdFusion, .NET, PHP or JSP you will need to start learning to work with relational databases. This article provides a quick introduction to the basic essentials of the Structured Query Language (SQL) which is the language you use to work with databases.
Check for duplicate database entries
by Bill Horvath - 17-Jun-03
Reader Level:
You may have a database in which you have duplicate entries in a particular column. This may be by design, or possibly by accident. If you've inherited the site from someone else, you may not be aware of this duplicate data. Or perhaps you are aware, but you'd like to see what or where this data is. This tutorial will allow you to build a page that lists only duplicate entries from a column in your database.
Preventing duplicate database entries in ColdFusion
by Arman Danesh - 11-Jun-03
Reader Level:
If you need a Username to be unique when a user registers on your website, this article shows two simple ways to insure that they cannot select a name that is already being used. These techniques can be used to prevent the creation of duplicate database entries in any database.
