Mailing list - Entries of 2006

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[qftestJUI] qfstest variable in SQL statement zxJDBC

  • Subject: [qftestJUI] qfstest variable in SQL statement zxJDBC
  • From: David_Downey@?.com
  • Date: Fri, 27 Oct 2006 09:02:54 -0400

I am trying to pass a qfstest local variable into an SQL statement.  I can't seem to get it to accept the value.  

cursor.execute("SELECT jdoidx FROM mpm_user_options WHERE useridx = $(userID)")

Jython doesn't see the variable as a value.  It seems to take it literally.  When I use the actual user id it works otherwise it doesn't.  

Traceback (innermost last):

  File "<console>", line 1, in ?

Error: ORA-00911: invalid character

David A. Downey
Software Quality Assurance Analyst
BD Technologies

constitute an advertisement of BD group's products or services or a
solicitation of interest in them. If this is such a message and
you would like to opt out of receiving future advertisements or
solicitations from this BD group, please forward this e-mail to the
This message (which includes any attachments) is intended only for
the designated recipient(s). It may contain confidential or
proprietary information and may be subject to attorney-client
privilege or other confidentiality protections. If you are not a
designated recipient, you may not review, use, copy or distribute
this message. If you received this in error, please notify the
sender by reply e-mail and delete this message. Thank You
Corporate Headquarters Mailing Address: BD (Becton, Dickinson and
Company) 1 Becton Drive Franklin Lakes, NJ 07417 U.S.A.