close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Is DA supposed to auto-populate form to DB relationships?

Thread began 9/20/2009 11:34 pm by steve387748 | Last modified 9/22/2009 11:51 am by Jason Byrnes | 2015 views | 4 replies |

steve387748

Is DA supposed to auto-populate form to DB relationships? - RESOLVED

If you look at DW's approach to inserting a record from a form, if form inputs use a name similar to the database table column name, it will automatically match up the fields to insert the form into.

Is DA supposed to also do this or does it require a manual process for matching database table fields to the form inputs?


steve

Sign in to reply to this post

tom92909Beta Tester

The initial auto generated version might need some tweaking. I'd recommend double clicking on either the DA Insert or Update record behaviors for your page to make sure that your data is being sent to the correct table fields.

Sign in to reply to this post

Jason ByrnesWebAssist

If you use the DataAssist Wizard to create the page, it will match the form fields with the correct database column.

If you are adding the Insert record Behavior to the page manually, then you will need to manually bind the database columns to the form fields.

To bind the database column, select it in the list and click the Lightning bolt next to value. Expand the Form Collection in the Dynamic Data binding window and select the corresponding form element.

Sign in to reply to this post

Stevebo

Yes, I was using the manual mode to insert the record based on a form builder form for registering. Or at least I think I was. I clicked on Data Assist -> Insert ->Single Record Insert for the registration page which showed a wizard but none of the fields were matched up. I figured out how to do it manually, but was wondering if it functioned like the standard DW insert record behavior which automatically matches up fields in the table with the form input fields. So Data Assist doesn't function that way unless I use Data Assist to create a page? Does this mean a page from scratch using DA or will it always be a manual process if not using DA to create the page?

thanks,

steve

Sign in to reply to this post

Jason ByrnesWebAssist

If you manually add the server behavior to the page, you will need to match the fields up your self.


If you use the DataAssist wizard (The data assist wizard creates the Insert, Update, Delete, Search and Results Pages) it will match the form elements to the database columns for you when creating the page.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...