Re: [Zope-DB] Retrieving Data from Z SQL in Python

2005-05-18 Thread Cliff Ford
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

Re: [Zope-DB] Python Script / ZSQL

2005-05-11 Thread Cliff Ford
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

Re: [Zope-DB] Creating a hyperlink using results from query

2005-04-08 Thread Cliff Ford
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

Re: [Zope-DB] Null characters & booleans

2005-04-08 Thread Cliff Ford
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

Re: [Zope-DB] Connection to Oracle DB

2005-04-05 Thread Cliff Ford
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

Re: [Zope-DB] Another problem with Zope-Mysql

2005-04-01 Thread Cliff Ford
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