On Oct 13, 2008, at 3:13 PM, Mike wrote:

> ProgrammingError: (ProgrammingError) ('42000', '[42000] [Microsoft]
> [ODBC SQL Server Driver][SQL Server]Error converting data type varchar
> to numeric. (8114) (SQLExecDirectW)') u'INSERT INTO [tbl_TimeEntries]
> (dateworked, empid, reg, ot, ce, hol, sklv, vac, ct, conv, misc,
> comments) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' [u'12/25/2007',
> '299', '', None, None, '6.5', None, None, None, None, None, None]

the Nones are fine, its hosing out on your usage of '299' and/or '6.5'  
for numeric values, when you're passing strings.


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to