Hi,
I try to send the following SQL Operator: '<' but I get an error, because, I think, that when the ODBCSocketServer parse the xml request he removes the '<' so the SQL query is not executed.
Logged In: YES user_id=352983
I have the same error... i try with single and double quotes but dont work...
then what will be the solution??
Logged In: YES user_id=371447
its not removed, but it is changed into a &lt;.
Relevant code =
sSQL = SubStrReplace(sSQL, "&lt;", "<" );
sSQL = SubStrReplace(sSQL, "&gt;", ">");
sSQL = SubStrReplace(sSQL, "&amp;", "&");
What does your event log say the SQL statment looked like? The full SQL statment should be in the applications log.
Logged In: YES user_id=36697
Dear sir,
OK,
Regards,
Yves
Log in to post a comment.
Logged In: YES
user_id=352983
I have the same error...
i try with single and double quotes but dont work...
then what will be the solution??
Logged In: YES
user_id=371447
its not removed, but it is changed into a &lt;.
Relevant code =
sSQL = SubStrReplace(sSQL, "&lt;", "<" );
sSQL = SubStrReplace(sSQL, "&gt;", ">");
sSQL = SubStrReplace(sSQL, "&amp;", "&");
Logged In: YES
user_id=371447
What does your event log say the SQL statment looked like?
The full SQL statment should be in the applications log.
Logged In: YES
user_id=36697
Dear sir,
OK,
Regards,
Yves