[jemiris]

Hi,
Some times the executeQuery function is not working. To over come the issue i have gone through the processmaker source code. below code works well

Code: Select all

$cnn = Propel::getConnection(SYS_SYS);  // SYS_SYS - will take the current database name
$stmt = $cnn->createStatement();

$date = date("Y-m-d h:i:s");
$query = "UPDATE PMT_BOOK SET NAME = '".$name."',TITLE = '".$title."',AUTHOR = '".$author."',BARROW = '".$barrow."', RETURNED = '".$return."'  WHERE ID = 1";        
       
$result = $stmt->executeQuery($query, ResultSet::FETCHMODE_ASSOC);

// echo '<pre>';print_r($result);die;

[programerboy]

Hi,
Thanks for your post.
I also use this code for some update queries:

Code: Select all

$con = Propel::getConnection( $mysql_core );
$con->executeUpdate( $update_query );

https://pmlearning.info
Thanks