I'm getting some inconsistent results with deleteByQuery(). When I
comment out deleteByQuery() and use getByQuery() instead, the full
recordset is being returned correctly, however deletes aren't always
being made when the original function is run.
Could it be that it's because I'm passing in the table and column
names dynamically? Interestingly, it works fine with getWhere
().isLike() with Strings, but not isEqual() with numeric values.
Here's what I've got (where variables.dbservice is reactor set in init
()):
<cfargument name="qArg" required="true" />
<cfscript>
var qGateway = variables.dbservice.createGateway(variables.table);
var gQuery = qGateway.createQuery();
gQuery.getWhere().isEqual(variables.table,variables.column,qArg);
qGateway.deleteByQuery(gQuery);
return true;
</cfscript>
I'm on the SVN trunk of reactor and have deleted project files and
restarted CF as well. CF debugging shows no SQL at all in the
"qGet" query for this function.
Thanks for your help,
Jon
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
