title: Python Flask Jinja SQL: No value being passed to template
body: <p>In my GET portion of the Flask function I'm working on I have some very simple code written in Python 3.  The data I'm trying to pass in is never displayed on my HTML render.</p>
  
  <pre><code>@app.route("/sellselected", methods=["GET", "POST"])
  @login_required
  def sellselected(order_num):
      if request.method == "POST":
          #not done, just have a redirect to index
      else:
          stock_to_sell = db.execute("SELECT * FROM purchases WHERE order_num = :order_num", order_num=order_num)
          #stock_to_sell = ['fish']
  
      return render_template("sellselected.html", stock_to_sell=stock_to_sell, order_num=order_num)
  </code></pre>
  
  <p>The SQL statement seems to passing in nothing, it's just blank on the HTML render.  But as a test I also used 'fish' and it's None/empty too.</p>
  
  <p>Jinja looks like:</p>
  
  <pre><code>{% block main %}
  &lt;list&gt;
      &lt;ul&gt;{{ stock_to_sell }}&lt;/ul&gt;
      &lt;ul&gt;{{ order_num }}&lt;/ul&gt;
  &lt;/list&gt;
  {% endblock %}
  </code></pre>
  
  <p>So the body of the page has the order number, but stock_to_sell is always empty.</p>