Questions tagged [history]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
3answers
48 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
513 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

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
465 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
263 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
139 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
149 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
100 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
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 ...
0
votes
2answers
414 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. ...