Questions tagged [history]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
3answers
34 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
130 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
400 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
473 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
204 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
407 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 ...