Questions tagged [history]
The history tag has no usage guidance.
10
questions
0
votes
3
answers
54
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
1
answer
270
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
1
answer
480
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
1
answer
525
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
1
answer
282
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
0
answers
144
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
1
answer
152
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
0
answers
101
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
2
answers
416
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
3
answers
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 ...