Jump to content

Hillel

Members
  • Content Count

    4
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Hillel

  • Rank
    Newbie
  1. Hillel

    XML Tutorial

    Hello, Synook.You are right, "window" not so is important.It is valid code too:...else if (ActiveXObject)... But this code not working: ...else if (ActiveXObject("Microsoft.XMLDOM"))... This fragment of a code (ActiveXObject("Microsoft.XMLDOM")) is completely not necessary, besides it still does problems, I user EI6 - I checked it.Thanks.
  2. Hillel

    Basic Sql Question

    Hello, Synook.I don`t know what exactly wants Nift...But this query:SQL> SELECT c.cid, o.pidFROM customers AS cJOIN orders AS oON c.cid = o.cid WHERE o.pid='p01' OR o.pid='p02'; Gives this result: +-------+-------+| c.cid | o.pid |+-------+-------+| c001 | p01 || c001 | p01 || c001 | p02 || c004 | p01 || c006 | p01 || c006 | p01 |+-------+-------+ It is possible to use here "GROUP BY" or "DISTINCT" depending on concrete requirement.Thanks.
  3. Hillel

    Basic Sql Question

    Hello.For you it is not the valid SQL query (WHERE pid='p01' AND pid='p02'): SQL> SELECT customers.cid FROM customers JOIN orders ON customers.cid = orders.cid WHERE pid='p01' AND pid='p02'; And it is the valid SQL query (WHERE pid='p01' OR pid='p02'): SQL> SELECT customers.cid FROM customers JOIN orders ON customers.cid = orders.cid WHERE pid='p01' OR pid='p02'; Thanks.
  4. Hillel

    XML Tutorial

    Hello.There is an error in "XML to HTML" chapter, its example is not valid for browser EI6 (I'm user EI6).Not valid code: ...else if (ActiveXObject("Microsoft.XMLDOM"))... Valid code: ...else if (window.ActiveXObject)... Thanks.
×