Python3 + BeautifulSoup4 + lxml (HTML -> CSV) - How to write 3 Columns to MariaDB?

[BrandonKastning]

Yes, line 37 defines the function. Not sure what you mean by the last question. Remember that you need to define the function before it's called, so if your calls were before that line, then they need to be after.

ndc85430,

I have since changed the last line of my .py to calling the function:

insertVariablesIntoTable()

This then results in the following error:

Traceback (most recent call last):
File "HTML2CSV-NoWrite3Variables-to-MySQL.Python.Variable.Passoff.MySQL.INSERT.py", line 62, in <module>
insertVariablesIntoTable()
NameError: name 'insertVariablesIntoTable' is not defined

I then go back in the .py and change line 37 from:

def insertVariblesIntoTable(allTitle, allOpinion, allURL):

to: (which is now line 38 w/ commenting line 37 out)

def insertVariablesIntoTable():

Then re-run the .py and receive the following error:

Failed to insert into MySQL table Failed processing format-parameters; Python 'resultset' cannot be converted to a MySQL type
MySQL connection is closed

Perhaps we are getting somewhere with this!