[Zope-DB] (ODBC) "Exception: invalid value 2.00 for company id" - but it can't be 2.00, it's an INT field... ?

[M.-A. Lemburg]

Simon Bayling wrote:
> Hello,
> 
> I'm using the Z ODBC product to read from a SQL Server database.
> Testing the connection, I can read individual fields that are set as
> VARCHARs.
> 
> I can't run (select *) or (select [company id]) which is defined as INT,
> Primary key, autoincrement, no-nulls, because it raises a ValueError: 
> 
> Error Value: Invalid value, 2.00[],for company id in record 1
>                                              ^square box like a weird
> ASCII character
> 
> How can it be getting 2.00 from an int field?
> 
> Any help would be much appreciated,

Have you tried the alternative mxODBC Zope DA ?

http://www.egenix.com/files/python/mxODBC-Zope-DA.html

> Cheers,
> Simon Bayling
> 
> 
> --- Traceback ---
> Traceback (innermost last):
>   Module ZPublisher.Publish, line 98, in publish
>   Module ZPublisher.mapply, line 88, in mapply
>   Module ZPublisher.Publish, line 39, in call_object
>   Module Shared.DC.ZRDB.Connection, line 132, in manage_test
>   Module DocumentTemplate.DT_String, line 474, in __call__
>   Module DocumentTemplate.DT_In, line 586, in renderwb
>   Module Shared.DC.ZRDB.RDB, line 200, in __getitem__
> ValueError: Invalid value, 2.00, for company id in record 1
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Software directly from the Source  (#1, Oct 13 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::