Access Problem
John Yeager
webbmaster2001 at directvinternet.com
Tue Dec 25 01:20:14 EST 2001
Useing the following code to access a Access Database, I run into a problem
getting the Database to Autonumber the primary key
Here is my code what am I missing
import time
import odbc
Time = time.ctime(time.time())
connection = odbc.odbc('Everquest')
cur = connection.cursor()
sql = "Insert into Member VALUES( '(Autonumber goes here )','test',
'test','NULL','p','R300478','Testuser','Test','%s')" % ( Time )
cur.execute( sql )
connection.commit()
cur.close()
connection.close()
So what am I doing wrrong here?
More information about the Python-list
mailing list