Menu

#2 missing SQL operator

open
nobody
None
5
2001-06-01
2001-06-01
No

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.

Discussion

  • Nestor Beltran Torres

    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??

     
  • Aj

    Aj - 2001-12-05

    Logged In: YES
    user_id=371447

    its not removed, but it is changed into a <.

    Relevant code =

    sSQL = SubStrReplace(sSQL, "<", "<" );

    sSQL = SubStrReplace(sSQL, ">", ">");

    sSQL = SubStrReplace(sSQL, "&", "&");

     
  • Aj

    Aj - 2001-12-05

    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.

     
  • Yves Guérin

    Yves Guérin - 2001-12-06

    Logged In: YES
    user_id=36697

    Dear sir,

    OK,

    Regards,

    Yves

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.