[mod_python] Re: error while inserting data

Inserting variables of type string into other strings goes like this:

name = "John"
formatted_string = "your name is: %s" % name

or with more variables:

name = "John"
age = "13"
formatted_string = "your name is: %s and your age is: %s" % ( name, age )

Thus you should have:

cursor.execute("INSERT INTO PERSONALDETAILS
(firstname,middlename,lastname) VALUES (%s, %s, %s)" %
(fname,mname,lname) )

Note the % sign.