Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Using the Record Update Form wizard

From: Dreamweaver CS4 Dynamic Development

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.

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.

Show transcript

This video is part of

Image for Dreamweaver CS4 Dynamic Development
Dreamweaver CS4 Dynamic Development

78 video lessons · 24305 viewers

David Gassner
Author

 
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 17s
    1. Installing ColdFusion on Windows
      4m 38s
    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 0s
    9. Inserting simple ColdFusion commands
      3m 25s
    10. Using server-side includes
      7m 10s
    11. Defining a ColdFusion data source
      6m 47s
  6. 46m 36s
    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 32s
  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. 53s
    1. Goodbye
      53s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
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

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
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?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

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:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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.