Help us test the new Databridge BETA with MySQLi support

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › mySQLi UPDATE nulls out fileField values

View all replies to this thread

mySQLi UPDATE nulls out fileField values

Thread began 6/18/2015 3:45 pm by LionsMane | Last modified 6/19/2015 2:25 pm by LionsMane | 1063 views | 4 replies

6/19/2015 1:47 pmRay BorduinWebAssist

Update this line:
$UpdateQuery->bindColumn("FileName", "s", "".((isset($_FILES["fileField"]))?$_FILES["fileField"]["name"]:"") ."", "WA_DEFAULT");

to:
$UpdateQuery->bindColumn("FileName", "s", "".((isset($_FILES["fileField"]))?$_FILES["fileField"]["name"]:"") ."", "WA_IGNORE");

That will tell it to ignore blank values for that field.

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.