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

2006-12-20 Thread Roger Upole

[EMAIL PROTECTED] 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/pythonwin32/chapter/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 =
-- 
http://mail.python.org/mailman/listinfo/python-list


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

2006-12-19 Thread cfriedalek
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/pythonwin32/chapter/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.

-- 
http://mail.python.org/mailman/listinfo/python-list


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

2006-12-19 Thread John Machin

[EMAIL PROTECTED] 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

-- 
http://mail.python.org/mailman/listinfo/python-list