🌐 Mailman 3 July 2007 - Python-list - python.org

(no subject)
by Roddy July 29, 2007

July 29, 2007

1 0

Re: Understanding mxODBC Insert Error
by Harrie Geerts July 29, 2007

July 29, 2007

"Greg Corradini" <gregcorradini(a)gmail.com> schreef in bericht news:mailman.1310.1185727301.22759.python-list@python.org... > > Hello, > I'm trying to perform a simple insert statement into a table called > Parcel_Test (see code below). Yet, I get an error message that I've never > seen before (see traceback below). I've tried to put a semicolon at the > end > of the sql statement, but with no luck. Any ideas from more experienced > mx.ODBC users? > > CODE >>>> driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+workspace #here a >>>> ; #!!!!!!!!!! >>>> conn = odbc.DriverConnect(driv) >>>> crs = conn.cursor() >>>> sql = "INSERT into Parcel_Test(NEAR_FID,NEAR_DIST) values >>>> ('0.000000','0.000000') where PIN_ID = '042822120008'" >>>> crs.execute(sql) > > TRACEBACK > Traceback (most recent call last): > File "<pyshell#1>", line 1, in ? > crs.execute(sql) > ProgrammingError: ('37000', -3516, '[Microsoft][ODBC Microsoft Access > Driver] Missing semicolon (;) at end of SQL statement.', 4612) > > > -- > View this message in context: > http://www.nabble.com/Understanding-mxODBC-Insert-Error-tf4166125.html#a118… > Sent from the Python - python-list mailing list archive at Nabble.com. >

1 0

Understanding mxODBC Insert Error
by Greg Corradini July 29, 2007

July 29, 2007

Hello, I'm trying to perform a simple insert statement into a table called Parcel_Test (see code below). Yet, I get an error message that I've never seen before (see traceback below). I've tried to put a semicolon at the end of the sql statement, but with no luck. Any ideas from more experienced mx.ODBC users? CODE >>> driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+workspace >>> conn = odbc.DriverConnect(driv) >>> crs = conn.cursor() >>> sql = "INSERT into Parcel_Test(NEAR_FID,NEAR_DIST) values >>> ('0.000000','0.000000') where PIN_ID = '042822120008'" >>> crs.execute(sql) TRACEBACK Traceback (most recent call last): File "<pyshell#1>", line 1, in ? crs.execute(sql) ProgrammingError: ('37000', -3516, '[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement.', 4612) -- View this message in context: http://www.nabble.com/Understanding-mxODBC-Insert-Error-tf4166125.html#a118… Sent from the Python - python-list mailing list archive at Nabble.com.

1 0

Re: Split a string based on change of character
by attn.steven.kuo＠gmail.com July 29, 2007

July 29, 2007

On Jul 28, 11:36 pm, Andrew Savige <ajsav...(a)yahoo.com.au> wrote: (snipped) > > Yes. Here's a simpler example without any backreferences: > > s = re.split(r'(?<=\d)(?=\D)', '1B2D3') > > That works in Perl but not in Python. > Is it that "chaining" assertions together like this is not supported in Python > re? > Or is that the case only in the split function? > The match objects returned by finditer return the expected span positions: >>> pat = re.compile(r'(?<=\d)(?=\D)') >>> s = '1B2D3' >>> for mobj in pat.finditer(s): ... print mobj.span() ... (1, 1) (3, 3) >From your original post: >>> pat = re.compile(r'(?<=(.))(?!\1)') >>> s = 'ABBBCC' >>> for mobj in pat.finditer(s): ... print mobj.span() ... (1, 1) (4, 4) (6, 6) So, it seems split doesn't split on what amounts to a zero-width assertion. I couldn't find this explanation from a quick look at the documentation, however. -- Hope this helps, Steven

1 0

Python 2.5.1 can't find win32file?
by samwyse July 29, 2007

July 29, 2007

I just upgraded from 2.4.something to 2.5.1. I get the stuff below. I tried easy-installing pywin32; same results. Anyone know what's going on? Python 2.5.1 (r251:54863, Apr 18 2007, 08:51:08) [MSC v.1310 32 bit (Intel)] on win32 Type "copyright", "credits" or "license()" for more information. **************************************************************** Personal firewall software may warn about the connection IDLE makes to its subprocess using this computer's internal loopback interface. This connection is not visible on any external interface and no data is sent to or received from the Internet. **************************************************************** IDLE 1.2.1 ==== No Subprocess ==== >>> import win32file Traceback (most recent call last): File "<pyshell#0>", line 1, in <module> import win32file ImportError: DLL load failed: The specified module could not be found. >>> import sys >>> sys.path ['C:\\Documents and Settings\\dentos\\Desktop\\scripting', 'C:\ \Python25\\Lib\\idlelib', 'C:\\Python25\\lib\\site-packages\ \setuptools-0.6c6-py2.5.egg', 'C:\\Python25\\lib\\site-packages\ \sqlalchemy-0.3.10-py2.5.egg', 'C:\\Python25\\lib\\site-packages\ \pil-1.1.6-py2.5-win32.egg', 'C:\\Python25\\lib\\site-packages\ \epydoc-3.0beta1-py2.5-win32.egg', 'C:\\Python25\\lib\\site-packages\ \pywin32-210-py2.5-win32.egg', 'C:\\WINNT\\system32\\python25.zip', 'C: \\Python25\\DLLs', 'C:\\Python25\\lib', 'C:\\Python25\\lib\\plat-win', 'C:\\Python25\\lib\\lib-tk', 'C:\\Python25', 'C:\\Python25\\lib\\site- packages']

3 3

interpreter in the background
by Andrea Tomadin July 29, 2007

July 29, 2007

Hi, I need to use the Python interpreter as if it were a Matlab or Mathematica "kernel", i.e. running in the background while I use an interface program to send commands and get output. Ideally, I would pipe some text "to" the interpreter (through a fifo, a socket...?) and got all the output back to the calling program, or appended to a text file, etc. Say: # cat pythonInput.txt 1 + 1 # cat pythonInput.txt | myInterface > pythonOutput.txt # cat pythonOutput.txt 2 or similar. Note that I need the *same* interpreter to run between consecutive calls of myInterface, to preserve the memory stack. Moreover, if I run a python script in the background, and not the bare interpreter, an input error could force the termination of the program, while I want the background "kernel" to keep up running. At first I thought it was a trivial task, just change default input and output instead of tty, but I could not find out a solution! Any help or hint is greatly appreciated! Best, Andrea

2 1

Re: Python 2.5.1 can't find win32file?
by samwyse July 29, 2007

July 29, 2007

On Jul 28, 12:14 pm, Jay Loden <pyt...(a)jayloden.com> wrote: > samwyse wrote: > > Interestingly enough, this works: > > > C:\Python25>path=%path%;C:\Python25\Lib\site-packages\pywin32-210- > > py2.5-win32.eg > > g\pywin32_system32 > > > C:\Python25>python > > Python 2.5.1 (r251:54863, Apr 18 2007, 08:51:08) [MSC v.1310 32 bit > > (Intel)] on win32 > > Type "help", "copyright", "credits" or "license" for more information. > >>>> import win32file > > > It looks like the system search path isn't getting updated so that > > PYWINTYPES25.DLL can be found when win32file.pyd is loaded. > > > Anyone have any ideas? > > If you just want to update your PATH, you can do that from My Computer -> Properties -> Advanced -> Environment Variables and just update PATH for your user (or all users if you prefer). > > -Jay Well, I was hoping for something a bit more general. I'd've thought that anyone loading a DLL would set the Windows path beforehand, and that it would all be magically taken care of during the installation. For now, I'm putting this before my 'import' statement: os.environ['PATH'] += r';C:\Python25\Lib\site-packages\pywin32-210- py2.5-win32.egg\pywin32_system32'

1 0

Compiling python2.5.1 results in 3.5MB python lib?
by simonbun July 29, 2007

July 29, 2007

Hi all, I'm compiling 2.5.1 and end up with a 3.5MB libpython2.5.so file. I seem to remember it should be somewhere around the 1MB mark. What could be causing this? I'm using ./configure --enable-shared This is a problem for me seeing as i'm using apache+mod_python to serve web content. Each apache child process incorporates libpython and ends up starting at 7MB, which is quite large. Especially considering the framework + code I'm using adds another 10+MB. Any help is appreciated. Let me know if i need to give some more information.

4 4

problem with change to exceptions
by Neal Becker July 29, 2007

July 29, 2007

import exceptions class nothing (exceptions.Exception): def __init__ (self, args=None): self.args = args if __name__ == "__main__": raise nothing Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/usr/tmp/python-3143hDH", line 5, in __init__ self.args = args TypeError: 'NoneType' object is not iterable I'll have to say, I don't understand this error.

3 4

Why Is This The Best Program Online ?
by adayattheoffice＠gmail.com July 29, 2007

July 29, 2007

If You Want To Make Money ..This Is What You Do. I Spent 2 Years Trying To Make Money And Thankfully Now I Am No Longer Trying ,I Am Actively Doing So. This Is What It Takes.. http://trakclix.com/ct/t.php?l=353

1 0