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

Solved: SQL2000 database vs python, using mssqldb and Pyro
by Raaijmakers, Vincent (IndSys, GE Interlogix) July 31, 2003

July 31, 2003

Problem solved!! Forgot to put the owner in front of the table name. so: vincent.my_table instead of my_table. Thanks guys! -----Original Message----- From: Raaijmakers, Vincent (IndSys, GE Interlogix) Sent: Thursday, July 31, 2003 2:47 PM To: python-list(a)python.org Subject: SQL2000 database vs python, using mssqldb First of all, thanks for all the help guys! Until now, lots of install problems on all the recommended packages/modules. For now, my best option was to make use of my existing Pyro framework (thanks Irmen!) I already build a MSSQL (Pyro/server)service on the windows box using mssqldb. My linux app will talk to this service. This at least has been installed successful and my service can already connect to the database. So far so good: Now, I can't find the API of MSSQL. Not on the website nor in the installed folders. So, I tried to use the examples and only the connections seems successful. When I try a select on a table, it tells me that the table name is an invalid object name. Just tried a kind of a hello world example... import mssqldb import MSSQL db = MSSQL.connect('my_db_server', 'user', 'password', 'my_database') ## so far, so good c = db.cursor() c.execute('select * from my_table') ## boom, error c.fetchall() c.nextset() The ms sql enterprise manager shows me that the database and table is there. Unfortunately, in python the error tells me: Invalid object name 'my_table' Anyone with experience? Where are the API's? Vincent -- http://mail.python.org/mailman/listinfo/python-list

1 0

Re: [Newbie] FAQ?
by Christopher Koppler July 31, 2003

July 31, 2003

On Thu, 31 Jul 2003 13:58:55 -0500, Skip Montanaro <skip(a)pobox.com> wrote: > > Simone>is there a FAQ for this NG? > > Christopher> http://www.faqs.org/faqs/by-newsgroup/comp/comp.lang.python.html > Christopher> Have you heard of Google? > > Simone> sure I did! Pardon... > >Don't apologize too profusely. The dates on the two FAQs listed there (one >for c.l.py and one for c.l.py.announce) are 1996 and 1999, respectively. >The c.l.py FAQ probably is going to be all that useful unless you're a >Python historian. > You're right, I was a bit too fast there... Also in hindsight I sounded a bit rough there, which wasn't my intention. --Christopher

1 0

Re: RELEASED Python 2.3 (final)
by aahz＠pythoncraft.com July 31, 2003

July 31, 2003

In article <c76ff6fc.0307301323.62f3ccd6(a)posting.google.com>, John Machin <sjmachin(a)lexicon.net> wrote: > >So ... could we please change that to "much kudos"? Nope. Kudos is a mass noun, but it's a discrete mass noun. So you need to say "many kudos". This bit of pedantry is brought to you by "much kudo about nothing". -- Aahz (aahz(a)pythoncraft.com) <*> http://www.pythoncraft.com/ This is Python. We don't care much about theory, except where it intersects with useful practice. --Aahz

11 13

Controlling a spawned process
by isaac＠blueapples.org July 31, 2003

July 31, 2003

I want to start a console application on a Windows 2000 machine and control it's I/O. pexpect is exactly what I want, but it doesn't work on Windows. Does anyone know of another module similar to pexpect that does work on windows?

1 0

[Newbie] FAQ?
by psycho_78＠libero.libero.it July 31, 2003

July 31, 2003

hi all, is there a FAQ for this NG? TIA, Simone -- questo articolo e` stato inviato via web dal servizio gratuito http://www.newsland.it/news segnala gli abusi ad abuse(a)newsland.it

3 4

SQL2000 database vs python, using mssqldb
by Raaijmakers, Vincent (IndSys, GE Interlogix) July 31, 2003

July 31, 2003

First of all, thanks for all the help guys! Until now, lots of install problems on all the recommended packages/modules. For now, my best option was to make use of my existing Pyro framework (thanks Irmen!) I already build a MSSQL (Pyro/server)service on the windows box using mssqldb. My linux app will talk to this service. This at least has been installed successful and my service can already connect to the database. So far so good: Now, I can't find the API of MSSQL. Not on the website nor in the installed folders. So, I tried to use the examples and only the connections seems successful. When I try a select on a table, it tells me that the table name is an invalid object name. Just tried a kind of a hello world example... import mssqldb import MSSQL db = MSSQL.connect('my_db_server', 'user', 'password', 'my_database') ## so far, so good c = db.cursor() c.execute('select * from my_table') ## boom, error c.fetchall() c.nextset() The ms sql enterprise manager shows me that the database and table is there. Unfortunately, in python the error tells me: Invalid object name 'my_table' Anyone with experience? Where are the API's? Vincent

1 0

Re: Unfortunate exception on dict item assignment (and why aren't slices hashable?)
by aahz＠pythoncraft.com July 31, 2003

July 31, 2003

In article <mailman.1059566448.27346.python-list(a)python.org>, Jeff Epler <jepler(a)unpythonic.net> wrote: >On Tue, Jul 29, 2003 at 07:29:19PM +0100, Marc Wilson wrote: >> In comp.lang.python, aahz(a)pythoncraft.com (Aahz) (Aahz) wrote in >> <bg5vg6$2d2$1(a)panix1.panix.com>:: >> >> |Fair enough. Note carefully that I said "submit a patch" -- that >> |doesn't guarantee that the patch will be accepted, and it's quite likely >> |that it won't be. But "submit a patch" is usually a good way to get >> |people to shut up. ;-) >> >> Shame it doesn't work in *all* newsgroups, eh? > >I'll have you know that I've submitted a number of Python patches that >were clearly bad ideas. In fact, I'm a little hurt that Aahz doesn't >think of me as "that guy who often posts or submits horrible patches >and won't shut up". I'm not sufficiently involved with the actual development process to hold such an opinion. ;-) (Despite my regular comments on python-dev, I don't contribute code because SF refuses to make changes to allow Lynx to work correctly.) -- Aahz (aahz(a)pythoncraft.com) <*> http://www.pythoncraft.com/ This is Python. We don't care much about theory, except where it intersects with useful practice. --Aahz

3 2

RE: RELEASED Python 2.3 (final)
by sismex01＠hebmex.com July 31, 2003

July 31, 2003

> From: Brian Quinlan [mailto:brian@sweetapp.com] > Sent: Jueves, 31 de Julio de 2003 12:17 p.m. > > > Seems nice enough. You'll only be able to assign to a > > mutable object anyway; > > This statement doesn't make any sense. Assignment to None is a name > binding operating is mutability is not a relevant issue. > > > None is not mutable, and will soon be a keyword. > > None becoming a keyword is a valid reason. > > Cheers, > Brian > Nope; it has to do with making Python faster: if constants such as None, True, False are treated as true constants, then certain optimizations can be enabled with help make it all a bit quicker. So, in order to do so, assignment to builtins is being disallowed; or, only to such singleton instances... I'm not too sure anymore. Anyway, there's a thread in comp.lang.dev about all this. HTH -gustavo Advertencia:La informacion contenida en este mensaje es confidencial y restringida, por lo tanto esta destinada unicamente para el uso de la persona arriba indicada, se le notifica que esta prohibida la difusion de este mensaje. Si ha recibido este mensaje por error, o si hay problemas en la transmision, favor de comunicarse con el remitente. Gracias.

1 0

curses newwin
by mis6＠pitt.edu July 31, 2003

July 31, 2003

I have just performed this experiment with curses: from curses import * maxwidth=79 maxheight=21 def wait4q(stdscr): scr=stdscr scr.addstr("Press 'q' to exit\n") x,y,=0,0 while True: c=scr.getch() if c==KEY_LEFT and x > 0: x-=1; scr.move(y,x) elif c==KEY_RIGHT and x < maxwidth: x+=1; scr.move(y,x) elif c==KEY_UP and y > 0: y-=1; scr.move(y,x) elif c==KEY_DOWN and y < maxheight: y+=1; scr.move(y,x) elif c==ord('q'): break if __name__=='__main__': wrapper(wait4q) It works fine and one can move the cursor on the screen. The question is: why that does not work for a generic window different from stdscr? i.e. if I replace the line ``scr=stdscr`` with ``scr=newwin(0,0)``I don't see the cursor moving anymore. The 'q' is still recognized, however. I tried with some refresh(), but didn't work. What I am missing? TIA, Michele

1 0

Re: keystroke check
by mis6＠pitt.edu July 31, 2003

July 31, 2003

Wes Fraser <ugly_411(a)yahoo.com> wrote in message news:<mailman.1059619004.15764.python-list(a)python.org>... > Is there any way to check in a loop to see if at that > given moment in the program, a key on the key board is > being pressed without actually stopping like raw_ipnut > does? > > Thanks! > > Wes > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com On Unix/Linux you could use curses: import curses def wait4q(stdscr): stdscr.addstr("Press 'q' to exit\n") while True: if stdscr.getch()==ord('q'): break if __name__=='__main__': curses.wrapper(wait4q) However, curses could be overkill and it is not portable to Windows, AFAIK. The curses how-to suggest the console module, http://effbot.org/zone/console-index.htm which runs on Windows only. HTH, Michele

1 0