- Zope - Zope lists

insert_id with MySQL an Z SQL Method
by Ferhat Ayaz 01 Sep '06

01 Sep '06

Hi, I have a Z SQL Method with an insert expression. To the inserted row will be assigned an auto_increment id. How can I get the last inserted id? I tryed the following both commands in one Z SQL method. Unfortunatly this produces an error. insert into categories (parent_id,logo,active) values ( <dtml-sqlvar parent_id type="int">, <dtml-sqlvar logo type="string">, <dtml-sqlvar active type="int">, ); SELECT currval('table_id_seq'); Thanks for your helps Greets, Ferhat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 3

How can I import python script into another python script?
by Ferhat Ayaz 01 Sep '06

01 Sep '06

Hi, I have a Script (Python) called 'functions'. I want to import this script into another Script (Python). import Include.Functions.requests says import of "Include.Functions.requests" is unauthorized Where am I wrong? Thanks, Ferhat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

3 3

Parameter generating an exception?
by Tit-Liviu Leontin 01 Sep '06

01 Sep '06

Hi everyone, I'm using Zope with OpenFlow for a workflow. The problem I'm encountering now seems to be entirely related to Zope; actually, a particular value for a parameter generates the error, so I'm guessing there's something wrong with the data, not the script. There's a "browse" file defined in the workflow, with the following first lines: <html><body> <html> <body tal:define="results here/Catalog; qq request/QUERY_STRING; qs python:container.stripStart(qq); start request/start|python:0; batch python:modules['ZTUtils'].Batch(results, size=20, start=start); previous python:batch.previous; next python:batch.next"> Now, if I call this script with no parameters in the URL, it shows all documents. If I append a ?issuer=john.d parameter to the URL, only documents issued by john.d will be displayed. This works even for fictive names, displaying a blank table as a result. However, for a particular user (and only that one), I'm getting this error: Error Type: TALESError Error Value: exceptions.KeyError on -1882874846 in "<PythonExpr modules['ZTUtils'].Batch(results, size=20, start=start)>", at line 3, column 3 In the page source, this is the detailed debug information:  Unfortunately, all this is worse than Chinese to me. Any clue where the error may be, and what to do to fix it, please? Many thanks in advance! Titel

5 11

DTML -> ZPT
by Antonio Beamud Montero 31 Aug '06

31 Aug '06

Is this the equivalence? <dtml-var day fmt=%02i> <td tal:replace="python:'%02i'%item['day']> or exists other way? Greetings.

3 2

Re: [Zope] Change the encoding of a single ZPT page
by Luiz Fernando Bernardes Ribeiro 31 Aug '06

31 Aug '06

2006/8/29, Andreas Jung <lists(a)zopyx.com>: > > > > --On 29. August 2006 12:28:30 -0300 Luiz Fernando Bernardes Ribeiro > <luiz.fernando.ribeiro(a)gmail.com> wrote: > > > Hello all, > > > > Is it possible to change the encoding of a page without having to change > > > the > > default-zpublisher-encoding option in zope.conf? > > > > My default encoding is iso8859-1 but we have to generate some XML files > > to a > > flash app, but flash only accept utf-8. > > If you edit your ZPTs through the ZMI you might set the > manage_page_charset > to utf-8. If the content-type of your ZPT is set to text/xml then the > ZPublisher should auto-detect the encoding from the XML preamble. The > setting in zope.conf is just a fallback (at least in Zope 2.9+). > > -aj > > After trying a lot of things, I found the problem is really in the zpublisher realm, no matter what kind of encoding trick I use, even with a python script, the output is converted to the default encoding if I use any variable or dynamic value from the database. Changing the 'default-zpublisher-encoding' setting solved the problem but I would have to convert hundreds of iso8859-1 html pages... I have already recoded the XML inside a Python script where I think it will be easier to use any magic zope trick... so I'm asking a way to avoid changing zope.conf to produce this simgle xml file... Python script test.xml: request = container.REQUEST xml = [ ] xml.append('<?xml version="1.0" encoding="utf-8"?>') xml.append('<lista xmlns:metal="http://xml.zope.org/namespaces/metal" xmlns:tal="http://xml.zope.org/namespaces/tal">') xml.append('<item palavra="%s" id="%s" />' % (container.sqlPalavras(ID=id)[0].Apelido, id)) xml.append('</lista>') print unicode("\n".join(xml), 'iso8859-1') return printed I'm using Zope 2.9. Thanks in advance for your help and time, -- Luiz Fernando B. Ribeiro

4 4

accelerating Zope restart
by egf05＠doc.ic.ac.uk 31 Aug '06

31 Aug '06

Hi, My Data.fs is huge (21GB) because it contains many video files. This is not a problem in itself, however, I recently had to reboot my machine and now zope takes around 20-30 minutes to restart. Is a fstest automatically done ? How could I accelerate the restarting, if possible ? Thanks a lot for any advice, Eric

6 8

Accessing MsSQL from Zope blocks
by robert rottermann 31 Aug '06

31 Aug '06

Hi there, this is not really an Zope Questions, I just hope somebody of you cold give me a hint. I already asked egenix (as we are using mxODBC) they could not think of a good reason. (but said to try a comercial odbc bridge). thanks for any pointers. robert using mxOdbc our database application embeded in zope often blocks when executing a simple statement as the following: query = "select fieldValue from tblATicketDetailDynamicForm \ where ticketDetailNoFk in (1683)" calling sql_q_nil(query) (from the following class) sometimes just never returns. The problem seems to be, that after a certain amount of queries MsSQL is in a state, that it does not allow any access to the querried database. what we do in our application is: - get a RedDbQuery object (class at the end of the posting) - execute the statement with RedDbQuery.sql_q_nil(query) - release the connection. this approach worked fine using MySQL. However we did not cross any OS bounderies and did not use ODBC. we are using: mxODBC Zope DA 1.0.8 License Information: 1 Zope Instance License for redcor <robert(a)redcor.ch> [6522021#1] SuSE 9.3 UnixOdbc 2.8.8 freetds 0.64 class RedDbQuery: "All queries are routed through this class." def __init__( self ): self._connection = getConnection() #print 'getConnection() returns', _connection self._cursor = self._connection.cursor() #print 'cursor() returns', _cursor def dispose( self ): releaseConnection( self._connection, self._cursor ) def cursor( self ): return self._cursor # # query level zero -- the one and only query execution method: # def sql_q_nil( self, query, verbose = None ): "Generic SQL query, expecting no return." if verbose: print( query ) r = self._cursor.execute( query ) #print 'execute() returns', r return r more methods ..

1 0

LocalFS cut and paste across LocalFS instaces
by Dennis Allison 31 Aug '06

31 Aug '06

I have a zope system (Zope 2.9.2) that needs to be able to cut and paste between different instances of LocalFS. Specifically, I have two LocalFS instances, LFS1 and LFS2. The two local files systems are disjoint and image different parts of the local file directory tree. What I need to be able to do is to cut and paste files and directories fom one instance to the other. The clipboard object appears to be missing adequate contest to cut and paste across instances. Has anyone modified the LocalFS product to handle, say, cutting a a file from LFS1 and pasting it into LFS2? --

1 0

Packing Data.fs
by Mark Gibson 31 Aug '06

31 Aug '06

I know zope makes a copy of Data.fs before packing. Is it possible to specify a location other than <zope>/var to place that copy? Mark

6 6

python expression in tal:attributes
by Ferhat Ayaz 30 Aug '06

30 Aug '06

Hi, I have a question. I really don't know how to solve this problem. I have <ul> <li tal:define="links python:{ 'Catalog/index.html':'Catalog', 'Users/index.html':'Users', 'Orders/index.html':'Orders'}" tal:repeat="item links/items"> <a href="" tal:attributes= "href string:${container/absolute_url}/${python:item[0]}" tal:content="python:item[1]">link name</a> </li> </ul> this is _of course_ not working because of ${python:item[0]}. It's illegal. But with this expression I want to show what I want to do: I want to add a python expression to a string. How can I do this??? Thanks, Ferhat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

4 8