Hi, I'm trying to delete a record from a table where the ID column is a string:
$this->_adapter->delete('my_table', "id = :token", array('token' => $tokenId), array('token' => Column::BIND_PARAM_STR) );
When I try to execute the query it is raising the following syntax error:
LINE 1: DELETE FROM "my_table" WHERE id=816c85cdb28556d0a
The error occurs because the query is sending the token as numeric instead of as a string, how can I properly set the data type of the token, so the token is added as a string to the SQL query?
Thanks in advance!