I did get an exception, that's how I knew to change the type!
On 12/10/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
>
>
> On Dec 10, 2007, at 12:47 PM, Rick Morrison wrote:
>
> > This works here on MSSQL/pymssql with a small change:
> >
> > -- j = Job("TEST1", datetime.datetime.now())
> >
> > ++ j = Job(1, datetime.datetime.now())
> >
> > MSSQL (and most other db engines) are going to enforce type on the
> > 'identifier' column. In the new code, it's an int, so...no strings
> > allowed. The original example user "uniqueidentifier", which is a
> > rather odd duck, and I'm not sure would support an arbitrary string
> > as a key. Unless you need real GUID keys for some reason, I would
> > suggest using a normal string or int surrogate key like the new
> > example does.
> >
> how come no exception is thrown ? silent failure is the party pooper.
>
>
>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
