Hi,
On Oct 13, 2:16 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> 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.
I saw that, but thought it was something else for some reason. Anyway,
I set up a function to convert all my numeric stuff into floats and it
works now. Thanks...talking it out seemed to help!
Mike
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
