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?

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.

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.

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.