Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now

Using the Record Update Form wizard


From:

Dreamweaver CS4 Dynamic Development

with David Gassner

Video: Using the Record Update Form wizard

Just as when creating a data entry form that allows users to insert data into a database table, when you create a form that will allow the user to update the data, you can also choose between using a wizard that creates the form and all of the server behaviors in a single step or you can create your own custom form and then apply the server behaviors. In this video, I'll show you how to use the Record Update Wizard. This wizard will take a page that already has the data that needs to be updated, that is, a record set containing a single row from a database table, and it will generate a complete data entry form and all of the required server behaviors.
Expand all | Collapse all
  1. 7m 39s
    1. Welcome
      1m 20s
    2. Series overview
      3m 7s
    3. Using ASP and ASP.NET with Dreamweaver
      1m 38s
    4. Installing the exercise files
      1m 34s
  2. 17m 37s
    1. Static vs. dynamic web pages
      5m 58s
    2. Selecting an application server
      4m 51s
    3. Selecting a database
      6m 48s
  3. 12m 54s
    1. Introducing Apache, MySQL, and PHP
      2m 51s
    2. Installing WAMP on Windows
      4m 34s
    3. Installing MAMP on Mac OS X
      3m 4s
    4. Installing the exercises database
      2m 25s
  4. 25m 55s
    1. Setting up the PHP exercise files
      1m 55s
    2. Defining a Dreamweaver site
      3m 50s
    3. Understanding basic PHP code
      2m 24s
    4. Inserting simple PHP commands
      2m 40s
    5. Using Live View and Live Code with PHP
      2m 49s
    6. Using server-side includes
      6m 46s
    7. Defining a database connection
      5m 31s
  5. 44m 19s
    1. Installing ColdFusion on Windows
      4m 39s
    2. Installing ColdFusion on Mac
      5m 35s
    3. Completing the ColdFusion installation
      1m 22s
    4. Using the ColdFusion Administrator
      4m 44s
    5. Setting up the ColdFusion exercise files
      1m 44s
    6. Defining a Dreamweaver site
      3m 22s
    7. Understanding basic ColdFusion code
      3m 30s
    8. Using Live View and Live Code with ColdFusion
      2m 1s
    9. Inserting simple ColdFusion commands
      3m 25s
    10. Using server-side includes
      7m 10s
    11. Defining a ColdFusion data source
      6m 47s
  6. 46m 37s
    1. Working with data in PHP and ColdFusion
      1m 36s
    2. Using the Bindings and Server Behaviors panels
      2m 54s
    3. Building a simple recordset
      5m 30s
    4. Building an advanced recordset
      5m 8s
    5. Using repeating regions
      3m 32s
    6. Generating a dynamic table
      4m 23s
    7. Applying string formats
      4m 32s
    8. Displaying the total number of records
      1m 52s
    9. Limiting the number of records with paging controls
      5m 58s
    10. Creating conditional regions
      3m 39s
    11. Creating a Master Detail page set
      7m 33s
  7. 53m 10s
    1. Understanding data entry systems
      3m 47s
    2. Preparing a record insert form with recordsets
      3m 38s
    3. Using the Record Insertion Form wizard
      7m 17s
    4. Creating a custom data entry form
      7m 44s
    5. Using the Insert Record server behavior
      4m 26s
    6. Using the Record Update Form wizard
      7m 15s
    7. Displaying existing data in form controls
      6m 23s
    8. Using the Update Form behavior
      3m 14s
    9. Creating list page links to edit and delete data
      3m 28s
    10. Using the Delete Record server behavior
      5m 58s
  8. 24m 28s
    1. Enabling J2EE sessions in ColdFusion
      3m 24s
    2. Creating an Application.cfc file
      4m 58s
    3. Creating a login form page for ColdFusion
      4m 26s
    4. Logging in with a ColdFusion server behavior
      5m 2s
    5. Protecting page access with ColdFusion server behaviors
      3m 30s
    6. Logging out with a ColdFusion server behavior
      3m 8s
  9. 16m 18s
    1. Creating a login form page for PHP
      5m 17s
    2. Logging in with a PHP server behavior
      2m 56s
    3. Protecting page access with PHP server behaviors
      4m 18s
    4. Logging out with a PHP server behavior
      3m 47s
  10. 15m 48s
    1. Understanding client-side form validation
      3m 48s
    2. Validating form controls
      6m 18s
    3. Laying out the validation user interface
      2m 55s
    4. Modifying validation display with CSS
      2m 47s
  11. 37m 1s
    1. Creating a Spry XML data set
      5m 58s
    2. Generating XML output with ColdFusion
      4m 19s
    3. Generating XML output with PHP
      4m 22s
    4. Generating HTML output
      5m 23s
    5. Creating a Spry table
      4m 13s
    6. Formatting Spry tables
      4m 59s
    7. Generating a repeating list
      3m 23s
    8. Creating a Spry repeating region
      4m 24s
  12. 23m 2s
    1. Using multiple record sets and displaying multiple dynamic tables
      3m 49s
    2. Using a Spry accordion
      4m 24s
    3. Using Spry tabbed panels
      4m 21s
    4. Using Spry collapsible panels
      4m 23s
    5. Using a Spry menu bar
      6m 5s
  13. 54s
    1. Goodbye
      54s

please wait ...
Watch the Online Video Course Dreamweaver CS4 Dynamic Development
5h 25m Intermediate Dec 18, 2008

Viewers: in countries Watching now:

Dreamweaver CS4 Dynamic Development takes users to the next level in their understanding of the application. David Gassner demonstrates the installation of Apache, MySQL, and PHP for Mac OS X and Windows. He also shows how to define sites, integrate ColdFusion and PHP, implement AJAX-style pages with the Spry framework, add visual effects, and present XML-formatted data. David explores Dreamweaver's new features, Live View and Live Code, showing how they can be used to build and test web pages before they go live. Exercise files accompany the course.

Topics include:
  • Installing software Authenticating users Integrating websites with ColdFusion and PHP Layering web pages with the Spry framework Adding visual effects to a web page Building data-entry systems Testing web pages with Live View and Live Code
Subjects:
Developer Web
Software:
Dreamweaver
Author:
David Gassner

Using the Record Update Form wizard

Just as when creating a data entry form that allows users to insert data into a database table, when you create a form that will allow the user to update the data, you can also choose between using a wizard that creates the form and all of the server behaviors in a single step or you can create your own custom form and then apply the server behaviors. In this video, I'll show you how to use the Record Update Wizard. This wizard will take a page that already has the data that needs to be updated, that is, a record set containing a single row from a database table, and it will generate a complete data entry form and all of the required server behaviors.

I am starting with the page Title Insert. This page already has two record sets. Just as with the insert form that I built previously, I'm going to use these record sets to populate lists of available data that will be a part of the form. Now, I'm going to save this page with a new name. I'll select File > Save As, and I'll give the page a new name of titleupdatewithwizard. Now, I'm going to add another record set. This record set will contain the data for a single row of the database table.

I will go to the Bindings panel and click the Plus button and select Recordset (Query). I'll name the record set rsTitle. Notice that it's a singular name rather than rs Titles because it's going to contain a single row of data. I'll set the Connection to dw_bookstore and the Table to titles, and I'm going to leave all of the columns selected because I want the user to be able to modify all of the data in the database table. Now, I'm going to apply a Filter. The Filter should always be applied here to the primary key column of the database table. The primary key column, that is, the unique identifying column, is title _id and I'm going to set the Filter to match a URL Parameter that's a value that's passed in as part of a hyperlink, and the name of the URL Parameter will match the database column name title_id.

Now, I'm going to click the Test button, and notice that I'm prompted for a value that I want to filter on. You must pass in a value here of an existing record if you want to see data returned correctly. I'll set the test value as BU1032, which I know is a valid title ID in one of the records, and I'll click OK and I'll confirm that I'm getting back a single row of data from the database table. Then I'll click OK and click OK again to close the Recordset Builder. Now, I'm ready to apply the wizard. I'll go the menu and select Insert > Data Objects > Update Record > Record Update Form Wizard. Here is the Wizard dialog box. As with most of these wizards that have to do with dynamic data, you must select a Connection, and a Table in this case the one you want to update. The Connection should be dw_bookstore again and the Table should be Titles. The Select Record From option asks you which record set the data to update is coming from, and I'll select rsTitle, which contains the one and only item.

You also need to indicate which is the primary key column, here called the Unique Key. And Dreamweaver will usually get this right, particularly with MySQL. Set the Unique key column to title_id and then click Browse to indicate which page you want to go to after the update is complete. I'll click the Browse button, and I'll select the titlelist page either .php or .cfm. Now, I'm going to indicate what kind of form controls I want to use for each item. Notice that the title_id is displayed as pure Text. You never update or change the Primary Key or the Unique Key column. So that value simply displayed but left alone.

The title is a text field. That's fine. Now, for the pub_id column, just as in the insert form, I'm going to use what Dreamweaver calls a menu. I'll select the list of form controls and choose Menu. Then I'll click the New Menu Properties button, and as before I'll set the Menu items From database and indicate that I want to pull the data for this column from rsPubs, getting the labels from pub_name and the values from pub_id. Notice that there is an item here called Select value equal to, and I'll scroll down to the end and I'll show you that we are matching the pub_id value of the current record set. If you wanted to change this for any reason, you would click the little Lightning Bolt button, and then select the column that you wanted to match.

So I'll cancel out of that and then click OK to save the change, and then I'll go through the same steps for the au_id column. I'll set the Display As option to Menu, click Menu Properties, Populate the menu items from the database. This time choosing the record set rsAuthors. I'll set the labels from au_lname and the values from au_id, check the code that's populating the current value as au_id and then I'll click OK. I will make one more change. For the Notes column, I'll change this value from a Text field to a Text area because this is a longer value, and I want the user to be able to type in as much text as they need to.

Those were all the changes. Now, I'll click OK and generate my form page. As in the previous example, when the form is generated, it will drop into a place in the page other than the content area. So I'll click into the form anywhere I like, then I'll go down to the Tag Selector and make sure I click the surrounding form tag and then cut to clipboard. Then I'll place the cursor inside the Content Area, press Enter to create a new paragraph, and paste from the clipboard, and that places the content that is the data entry form in the correct location in the page.

Now, I'll save and test the page. I'll preview it in an external browser. Now, in ColdFusion, you might see a default record show up, but if you don't see that happen in PHP, just go up to the browser's address field and add the following to the URL. Put in a question mark at the end of the URL and then put in the name of the field that's expected to filter on, title_id in lower case, and then an equals operator, and then the value of the primary key column in the row you want to test.

I will run the page again with those values and you should now see that the values from the database row show up in the form. I'll make a very simple change I'll go up to the Title, and I'm just going to modify the title, so I can see the value easily when I return to the List page. I'll change the title from the Busy Executive's Database Guide to DB guide and then I'll click the Update Record button, which will take me back to the Book List page, and then I'll locate the record that I just updated and show that it's been changed in the database and the new change is reflected in the list.

So that's how you use the wizard to generate the data entry form and all of the required server behaviors in a single pass. In the next set of videos, I'll show you an alternative approach creating the form yourself, and then applying the server behaviors after the fact.

Find answers to the most frequently asked questions about Dreamweaver CS4 Dynamic Development .


Expand all | Collapse all
please wait ...
Q: I set up the Apache server in MAMP I am not able to get green lights on the Apache server with the default port. If I use 8888 for Apache port and 8889 for MySQL port, the green lights for server connection appear. Why don't I get server connection with default settings of Apache Port 80 and MYSQL 3306?
A: You might have another copy of the Apache web server running on your system that conflicts with the version included in MAMP. Go to your Mac's System Preferences and click Sharing. Then make sure that Web Sharing is disabled - this preference on Mac OS X controls whether the included Apache server is running.
After disabling Web Sharing, go back to MAMP and try to change the ports to the standard ports, 80 (Apache) and 3306 (MySQL).
 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Dreamweaver CS4 Dynamic Development.

Return to your organization's learning portal to continue training, or close this page.


OK

Upgrade to View Courses Offline

login

With our new Desktop App, Annual Premium Members can download courses for Internet-free viewing.

Upgrade Now

After upgrading, download Desktop App Here.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Start your FREE 10-day trial

Begin learning software, business, and creative skills—anytime,
anywhere—with video instruction from recognized industry experts.
lynda.com provides
Unlimited access to over 4,000 courses—more than 100,000 video tutorials
Expert-led instruction
On-the-go learning. Watch from your computer, tablet, or mobile device. Switch back and forth as you choose.
Start Your FREE Trial Now
 

A trusted source for knowledge.

 

We provide training to more than 4 million people, and our members tell us that lynda.com helps them stay ahead of software updates, pick up brand-new skills, switch careers, land promotions, and explore new hobbies. What can we help you do?

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.