hi
i want to save uploaded file( image) in my sql server but show this error :
ProgrammingError: ('Invalid parameter type. param-index=9 param-type=UploadedFile', 'HY105')
Traceback:
add_data(BBN,RT,HD,LF,LM,WM,WL,RLW,FE,image)
c2.execute('INSERT INTO bdata(BBN,RT,HD,LF,LM,WM,WL,RLW,FE,image) VALUES (?,?,?,?,?,?,?,?,?,?)',(BBN,RT,HD,LF,LM,WM,WL,RLW,FE,image)
this is part of my code :
STONE=['Magnetite', 'Hematite', 'Soil', 'Waste Rock', 'Cong-Waste Rock',
'Conglomerate', 'magn-Waste Rock', 'Soil-Cong', 'Soil-Waste Rock', 'So-Co-Waste Rock']
RT=st.selectbox('Rock Type:',STONE)
HD=st.radio('Hole Diameter:',( 8.5, 10.5, 6.5, 7.5))
image = st.file_uploader("Upload", type="jpg")
if st.button("Add row"):
add_data(BBN,RT,HD,LF,LM,WM,WL,RLW,FE,image)
st.success("You have successfully added Blast")
sql_query = pd.read_sql_query('SELECT * FROM Blast.dbo.bdata',conn2)
st.write("DATABASE")
st.write(sql_query)
st.write("\n")