MySQLi Insert Record doesn't save file names to database. To replicate the error that occurs though try this...
1) Create a MySQLi Insert Record with a file upload field
2) Add the File Manipulation > Upload Files behaviour
3) In the column bindings for the MySQLi Insert Record behaviour bind the file field in your database to the [fielfieldname] Simple File Name option in your Insert form.
4) This inserts something similar to this:
<?php echo((isset($_FILES["filenamefield"]))? preg_replace('/.[^.]*$/', '', $_FILES["filenamefield"]["name"]) :"") ?>
5) OK
You'll end up this either this:
$InsertQuery->bindColumn("filenamefield", "s", "".((isset($_FILES["filenamefield"]))? preg_replace('/.[^.]*$/', '', $_FILES["filenamefield"]["name"]) :"") ."", "filenamefield"]["name"]) :"") ."", "WA_DEFAULT");
Or this:
$InsertQuery->bindColumn("filenamefield", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."", "filenamefield"]["name"]) :"") ."", "WA_DEFAULT");
With error sometimes...
"It appears that one of your server-side values is improperly coded. Please check this interface for inconsistencies."
So, go back in to the Column Bindings section and this time bind the database field field to the Upload Files (filenamefield) > Server File Name or Upload Files (filenamefield) > Simple Server File Name (neither work).
Upload and you'll find that it doesn't save the file name to database but does upload the file.
Tearing my hair (what's left of it) out here.
Please help.
NJ