Christer Fernstrom wrote:
Hello,
I have a very simple Z SQL method that works fine when I test run it. But
when I call it from a Python script (see below) and attempt to print the
result, I get the following error:
Error Type: TypeError
Error Value: cannot concatenate 'str' and 'ImplicitAcquirerWra
Answer below
Infor Gates wrote:
Hello Zopist
I am new and try to learn python script with ZSQL in
Zope. I have read the Zope Book. However, most of them
are in DTML and very few on python script. I have a
little knowledge on Zope and SQL but am lost in trying
to see the whole picture of zope/python
Martin Jennings wrote:
Firstly, thank you to those who answered by query on the empty result set,
it set me on the way to finding a solution.
Not sure if this is the right list to ask on, but here is the question.
I have got information from a ZSQL request in a result set and I want to
use one of t
Watch out if you need to use fields longer than 4000 characters - Oracle
CLOBs return handles rather than contents, as in MySQL Text fields for
example. So you need extra coding in your presentation later. Also,
watch out for Database X returning result.FieldName whilst Database Y
returns resul
Umashankar Rao wrote:
But how to define my database connection parameters like
username/passwd and SID?
You need an entry in tnsnames.ora that looks like this:
YOURID =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = address.of.your.server)(PORT =
))
)
(CO
Don't know what the equivalent for Windows is, but on *ix you can start
Zope in the foreground and see what the startup sequence messages have
to say. Also, try looking in the logs. If Zope fails to start there
should be an error report somewhere.
Cliff
David wrote:
Hi,
so I also tried Mysql be