JavaScript
x
18
18
1
@app.route('/upload', methods=["GET", "POST"])
2
def upload():
3
if request.method == 'POST':
4
5
file = request.files['upFile']
6
file.save(os.path.join(app.config['UPLOAD_FOLDER'], file.filename))
7
8
dir = app.config['UPLOAD_FOLDER']+ file.filename
9
10
cmd = "INSERT INTO posts (title, author, file, date, subject, field ) VALUES (%s, %s, %s, %s, %s, %s)"
11
post = (request.form["title"], session['user_name'], dir, x, request.form["subject"], request.form.getlist("field[]"))
12
crsr.execute(cmd, post)
13
mydb.commit()
14
15
return redirect(url_for('upload'))
16
else:
17
return render_template('upload.htm')
18
it returns : MySQLInterfaceError: Python type list cannot be converted
Advertisement
Answer
One solution is to convert list to string like this.
JavaScript
1
2
1
','.join(list)
2