MagicMirror Forum
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • 3rd-Party-Modules
    • Donate
    • Discord
    • Register
    • Login
    A New Chapter for MagicMirror: The Community Takes the Lead
    Read the statement by Michael Teeuw here.

    Modul SQL Problem mit Variable

    Scheduled Pinned Locked Moved Solved Troubleshooting
    5 Posts 2 Posters 360 Views 2 Watching
    Loading More Posts
    • 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.
    • C Offline
      chris47803
      last edited by

      Hallo.

      Folgendes Script zeigt keine Ausgabe.

      {
                  module: 'MMM-MysqlQuery',
      			      position: "top_left",
      			      header: "Schulferien in den naechsten 14 Tagen", 
                  heute: "curdate(Y-m-d)",                                  
                  config: {
                      connection: {
                          host: "192.168.2.71",
                          port: "3306",
                          user: "pi",
                          password: "PW",
                          database: "ferien"
                      },
      
                      query: "SELECT ferienart, startdatum, enddatum FROM schulferien WHERE startdatum <= 'heute' AND enddatum >= 'heute' AND ferienart LIKE '%nordrhein%'",
          			intervalSeconds: 1 * 3600,
                      emptyMessage: "Keine Schulferien in den naechsten 14 Tagen",
                      columns: [
                          { name: "ferienart",           title: "Ferienart",  cssClass: "left" },
                          { name: "startdatum",          title: "Start", cssClass: "left" }, 
                          { name: "enddatum",            title: "Ende",      cssClass: "left" }                                                                                                                                                                                                    
                      ]
                  }
              },  
      Es müssten die Osterferien angezeigt werden.
      Stattdessen erscheint die Empty Message.
      R 1 Reply Last reply Reply Quote 0
      • C Offline
        chris47803
        last edited by

        Hat sich erledigt.

        {
            module: 'MMM-MysqlQuery',
            position: "top_left",
            header: "Schulferien in den naechsten 14 Tagen",
            config: {
                connection: {
                    host: "192.168.2.71",
                    port: "3306",
                    user: "pi",
                    password: "PW",
                    database: "ferien"
                },
                query: "SELECT ferienart, DATE_FORMAT(startdatum, '%d.%m.%Y') AS startdatum, DATE_FORMAT(enddatum, '%d.%m.%Y') AS enddatum FROM schulferien 
                    WHERE (
                          startdatum BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 14 DAY)
                          OR CURDATE() BETWEEN startdatum AND enddatum
                          )
                      AND YEAR(startdatum) = YEAR(CURDATE())
                      AND YEAR(enddatum) = YEAR(CURDATE())
                      AND ferienart LIKE '%nordrhein%'",
                intervalSeconds: 1 * 3600, // Aktualisierung jede Stunde
                emptyMessage: "Keine Schulferien in den naechsten 14 Tagen",
                columns: [
                    { name: "ferienart", title: "Ferienart", cssClass: "left" },
                    { name: "startdatum", title: "Start", cssClass: "left" }, 
                    { name: "enddatum", title: "Ende", cssClass: "left" }
                ]
            }
        },
        
        1 Reply Last reply Reply Quote 0
        • C chris47803 has marked this topic as solved on
        • R Online
          rkorell @chris47803
          last edited by

          @chris47803 Ist es gelöst?

          Mein Tip wäre gewesen, dass der LIKE Oprator case-sensitiv ist, daher “%nordrhein%” nicht gefunden wird, da es “%Nordrhein” heißen müsste…

          • Wie hast Du es tatsächlich gelöst?

          Gruß,
          Ralf

          C 1 Reply Last reply Reply Quote 0
          • C Offline
            chris47803 @rkorell
            last edited by

            @rkorell

            In meiner Datenbank steht nordrhein.
            Ich bin auch kein Programmierer.
            Den Code habe ich von ChatGPT :)

            R 1 Reply Last reply Reply Quote 0
            • R Online
              rkorell @chris47803
              last edited by

              @chris47803 :-)

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post
              Enjoying MagicMirror? Please consider a donation!
              MagicMirror created by Michael Teeuw.
              Forum managed by Sam, technical setup by Karsten.
              This forum is using NodeBB as its core | Contributors
              Contact | Privacy Policy