getting issue with insertion of data

mkleehammer / pyodbc

Python ODBC bridge

https://github.com/mkleehammer/pyodbc/wiki

MIT No Attribution

2.92k stars 561 forks source link

getting issue with insertion of data #1276

Closed taibarehm closed 1 year ago

taibarehm commented 1 year ago

Please first make sure you have looked at:

Documentation: https://github.com/mkleehammer/pyodbc/wiki
Other issues

Environment

To diagnose, we usually need to know the following, including version numbers. On Windows, be sure to specify 32-bit Python or 64-bit:

Python:
pyodbc:
OS:
DB:
driver:

Issue

Often it is easiest to describe your issue as "expected behavior" and "observed behavior".

taibarehm commented 1 year ago

5 cursor.execute(SQLCommand,i.timestamp,str(i.title),float(i.price),str(i.market),float(i.surface),str(i.location),str(i.remote_support),str(i.lighting),str(i.advertiser_type),str(i.description),int(i.no_of_rooms),str(i.form_of_property),str(i.url),str(i.is_for_sale),str(i.posting_id)) 6 connection.commit() 7 connection.close()

DataError: ('22003', '[22003] [Microsoft][ODBC SQL Server Driver]Numeric value out of range (0) (SQLExecDirectW)')

v-chojas commented 1 year ago

The information you were asked for when creating the issue is important, please fill it in.

gordthompson commented 1 year ago

Also, please provide a minimal reproducible example that shows your issue.