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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DW Add Record Behaviour and DFP

Thread began 6/23/2009 5:27 pm by Steve | Last modified 6/29/2009 1:42 pm by Ray Borduin | 1079 views | 3 replies |

Steve

DW Add Record Behaviour and DFP

Ok, I'm not seeing what is needed to save the name of the file I am uploading.

The upload works. The other data is saved to the DB but the File field value is not saving to the DB.

Here's the insert code:

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
$insertSQL = sprintf("INSERT INTO news (newsTitle, newsArtcl, newsImage, newsRank) VALUES (%s, %s, %s, %s)",
GetSQLValueString($_POST['Title'], "text"),
GetSQLValueString($_POST['event'], "text"),
GetSQLValueString($_POST['imageUp'], "text"),
GetSQLValueString($_POST['seq'], "int"));

Here is the input file field:

<input type="file" name="imageUp" id="imageUp">


I've tried the value as a $_FILE also and that did not help. Any ideas?

Sign in to reply to this post

Ray BorduinWebAssist

You can drag and drop the correct way to reference the server file name from the bindings panel and use that syntax in the code.

Sign in to reply to this post

Steve

Originally Said By: Ray Borduin
  You can drag and drop the correct way to reference the server file name from the bindings panel and use that syntax in the code.  



Ray I tried this and it did not work. I ponied up for the latest Data Assist plugin and will post a couple shortcomings I found there in a new post.

I think the problem is that a file field creates an array of values, and parsing them to the update or insert behavior needs a proper function to pull just the [name] value and integrate this with DWs insert or update behaviors. Also appending the extension is needed if you want to save the proper name of the file being updated.

Sign in to reply to this post

Ray BorduinWebAssist

It does not integrate with the DW insert and update. It can only be integrated with a more advanced server behavior like the insert and update that come with DataAssist.

From there the values should be available from bindings and can be used as you need. The arrays and values are all managed for you and you should be able to simply select the value you need from the list.

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