[web2py:17518] Re: DAL mssql DSN connection

[mdipierro]

I am putting this is but, as you say, probably db2/400 only.

On Mar 4, 4:29 pm, DenesL <denes1...@yahoo.ca> wrote:
> After a successful insert, either one of these will work:
>
> int(cursor.execute("select IDENTITY_VAL_LOCAL() from
> SYSIBM.SYSDUMMY1").fetchone()[0])
> int(cursor.execute("select IDENTITY_VAL_LOCAL() from
> SYSIBM.SYSDUMMY1").next()[0])
>
> the result before int() is <class 'decimal.Decimal'>
> Note that SYSIBM.SYSDUMMY1 is probably only good for db2/400.
>
> Thanks go to mkleehammer of pyodbc for his help on this.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---