Questions tagged [history]
The history tag has no usage guidance.
10
questions
0
votes
3answers
38 views
pset8 Finance History - rows repeat in the table in number of times per length of rows
Do not know the reasons why the row in the HTML table will repeat in number of times per the length of rows. Please see my codes as follows:
application.py
rows = db.execute("SELECT * FROM ...
0
votes
1answer
157 views
Finance history, runtime error(“unsupported value: {}”.format(value))
After creating a table to handle and record all transactions, I seem to run into problems with my buy and sell functions when I try to update the history table. Specifically this line of code:
# ...
0
votes
1answer
422 views
how to make a history table pset8
I can not get a history table to work. I'm confused about how to get each value that needs to be in each row of the table. Here is what I have right now, I just don't understand how to pull each value ...
0
votes
1answer
484 views
Missing value for placeholder user_id pset8 history
So when I try to make a history table, with some code that looks like
purchases = db.execute("SELECT stock, boughtsold, price, shares, time, user_id FROM history WHERE user_id = :user_id")
for ...
0
votes
1answer
221 views
Inserting transaction type into SQL database (CS50 Finance)
I am currently encountering an issue where my code won't insert the transaction type into my history database. If I remove transaction from the SQL querry the code works fine. Any ideas what the issue ...
0
votes
0answers
135 views
Pset7, history,date
In Pset7, history, I'm trying to sort the data by date, I tried ORDER BY but it gave me"syntax error near when"(when is the date column name, and its data type is: DATETIME) .. what is the right way ...
0
votes
1answer
146 views
How to factor out similarities in history and portfolio tables?
I did the history problem by making a separate table with all of the values that I wanted to show to the user, all of which were the same as that of my portfolio page but instead would not be deleted ...
0
votes
0answers
98 views
how to save history
i am through with the register and quote but why do i get this error in trying to create history?
Fatal error: Table 'pset7.history' doesn't exist in /home/ubuntu/workspace/pset7/vendor/library50-...
0
votes
2answers
410 views
pset7(finance) - SQL command will not insert a new row for history
I'm having one last hiccup with my implementation of history. Everything about it works just fine except for the fact that it appears that only one entry can be stored in my SQL table, permanently.
...
0
votes
3answers
1k views
Finance: Buy/Sell does not insert into MySQL history table
On pset7 and struggling with the history part.
When I buy or sell a stock, it's reflected in the portfolio and the cash available is also updated. However, it does not seem to be affecting the ...
