Skip to main content
Onix68
Onix68
Participant
February 15, 2011
Question

Insert Record - value - submit as?

  • February 15, 2011
  • 1 reply
  • 983 views

Hello

I am new here so if this question has been asked before please just drop
the link in as I have been searching with no luck todate.

The problem I am not sure is server side or dreamweaver, so I would like to
ask I have my Recordset and need some advice about what Values/Submit
fields should I use for a dynamic list/menu ie Value - FORM.comments Submit as: Text?
or if I am barking up the wrong tree a link to good info guide site would be most helpful.

Kind regards.

Onix68

This topic has been closed for replies.

1 reply

Y
YWSW
Known Participant
February 15, 2011

I am not sure I understand your question.

If you are using have set the "Display As" for one of your "column" to "Menu" and have set the "Menu Properties" to "populate menu items from database" then Dreamweaver allows you to get both the labels and the values from the same database.

The "values", in this case, will be automatically what is submitted (inserted) into your database.

Onix68
Onix68Author
Participant
February 15, 2011

Hello YWSW,

sorry I am sure it's me and my lack of knowlege, but I am trying
What I would like on my website is something simular to this see pic below.


I have set up my table in my data base with input fields, and all fields are working fine
apart from the above,  I have a Recordset within Dreamweaver and a record which needs
a value/submit as am I correct or is this something I should take care of at the server end?

I hope I have explained myself better
K.Regards

Y
YWSW
Known Participant
February 15, 2011

Ok.

I am assuming you have manually created the menu form. If this is so then you should have a form name. Then when you open the "Insert Record" box, you will choose this form name in the "submit values from". Let us assume the name you choose for your form is "Onix68sForm", then this would be the name you choose for the "submit values from" box. Then choose the correct database table to insert the info into ("insert table"). So far, you seem to already have done.

In the "columns" menu, all of the fields in your table will be shown. They will all not have any value. Choose the field where you want the "how did you hear about us?" info should go. Then, you would need to assign it, and only it, a value. This you do in the "value" slot, where you choose the form (Form.Onix68sForm). Dreamweaver will automatically put the correct selection into "submit as". If you have set the field to text (which you probable did) then Dreamweaver will automatically set it as 'Text'.

If the above did not work, then the problem lies in how you set up the form and not in the server-side scripting. Make sure that each of your menu selections ("search engine", "recommendation", etc.) has a value set to it. It is this value which your database will recieve when the user chooses the selection from your menu. For simplicity's sake you might want these values to be the same as the name you have given it in the menu (technically you could also set it to integers- such as "search engine" will have the value of "1" and your field in your database will be set to integer (in which case Dreamweaver will automatically set the "submit as" in the record insertion box to "int").

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices