I am currently working on a project with the following techstack:
- Database: Intersystems IRIS
- Controller: PHP/PDO with IdiORM
The problem is that the IDs are not in a common format. For example: “ABX||242149||1||0||D” – So there are different keys seperated with “||” as delimiter. As long as the ID’s are like “232||ABH” the request with IdiORM is working but an ID like the first example gives the error message: “No columns were bound prior to calling SQLFetch”.
PHP code:
class TestController
{
public function test()
{
$out=IRIS::for_table('')->raw_query("select id from Bestand where artikelnr='430030'")->find_array();
echo json_encode($out);
}
}
Are there any restrictions for IdiORM due to the ID format? It seems like the ORM cant map the given ID to the ID column?