Dreamweaver to Web Assist Insert

I have a working Dreamweaver insert that I need to use on my WA forms, however, because of my inexperience I am having trouble getting it to work with Data Assist. I don't know how to insert the values collected from three fields into one field.

Could you please tell me how would I do this Dreamweaver insert using Data Assist?

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "starttime")) {
$insertSQL = sprintf("INSERT INTO starttimelist (StartTime) VALUES (%s)",
GetSQLValueString($_POST['hour'] . ':' . $_POST['min'] . ':00', "date"));


Please provide lots of detail.
Thank you.

You can do something very similar to what you have here in the code. You could concatenate the values together when specifying the value in the insert interface.

When you select the colum to hold this value you can specify the value like this:

<?php echo $_POST['hour'] . ':' . $_POST['min'] . ':00' ?>

This should achieve the same result and store the concatenated values in that column in your table.

Thank you very much for your reply.

I inserted your suggestion into the WA Insert Record Wizard in Step 2:
Column: StartTime
Type: Date
Value: <?php echo $_POST['hour'] . ':' . $_POST['min'] . ':00'; ?>

However instead of inserting the values as the DW insert did I get this error:

Column 'StartTime' cannot be null

I have tried shifting the code order on the page and moving the recordset to after the insert statement, but I'm uncertain why the insert isn't working and what to do next to get it to work.

I would appreciate some more help getting this insert to work.

Thank you.

After creating a new page using your code the page now works.
Thank you again for your suggestion.