Reputation: 33655
ORMExecuteQuery() seem to return an array for the following
example = ormExecuteQuery("select count(commentID) as n from pComment c");
output uing cfdump for example would be...
array
[1][x]
where x is count.
How can I just get n as a number and not an array object returned? I want to just getn()
Upvotes: 3
Views: 743
Reputation: 6956
Try this:
example = ormExecuteQuery("select count(commentID) as n from pComment c", true);
Second argument is known as unique
, despite it's confusing name it makes exactly what you need: makes function to return single value.
Upvotes: 4