All Questions
2 questions
0
votes
1
answer
91
views
pset7 "index" - using SQL SUM adds a parenthesis to returned dict strings
I executed the following to return a dict (grouped by stock symbols) of stock symbols, total shares and total value owned.
stocks = db.execute("SELECT buy.stock_code, SUM(buy.value), SUM(buy.shares) ...
- 5
1
vote
2
answers
181
views
Pset7 => "NoneType" error on SELECT query (2017)
I’m really stuck on the index part of PSET7….
Flask keeps iterating over the following SELECT query:
dab = db.execute("SELECT SUM(share) FROM portfolio WHERE symbol = :symbol AND user_id = :user_id",...
- 21