ormcoldfusionhqlcfmlcoldfusion-2018

ColdFusion ORMExecuteQuery ORM missing mapping

I am trying to use ORMExecuteQuery. To do queries something like this:

ORMExecuteQuery("select count(*) from Customer");

This shows an error. So I have reduced the complexity of statement now to something smaller

// This works
rc.Customers = EntityLoad("Customer");

// This crashes
rc.Customers2 = ORMExecuteQuery("from Customer");

enter image description here

Solution

  • I have seen issues with ORMExecuteQuery() and the case of the object name.

    Try using

    ORMExecuteQuery("from customer");