MySQLi problem
OS is Win 7
DW is CS6 Ver12.0 Build 5808
MySQLi is Version 1.0.3
Yes I always use the lightning bolt and only hand code to remove errors.
I've just tried to edit an update server behaviour to test and have had the following sequence of events.
The MySQLi Update record window appears with a succession of error windows with a message
'It appears that one of your server-side values is improperly coded. Please check this interface for inconsistencies.'
The previously correct code is escaped starting at the fourth field.
Code fragment below is after correcting corrupted code using lightning bolt which just makes it worse.
$UpdateQuery->bindColumn("UserAddress1", "s", "".((isset($_POST["address1"]))?$_POST["address1"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("UserAddress2", "s", "".((isset($_POST["address2"]))?$_POST["address2"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("UserCity", "s", "".((isset($_POST["city"]))?$_POST["city"]:"") ."?$_POST[\"city\"]:\"\") .\"", "WA_DEFAULT");
$UpdateQuery->bindColumn("UserState", "s", "".((isset($_POST["state"]))?$_POST["state"]:"") ."?$_POST[\"state\"]:\"\") .\"", "WA_DEFAULT");