-
Jeremy:
I am no SQL expert, but for the queries we have to do here, we have to use single quotes for the string constants in the "WHERE" clause. Does it work any better if you change that last clause to read:
... AND from_Name = 'TC7: Misc Materials for Motor Assembly'"
that is, put the 'TC7...Assembly' value in single, rather than double, quotes. I know our database...
2009-06-10 19:52:00 UTC in Simple MS SQL Python extension module
-
Sorry about that ... I don't know how to make the indenting come out correctly. All of the lines in that last post should have been formatted correctly, but apparently the posting compressed sequences of spaces to a single space. Sorry.
Eric.
2009-05-21 20:43:04 UTC in Simple MS SQL Python extension module
-
Actually I was following the example:
<tt>
>>> import pymssql
>>> con=pymssql.connect(host='.',user='sa',password='xxx',as_dict='True')
>>> cur=con.cursor()
>>> cur.execute('select getdate() as curd')
>>> for row in cur:
... print `row`
...
('Pentagon', '<username>', 'Public')
...
>>>
The problem...
2009-05-21 20:41:20 UTC in Simple MS SQL Python extension module
-
I am a new (as of today) user of pymssql, and I just downloaded and installed it today (version 1.0.2). Everything seems to be working, except that setting "as_dict=True" in the connect() method does nothing; the results are still returned as a tuple. The "fetchall_asdict()" method does return a dictionary. I notice that the patch shown above specifies a new argument named...
2009-05-21 20:11:58 UTC in Simple MS SQL Python extension module
