Does qcubed escape the % char in LIKE statements ?
Can you post the code snippet? There's a million ways you could be doing a SQL query in QCubed, so it's hard to tell. I don't recall that it would do the escaping, but to be sure, I need your code snippet to check against the QCubed codebase.
TestNode::QuerySingle( QQ::AndCondition( QQ::Like(QQN::TestNode()->Name, '%Bob%')
) );
Shouldn't something like this be auto escaped ?
Thanks.
If qq::like was auto-escaping the string parameter, how would you be able to specify a qquery condition that says "begins with Bob?
Yes, I guess it depends on the case. Thanks
© 2012 QCubed - All Rights Reserved. Valid XHTML 1.0 Strict | Valid CSS 2.1
Theme developed by pM using entirely open source solutions.
Can you post the code snippet? There's a million ways you could be doing a SQL query in QCubed, so it's hard to tell. I don't recall that it would do the escaping, but to be sure, I need your code snippet to check against the QCubed codebase.
TestNode::QuerySingle(
QQ::AndCondition(
QQ::Like(QQN::TestNode()->Name, '%Bob%')
)
);
Shouldn't something like this be auto escaped ?
Thanks.
If qq::like was auto-escaping the string parameter, how would you be able to specify a qquery condition that says "begins with Bob?
Yes, I guess it depends on the case.
Thanks