Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. xml <= sql operator perceives as the beginning tag

xml <= sql operator perceives as the beginning tag

Scheduled Pinned Locked Moved Solved General and Desktop
2 Posts 1 Posters 507 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Taz742T Offline
    Taz742T Offline
    Taz742
    wrote on last edited by
    #1

    Hi All.
    I Have XML File, where save the query name and its significance.

            <queryname>search maximumprice</queryname>
            <queryvalue>
            select *,
            (select valutaname from valuta where uid = (select valutauid from cash where operationsuid = operations.uid) ) as valuta1,
            (select valutaname from valuta where uid = (select valutauid from cash where operationsuid = operations.uid order by UID desc)) as valuta2,
            (select amount from cash where operationsuid = operations.uid ) as cash1,
            (select amount from cash where operationsuid = operations.uid order by uid desc ) as cash2,
            (select ratebuy from exchangerate where valutauid = (select valutauid from cash where operationsuid = operations.uid order by UID desc) ) as 
           kursi1,
            (select ratesell from exchangerate where valutauid = (select valutauid from cash where operationsuid = operations.uid order by UID desc) ) as kursi2
            from operations
            inner join olduser on operations.olduserid = olduser.uid
            where cash1 <= 1000
            order by operations.uid
            </queryvalue>
    

    But <= operator is red

    alt text

    Do what you want.

    Taz742T 1 Reply Last reply
    0
    • Taz742T Taz742

      Hi All.
      I Have XML File, where save the query name and its significance.

              <queryname>search maximumprice</queryname>
              <queryvalue>
              select *,
              (select valutaname from valuta where uid = (select valutauid from cash where operationsuid = operations.uid) ) as valuta1,
              (select valutaname from valuta where uid = (select valutauid from cash where operationsuid = operations.uid order by UID desc)) as valuta2,
              (select amount from cash where operationsuid = operations.uid ) as cash1,
              (select amount from cash where operationsuid = operations.uid order by uid desc ) as cash2,
              (select ratebuy from exchangerate where valutauid = (select valutauid from cash where operationsuid = operations.uid order by UID desc) ) as 
             kursi1,
              (select ratesell from exchangerate where valutauid = (select valutauid from cash where operationsuid = operations.uid order by UID desc) ) as kursi2
              from operations
              inner join olduser on operations.olduserid = olduser.uid
              where cash1 <= 1000
              order by operations.uid
              </queryvalue>
      

      But <= operator is red

      alt text

      Taz742T Offline
      Taz742T Offline
      Taz742
      wrote on last edited by Taz742
      #2

      sorry its solved.
      where cash1 & l t;= :value

      XML escape characters
      
      There are only five:
      
      "   &quot;
      '   &apos;
      <   &lt;
      >   &gt;
      &   &amp;
      

      Do what you want.

      1 Reply Last reply
      2

      • Login

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • Users
      • Groups
      • Search
      • Get Qt Extensions
      • Unsolved