All Questions
Tagged with sql sqlalchemy
4 questions
0
votes
1
answer
23
views
Difference between { var } vs :var as placeholder - SQL, Postgre
I was wondering if it's a good idea to use { var } in place of :var as placeholder?
This is what I see in CS50 notes:
flight = db.execute("SELECT * FROM flights WHERE id = :id", {"id": flight_id})....
- 103
0
votes
1
answer
623
views
SQL SELECT query for multiple word search
I'm working through project 1 in the CS50 Web Programming course. I have created a search form which is just one text box in the middle of the page where the user can type in the ISBN number, the ...
- 3
0
votes
1
answer
674
views
It is not displaying data the query order from Flask SQLAlchemy
I was trying to display data tables from my db on same page like from one table only one row from another table all the rows and is displaying the data from first table but from second table is not is ...
- 5
0
votes
1
answer
760
views
Finance: Update SQL Data: db.execute
Trying to add functionality to modify number of shares.
This won't work:
num_sell = request.form["num_sell"]
db.execute("UPDATE purchases SET shares=num_sell WHERE order_num=1")
"RuntimeError: (...
- 167