Insert Record - value - submit as?

Report · Feb 15, 2011

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

Report · Feb 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.

Report · Feb 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

Report · Feb 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").

Report · Feb 17, 2011

Hello again,

I have doubled checked everything and unfortunatly I am still having a problem with
a value to indicate which dropdown selection has been made and registered on my
database table.
When I fill in the form and refresh the database table, all fields are present and correct
apart from all the "list/menu" fields have a "0" so there is no way of knowing what the
user selected.
As YWSW so rightly suggested all fields in the colums have a value and I aggree the
problem is with the form, the Recordset looks fine with "search engine" etc having a
Value: FORM dpmenu Submit as: Integer.
However when I click with in the dropdown menu and select Dynamic from the properties
I can see my fields.
Option from Recordset: NONE
Values: BLANKED OUT
Lables: BLANKED OUT
Select value equal to: <?php $row_Recordset1[' '] ?>

If I select the options from recordset: I have the option of NONE or Recordset1.
If I select Recordset1 this then opens up the values and lables, of all the fields
in my database and the value and lables can only be the name given to the fields.

I do apologise in advance if this subject is getting tirsum as I am sure it's something simple
I have overseen.

If anybody knows or has a link to how to achieve dropdown menu's being registered on a
database using Dreamweaver I would be very greatful as I can everything else but not this one.

K.regards

Report · Feb 19, 2011

Hello again,

Just to update I think I have it now , or at least I am gettin correct values into my database
all be it numerical values which correspond to the relevant fields which is a start.

I found some good excersises here by David Powers if anybody is intrested.
http://www.adobe.com/devnet/dreamweaver/articles/setup_testing_server.html

Thankyou YWSW