PHsPeed forums
Cloud Connectors parameters names can't be superset of other parameter names
-
Hi, I guess the best way to describe this problem is a sample:
If you create a Cloud Connector parameter named say
:myparameter
and then you create a second parameter (in the same or another dataset, doesn't matter), and the name of the second parameter is a superset of the first, like:
:myparametertwo
Then the SELECT sentence generated replace the ":myparameter" string resulting in something like:
SELECT field_list FROM table_name WHERE field = 'value'two
As you can see, the parameter string is replaced but the remaining "two" string is not, resulting in a SQL syntax error.
WORKAROUND: Change the naming. For now I'm using a sequence, like
:myparameter01
:myparameter02
Thus preventing a name to being a superset o subset of any other parameter name.
Regards -
Issue is fixed. Will be released in 3.5. As a quick fix, locate spdbtable.php in the runtime and change:
// apply the the cloud connector// $this->links['dept_emp_dept_no']=rtrGetVar('dept_emp_dept_no');public function applyLink($where) {if(method_exists($this->app, '__getLink')) {$this->app->__getLink();}$t=$this->selectSQLLink;if(count($this->app->links)==0) {return ' where 1=1';}foreach($this->app->links as $key=>$value) {if($value==null) {}$t=str_replace(':'.$key.' ',"'".$value."'", $t); // fix #478}if($where!='') {return $t.' and '.$where;} else {if($t!='') {return ' where '.$t;} else {return ' where 1=1';}}} -
