Re: [python-win32] Apache & mod_python & win32com

2008-04-24 Thread Robert Brewer
inally approach works. Ask again if you need to. > I guess you thinking of some > standard python modules (as there's probably a python module for > everything =))? :) Yup, there is a Queue module: http://docs.python.org/lib/module-Queue.html. Robert Brewer [EMAIL PROTECTED]

Re: [python-win32] Apache & mod_python & win32com

2008-04-24 Thread Robert Brewer
Uninitialize() If for various reasons that can't be made to work (some components just aren't thread safe), another option would be to run all the COM calls in a single thread and use a Queue; request threads would call q.put(xml, reqid) and block, the COM thread would call q.get(), do the work, and shove the result into results[reqid]. Robert Brewer [EMAIL PROTECTED] ___ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] PyTime

2007-05-08 Thread Robert Brewer
I spent far too many hours trying to extract them back from float(d) [1]. Yet another lesson in the dangers of multiple documentation locations. Ah well, at least I learned something about Jet and SQL server internals. Robert Brewer System Architect Amor Ministries [EMAIL PROTECTED] [1] http://pro

Re: [python-win32] Running CherryPy inside IIS

2007-05-01 Thread Robert Brewer
sn't have nearly that level of testing (even though I wrote asp_gateway). I don't recommend it unless you have the time to debug the interaction between various versions of IIS, ASP, pywin32, and Python. Robert Brewer System Architect Amor Ministries [EMAIL PROTECTED] _

Re: [python-win32] MS Access: silent overflow failure

2007-03-27 Thread Robert Brewer
Mark Hammond wrote: > Robert Brewer wrote: > > The small demo script below makes ADO calls to a Microsoft > > Access (Jet) > > database via win32com. But it fails in a potentially dangerous way; > > "SELECT int * int;" can return None with no warning if the

[python-win32] MS Access: silent overflow failure

2007-03-22 Thread Robert Brewer
s a column reference. The same SQL run as a Query inside the Access GUI works as expected. Manually changing one of the ints to a Single by appending ".0" works as expected. Any ideas about where I need to look next to find the cause of, and then fix, this behavior? Robert Brewer S

Re: [python-win32] Python help for Access database

2006-07-31 Thread Robert Brewer
MS Access Dates are best input using the #date# syntax. Here's an example to convert a datetime.datetime object to that format: return ('#%s/%s/%s %02d:%02d:%02d#' % (value.month, value.day, value.year, value.hour, value.minute, value.second)) Should be easy e

Re: [python-win32] Runnin Python app as service with separate console

2006-04-05 Thread Robert Brewer
n32serviceutil.ServiceFramework" to get some sample code. Cut-n-paste should get you there. On the "separate console" front, I've given up on local, desktop-based solutions and now use a web-based terminal I wrote for use with CherryPy: http://projects.amor.org/misc/wiki/HTTPREPL

Re: [python-win32] NT Service not re-startable after reboot

2006-03-16 Thread Robert Brewer
- Traceback (most recent call last): File "C:\Python24\Lib\site-packages\win32\test\test_win32pipe.py", line 37, in testCallNamedPipe win32file.WriteFile(pipeHandle, "bar\0foo") error: (109, 'WriteFile', 'The pipe has been ended.') ------

[python-win32] NT Service not re-startable after reboot

2006-03-16 Thread Robert Brewer
insert hooks to return an error code more-meaningful than "1" in the future. Robert Brewer System Architect Amor Ministries [EMAIL PROTECTED] ___ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] MS Access query error

2006-03-13 Thread Robert Brewer
eed to set Cursorlocation before calling Recordcount. Google for more info. adUseClient = 3 rs.Cursorlocation = adUseClient Robert Brewer System Architect Amor Ministries [EMAIL PROTECTED] ___ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] Using win32com Constants

2006-02-17 Thread Robert Brewer
ly be available after the w=win32com.client.Dispatch("Word.Application") statement." Robert Brewer System Architect Amor Ministries [EMAIL PROTECTED] ___ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] import and asp-python and iis - strange behaviour

2005-06-06 Thread Robert Brewer
had some issues in the past with "import myfile", and I find "from mypackage import mfile" to be more reliable. Sorry; I don't have any hard data on that at the moment--lost in the mists of history. But everything I import in .asp files sits in my site-packages folder any

Re: [python-win32] IIS CGI installation

2005-06-04 Thread Robert Brewer
ISAPI + WSGI: http://isapi-wsgi.python-hosting.com/ or ASP: http://www.4guysfromrolla.com/webtech/082201-1.shtml or (my preferred method) ASP + WSGI: http://www.amorhq.net/blogs/index.php/fumanchu/2005/05/26/wsgi_gateway_f or_asp_microsoft_iis If you used the latter, you could use CherryPy and be

RE: [python-win32] Dr. Watson woes with ADO, mysql

2005-01-10 Thread Robert Brewer
peculation on speculation. > Personally I would get a debug build running, so a decent > stack-trace is available, but I understand that may not be an option. ...for which I'd need vc++, right? IIRC, I'd need at least version 7? Would "Visual Studio .NET Professional Edition

[python-win32] Dr. Watson woes with ADO, mysql

2005-01-10 Thread Robert Brewer
(if I'm reading MSDN correctly) is therefore the function "where the fault occurred". So the question is, what's the next step in tracking down the bug? PyComplex_AsCComplex is a pretty simple function. Or am I way off-base and should be looking elsewhere? Robert Bre