getting user input and store in database (python)

Question

I am new to python and i am trying to write a script which will accept inputs from user and that will be stored in the SQL server database. But i don't know the appropriate method to do that. I have tried this but it is not working and throwing an error.

Also i want to take date input, how to do that.

    import pyodbc
    from datetime import datetime

 class data:
           def __init__(self):
                   self.name=raw_input( "Enter Name: ")
                   self.section=raw_input( "Enter section: ")
    ##               eon=raw_input( "Enter date : ")
    ##               feon=datetime.strptime( eon,'%Y, %m, %d')

    a=data()
    cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=KIRAN-PC;DATABASE=testing')
    cursor = cnxn.cursor()
    cursor.execute("Insert into Students (Name,Section,Enrol_On) Values (a.name,a.section,'2013-01-01')")
    cnxn.commit()

Output:

Enter Name: adam
Enter section: A

Traceback (most recent call last):
  File "C:/Python33/data1", line 14, in <module>
    cursor.execute("Insert into Students (Name,Section,Enrol_On) Values (a.name,a.section,'2013-01-01')")
ProgrammingError: ('42000', '[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "a.name" could not be bound. (4104) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier "a.section" could not be bound. (4104)')
>>>

anon582847382 · Accepted Answer · 2014-11-01 18:42:11Z

1

It's better if you use question marks whilst using parameters. You might use it like this:

cursor.execute("Insert into Students (Name,Section,Enrol_On) Values (?,?,"2013-01-01")",(a.name,a.section))

EDIT: You should check here for a simple example about inserting data.

edited Nov 1, 2014 at 18:42

anon582847382

20.5k5 gold badges58 silver badges60 bronze badges

answered Mar 8, 2014 at 13:13

Lafexlos

7,7555 gold badges41 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting user input and store in database (python)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related