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

Dreamweaver to Web Assist Insert

Thread began 12/18/2009 7:42 pm by jurinski334466 | Last modified 12/22/2009 7:46 am by jurinski334466 | 775 views | 3 replies |

jurinski334466

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.

Sign in to reply to this post

Eric Mittman

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:
<?php echo $_POST['hour'] . ':' $_POST['min'] . ':00' ?>



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

Sign in to reply to this post

jurinski334466

Dreamweaver to Web Assist Insert

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.

Sign in to reply to this post

jurinski334466

Dreamweaver to Web Assist Insert

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

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