Re: cx_Oracle question

2006-09-08 Thread Richard Schulman
Richard Schulman: >> cursor.execute("""select mean_eng_txt from mean >> where mean_id=:arg_1""",arg_1) Uwe Hoffman: >cursor.execute("""select mean_eng_txt from mean >where mean_id=:arg_1""",{"arg_1":arg_1}) R.S.'s error message: >> Traceback (most recent call

Re: cx_Oracle question

2006-09-08 Thread Diez B. Roggisch
> cursor.execute("""select mean_eng_txt from mean > where mean_id=:arg_1""",{"arg_1"=arg_1}) Needs quotes of course. Diez -- http://mail.python.org/mailman/listinfo/python-list

Re: cx_Oracle question

2006-09-08 Thread Diez B. Roggisch
Richard Schulman schrieb: > I'm having trouble getting started using Python's cx_Oracle binding to > Oracle XE. In forthcoming programs, I need to set variables within sql > statements based on values read in from flat files. But I don't seem > to be able to get even the following stripped-down tes

Re: cx_Oracle question

2006-09-08 Thread Uwe Hoffmann
Richard Schulman schrieb: > > cursor.execute("""select mean_eng_txt from mean > where mean_id=:arg_1""",arg_1) cursor.execute("""select mean_eng_txt from mean where mean_id=:arg_1""",{"arg_1":arg_1}) > Traceback (most recent call last): >File "oracle_te