469,339 Members | 8,437 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,339 developers. It's quick & easy.

tricky(?) win32com question - Mark Hammond or other experts please.

OK, I've asked this earlier this week with no response. Since then I've
also received a suggestion from the app developers but that failed with
the same type error problem. Hopefully Mark Hammond or other experts
can offer a suggestion as to how to get around this problem. I'm
foolish enough to think that a solution can be found. Or can someone
suggest how to pm Mark.

---------------------------

I'm using pywin32com to drive a 3rd party app. The app has a VBS based
API. In VBS a specific query for data goes like this:

Plot.QueryBegin datacode, Nothing

where datacode is a number and Nothing is a VBS type/keyword

The nominal python equivalent doesn't work. Plot.QueryBegin(datacode,
None) gives a type mismatch error as follows: com_error: (-2147352571,
'Type mismatch.', None, 2)
>From what I've been able to discover Nothing is not a null, 0, False,
""

Table 12.2 of
http://www.oreilly.com/catalog/pytho...pter/ch12.html does not
mention Nothing in its list of Variant types.

Please, any clues about how to handle this (apart from running the
query in VBS). I so much more prefer python.

Dec 20 '06 #1
2 1582

cf********@gmail.com wrote:
OK, I've asked this earlier this week with no response. Since then I've
also received a suggestion from the app developers but that failed with
the same type error problem. Hopefully Mark Hammond or other experts
can offer a suggestion as to how to get around this problem. I'm
foolish enough to think that a solution can be found. Or can someone
suggest how to pm Mark.
What is "pm"? You could email him directly, or ask your question on the
pywin32 mailing list, or raise a bug/feature request on sourceforge --
he not only reads those, he actions them :-)
>
---------------------------

I'm using pywin32com to drive a 3rd party app. The app has a VBS based
API. In VBS a specific query for data goes like this:

Plot.QueryBegin datacode, Nothing

where datacode is a number and Nothing is a VBS type/keyword

The nominal python equivalent doesn't work. Plot.QueryBegin(datacode,
None) gives a type mismatch error as follows: com_error: (-2147352571,
'Type mismatch.', None, 2)
From what I've been able to discover Nothing is not a null, 0, False,
""
Have you tried
Plot.QueryBegin(datacode)
?

Cheers,
None

Dec 20 '06 #2

cf********@gmail.com wrote
OK, I've asked this earlier this week with no response. Since then I've
also received a suggestion from the app developers but that failed with
the same type error problem. Hopefully Mark Hammond or other experts
can offer a suggestion as to how to get around this problem. I'm
foolish enough to think that a solution can be found. Or can someone
suggest how to pm Mark.

---------------------------

I'm using pywin32com to drive a 3rd party app. The app has a VBS based
API. In VBS a specific query for data goes like this:

Plot.QueryBegin datacode, Nothing

where datacode is a number and Nothing is a VBS type/keyword

The nominal python equivalent doesn't work. Plot.QueryBegin(datacode,
None) gives a type mismatch error as follows: com_error: (-2147352571,
'Type mismatch.', None, 2)
>>From what I've been able to discover Nothing is not a null, 0, False,
""

Table 12.2 of
http://www.oreilly.com/catalog/pytho...pter/ch12.html does not
mention Nothing in its list of Variant types.

Please, any clues about how to handle this (apart from running the
query in VBS). I so much more prefer python.
Try either pythoncom.Missing, pythoncom.Empty, or pythoncom.ArgNotFound.

Roger

----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Dec 20 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

25 posts views Thread by PyPK | last post: by
20 posts views Thread by Mohanasundaram | last post: by
28 posts views Thread by birensubudhi | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.