Bit == Boolean for MS-SQL, so use True/False. I have tested bit fields with pymssql inserts/updates/deletes and they work fine. If you're using adodbapi, perhaps someone else on the list can try a quick test, as I don't have a working adodbapi setup right now.
Rick On 2/15/07, metaperl <[EMAIL PROTECTED]> wrote: > > > In my MS SQL 2005 database schema, the field "RRates" is a bit field. > I have tried to supply False, both as a string and a Python boolean > and neither seems to create an acceptable SQL insert statement. > > dat = dict( > RRates = 0, # 0, "0", False, "False" all dont work > ) > > > ke_contracts.insert().execute(dat) > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---