Hi all, I recently tried to create a search function which is supposed to display all possible results in a table even if the title is incomplete. However, I am using python variables and hence have to use colon notation to sub it into the sql command, however I also learnt about wildcards. How then do I use both of them without resulting in a conflict or error? My code goes something like this:
```` @app.route("/movie_results") #im using flask def movie_results(): name = request.args.get("movie.title") search_movie_statement = sqlalchemy.text('SELECT * FROM movies WHERE title LIKE :movie_title') movie_specific = engine.execute(search_movie_statement, movie_title=name).fetchall() if movie_specific is not None: print(name) return render_template("movie_specific.html", movie_specific=movie_specific, name=name) if movie_specific is None: return render_template("error2.html", message="No such movie.") ```` Thanks, Cravan -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/5D3E94C9-50D3-4B5C-B722-B9C3FFE85293%40gmail.com. For more options, visit https://groups.google.com/d/optout.