ERROR Source of data can't be empty

Suite and Optimus Suite 5
#1

Hi Guys,

i’m trying to set up a render_sql with form connector and got the following error message “Source of data can’t be empty”, any ideas?

here’s my sample code:

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (‘Error connecting to mysql’);
mysql_select_db($dbname);
$formConnector = new FormConnector($conn);
$formConnector->render_sql(“update ruiqisition set jobTitle=‘test’ where id=‘1’”,“id”,“id,jobTitle”);

Thx,
Stijn

#2

Misspelled requisition?

#3

render_sql must provide select query, not update

$formConnector->render_sql("select id, jobTitle from ruiqisition","id","id,jobTitle");
#4

Thx for the response, but a new question arrises of course

how to perform an update with formConnector?

Stijn

#5

If you have linked form to dataprocessor, it will send update request and server side code will try to make update code automatically from provided sql select code.

If you need some custom logic - you can define custom sql or assign custom code, from each any custom logic can be called.

docs.dhtmlx.com/doku.php?id=dhtm … ex_updates