All Questions
Tagged with final-project sqlite
7 questions
0
votes
1
answer
96
views
CS50 Final Project Help: SQL QUERY...inserting row from one table into another table after button pressed
I have nearly finished the Cs50x course but I am stuck on my final project. I am creating a website called 'Letterbooks' (inspired by Letterboxd) that allows you to log books that you have read. I am ...
- 1
0
votes
0
answers
206
views
Final Project - Get sql to work html, python and flask
On my website for my final project I am able to enter the user info on the website, but the information is not being inserted into the sql table.
I feel that I am not understanding something very ...
0
votes
1
answer
81
views
Retrieving image from SQLite, "Invalid or Unsupported Image Format"
I am getting an Invalid or Unsupported Image Format when I open an image stored and retrieved in SQLite. When I input the convertToBinaryData file into the writeTofile function then the photo is ...
- 35
0
votes
1
answer
117
views
Nesting SQL queries in Flask (final project)
I've been trying to only insert new ids if they weren't inserted before in my database, but the problem I've been having is that I couldn't get the nested queries to work in Python Flask. Whatever I ...
0
votes
1
answer
246
views
Importing to sqlite for final project
I'm having problems importing a file into an sqlite database for my final project.
I have a .csv file which I want to import. I've created the table using the phplite GUI, with 14 fields (columns).
...
- 121
0
votes
1
answer
119
views
db.execute() executing only single time
When I enter amount, name, expinc in my html form it works for the first time, i.e. the entered data goes into database tables for the first time but whenever I try to enter data again it doesn't ...
- 1
0
votes
0
answers
23
views
CS50's PHPLIteAdmin [duplicate]
I am currently working on my final project, and I need to create a database which contains a table with a FOREIGN KEY field. Unfortunately, I've constantly been getting errors. Upon Googling them, I ...
- 31