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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Inserting Dynamic Menu into a DB

Thread began 7/16/2010 3:26 am by kelly1398725 | Last modified 8/27/2010 2:39 pm by Jason Byrnes | 1375 views | 5 replies |

kelly1398725

Inserting Dynamic Menu into a DB

Hello,
I have a dynamic drop down menu. It works fine. My problem is when I insert the values of the form fields into the DB table, it inserts the primary key ID no. instead of the form field name that was displayed which I would like inserted. Please anyone know how I can convert the values from ID to the form field name when inserting the records into the table? I have edited the insert record server behavior values but to no avail. When I get the values from the recordset, it inserts the field correctly, but then, the Dynamic Dropdown Menu would not work any more.
Thanks.
Also, btw, your new upgrades for the CS5 are working surprisingly great. I have not had the dreaded freezing issues and cache error since upgrade. I can't believe I can use your extensions for hours on end without having to delete DW caches and so on. Great improvement--now I think I am getting good value for my money--or maybe it was DW CS4 all along. Anyway, keep up the good work!

Sign in to reply to this post

Eric Mittman

To make it so that you are inserting the name rather than the id you will need to add in another recordset to the page. The recordset will have to filter results from the table that is used to populate this particular select list.

The steps are to open the page and add a new recordset, select the table that is populating this particular dropdown menu. At the bottom of the interface use the filtering options to filter on the id column with a form variable, then enter the name of your dropdown list that you are getting the id from.

Once you have the recordset on your page you can then update the insert server behavior to make use the column from this recordset for the name rather than inserting the posted value from the dropdown.

Sign in to reply to this post

kelly1398725

Thanks

Thanks Eric. That worked great!

Sign in to reply to this post

Eric Mittman

Glad to hear that, let us know if you have any other questions.

Sign in to reply to this post

stuart260375

Same problem, but not understanding

Hi There,

I'm experiencing the same problem, but not quite understanding the explanation. Can you explain this in lamings terms please?

Regards

Graham

Sign in to reply to this post

Jason ByrnesWebAssist

the form passes the id values.


to get the name, you need to create a recordset.


make note of the name of the form element.

then create a recordset.


in the filtering section, select the ID column. set the type of filtering to form element, then enter the form elements name.

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