2 replies to this topic

[williamevanl]

I've been programming in jython using a certain driver and to access a certain position in a query I just use .getString(3)

So if I'm querying three things like name, address, phone number its very easy to:
name = myqueryresults.getString(1)

but now I'm using a cursor and the zxJDBC driver in eclipse and I absolutely can not figure out how to get this same functionality.
Say I want:

myquery.execute(Select name, address, phone number from blahblah)
name = "what the crap goes here!?"


Thanks!
-Will

[wim DC]

How about:

Quote

__findattr__

public PyObject __findattr__(java.lang.String name)
Gets the value of the attribute name.
Overrides:
__findattr__ in class PyObject
Parameters:
name -
Returns:
the attribute for the given name
See Also:
PyObject.__findattr__(PyString)

PyCursor (Jython API documentation))

[williamevanl]

pfth, just figured it out, simply myquery.fetchone()[2]


that [2] is what I was looking for...