Re: unixODBC SQLSEVER OUPUT issue
akm <[email protected]>
| Newsgroups | gmane.comp.python.egenix.user |
|---|---|
| Message-ID | <[email protected]> |
On Tue, Apr 21, 2009 at 4:50 PM, Charlie Clark <[email protected]> wrote: > Am 21.04.2009, 12:57 Uhr, schrieb akm <[email protected]>: > >>>>> conn.execute(query_insert2, data) >>>>> print conn.fetchone() >> Traceback (most recent call last): >> File "<stdin>", line 1, in <module> >> mx.ODBC.Error.ProgrammingError: missing result set > > It's an insert statement. Why should it have any results? OUTPUT is A SQL Server 2005 feature that helps in returning the actual data from a table soon after an insert. Applications require return values such as the new identity value, the computed column value or the default value generated by the default constraint. > > Charlie > -- > Charlie Clark > eGenix.com > > Professional Python Services directly from the Source >>>> Python/Zope Consulting and Support ... http://www.egenix.com/ >>>> mxODBC.Zope.Database.Adapter ... http://zope.egenix.com/ >>>> mxODBC, mxDateTime, mxTextTools ... http://python.egenix.com/ > ________________________________________________________________________ > > ::: Try our new mxODBC.Connect Python Database Interface for free ! :::: > > > eGenix.com Software, Skills and Services GmbH Pastor-Loeh-Str.48 > D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg > Registered at Amtsgericht Duesseldorf: HRB 46611 > http://www.egenix.com/company/contact/ > _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users