July 2001 - Zope - Zope lists

RE: [Zope] ODBC, SQL,Zope, NT4 , Jshell
by Farrell, Troy 19 Jul '01

19 Jul '01

Errrrgh! I had this problem long ago and I don't remember how I solved it. Waaaaay back when I was still using Access. Hmmm. First, turn on ODBC debugging. For this, we need to examine the SQL.log file it creates. Look at that and we need to see if python can talk to Access over ODBC. Troy -----Original Message----- From: CURTIS David [mailto:David.Curtis@state.or.us] Sent: Thursday, July 19, 2001 4:00 PM To: troy.farrell(a)wcg.com Subject: RE: [Zope] ODBC, SQL,Zope, NT4 , Jshell Sensitivity: Personal >>> troy.farrell(a)wcg.com 07/19/01 12:54PM >>> what happens if you change to <dtml-sqlvar name="customer_id" type="nb">, <dtml-sqlvar name="name" type="nb">, <dtml-sqlvar name="planet" type="nb" optional>, <dtml-sqlvar name="age" type="int" optional> What is the error message? Is the traceback in the HTML source? Troy There was no data matching this Insert a Customer query. Thanks for the quick reply. Here is what I get displayed on the screen. There was no data matching this Insert a Customer query. ---------------------------------------------------------------------------- ---- SQL used: There was no data matching this Insert a Customer query. Insert into customers ( customer_id, name, planet, age ) VALUES ( 'QW32', 'John Smith', 'Earth', 15 ) But using single quotes in the TEST tab did allow for appending. So Maybe there is hope? :-) -----Original Message----- From: CURTIS David [mailto:David.Curtis@state.or.us] Sent: Thursday, July 19, 2001 1:43 PM To: Zope(a)zope.ORG Subject: [Zope] ODBC, SQL,Zope, NT4 , Jshell Sensitivity: Personal Hi, I am trying to append records into an access database from Zope ZSQL. I am using the tutorial Created by jshell that was Last modified on 2000/10/13. I have his setup and it appears to be working except for the problem that no records actually get put into database. I get no errors to help me either. I have tried to using the SQL syntax Insert into customers ( customer_id, name, planet, age ) VALUES ( <dtml-sqlvar customer_id type=nb>, <dtml-sqlvar name type=nb>, <dtml-sqlvar planet type=nb optional>, <dtml-sqlvar age type=int optional> ) If I "TEST" The database connection with a select statement I get records output. YEA If I TEST the datbase connection with a delete statement - records deleted. YEA BUT If I TEST the database connection with a insert statement I get an error. No Traceback. BAD Insert into customers (customer_id, name, planet, age) VALUES ("test", "test2", "test3", 77) Note this syntax is working in MS Access. The database connection is open. Current Setup Running NT 4 with Zope versions (Zope 2.3.2 (binary release, python 1.5.2, win32-x86) Python Version 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform win32 ODBC - Microsft Access Driver(*.mdb) version 4.00.5301.01 Any ideas on what to do? _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

'access' file
by Chris Withers 19 Jul '01

19 Jul '01

Hi, I've got a Zope instance where the username and password specified in the 'access' file don't give me access to the Zope instance. Can anyone suggest what might be the problem? cheers, Chris

5 11

ERROR 200 UnIndex unindex_object could not remove documentId -1856604212 from index review_state.
by Brad Clements 19 Jul '01

19 Jul '01

I'm getting this error from Zope 2.3.3 binary release on RH Linux 7 with CMF-1.1 Any ideas where I should start looking to fix? Brad Clements, bkc(a)murkworks.com (315)268-1000 http://www.murkworks.com (315)268-9812 Fax netmeeting: ils://ils.murkworks.com AOL-IM: BKClements

1 0

RE: [Zope] Web Based HTML Editor
by AJDENSTONE＠BKB.com 19 Jul '01

19 Jul '01

Hei Joachim, I use de DHTML Edit Control OCX from Micro$oft. Unhappyly this works only with IE 5.x, but it is tottaly customizable. I made a Zclass that work in my intranet. You can got here: http://discovirtual.uol.com.br/alex.denstone/Compartilhada/DHTML%20Edit.zip Alexandre Denstone ==================================================================== Joachim Schmitz wrote: I just found another commercial WEB-based HTML-editor at: http://www.realobjects.de Mit freundlichen Grüßen

3 2

Another lighter note...
by J. Cameron Cooper 19 Jul '01

19 Jul '01

I love this. How come this isn't anywhere on Zope.org? """ Some newer open source products are also becoming popular. The North Atlantic Treaty Organization uses one of those, Zope, for a tracking system that locates both NATO's and antagonists' troops, vehicles and ships around the world, said Tom Morling, vice president of marketing at Digital Creations, a systems consulting company and Zope's publisher. "The supreme commander of NATO has a Zope browser on his desk," he said. """ source: http://www.zdnet.com/zdnn/stories/news/0,4586,2717905,00.html How's that for "mission-critical"? The article does a lot of other Zope-mentioning besides. --jcc (haha)

3 2

News Product
by Marcus Schopen 19 Jul '01

19 Jul '01

Hi, we are looking for a product to display news in a way the www.zope.org Site does on its first page. We doent't use CMF. Thank you Marcus -- _____________________________________ (0> Marcus Schopen //\ P.O. Box 10 25 25 V_/_ 33525 Bielefeld, Germany ICQ#120991527 _____________________________________ Live as variously as possible

2 1

recursive folder listing
by wazum-mail (wolfgang) 19 Jul '01

19 Jul '01

hiya! I can't solve this problem ... hmmm .. I need a menu in a select list with all folders listed that have an attribute called "in_the_list" (boolean, 1) this dtml method ("list_values") is called from another dtml method and calls itself recursively: <dtml-in "objectValues (['Folder'])" skip_unauthorized> <dtml-if "_.hasattr(_['sequence-item'], 'in_the_list')"> <option value="<dtml-var "absolute_url()">"><dtml-var title_or_id> <dtml-with sequence-item only> <dtml-var list_values> </dtml-with> </dtml-if> </dtml-in> but this doesn't work ... I think this is an aquisition problem (?) but I'm not able to solve it ... your help is highly appreciated! thx & tia Wolfgang ----------------------------------- wazum-mail ;-) (wolfgang(a)wazum.com) url ( http://www.wazum.com/ )

2 1

how to install win32com?
by seb bacon 19 Jul '01

19 Jul '01

Hi all, I need to get my Zope on win32 to be able to use the win32com module, but unfortunately have almost no understanding whatsoever of the windows platform. I've tried installing ActiveState python 2.1 and getting it to work with zope - no joy. I've tried installing the win32all package for python 1.5, but the stupid installer just says "you don't have python 1.5 installed on your computer". Arrgghhh!! Can anyone RTFM me in the right direction? I don't have a clue what I'm doing :-) thanks, seb

3 5

RE: [Zope] ODBC, SQL,Zope, NT4 , Jshell
by Farrell, Troy 19 Jul '01

19 Jul '01

what happens if you change to <dtml-sqlvar name="customer_id" type="nb">, <dtml-sqlvar name="name" type="nb">, <dtml-sqlvar name="planet" type="nb" optional>, <dtml-sqlvar name="age" type="int" optional> What is the error message? Is the traceback in the HTML source? Troy -----Original Message----- From: CURTIS David [mailto:David.Curtis@state.or.us] Sent: Thursday, July 19, 2001 1:43 PM To: Zope(a)zope.ORG Subject: [Zope] ODBC, SQL,Zope, NT4 , Jshell Sensitivity: Personal Hi, I am trying to append records into an access database from Zope ZSQL. I am using the tutorial Created by jshell that was Last modified on 2000/10/13. I have his setup and it appears to be working except for the problem that no records actually get put into database. I get no errors to help me either. I have tried to using the SQL syntax Insert into customers ( customer_id, name, planet, age ) VALUES ( <dtml-sqlvar customer_id type=nb>, <dtml-sqlvar name type=nb>, <dtml-sqlvar planet type=nb optional>, <dtml-sqlvar age type=int optional> ) If I "TEST" The database connection with a select statement I get records output. YEA If I TEST the datbase connection with a delete statement - records deleted. YEA BUT If I TEST the database connection with a insert statement I get an error. No Traceback. BAD Insert into customers (customer_id, name, planet, age) VALUES ("test", "test2", "test3", 77) Note this syntax is working in MS Access. The database connection is open. Current Setup Running NT 4 with Zope versions (Zope 2.3.2 (binary release, python 1.5.2, win32-x86) Python Version 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] System Platform win32 ODBC - Microsft Access Driver(*.mdb) version 4.00.5301.01 Any ideas on what to do? _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0

RE: [Zope] News Product
by Farrell, Troy 19 Jul '01

19 Jul '01

see http://www.zope.org/Members/kedai/index_html http://www.zope.org/Members/kedai/index_html/view_source Troy -----Original Message----- From: Marcus Schopen [mailto:marcus.schopen@uni-bielefeld.de] Sent: Thursday, July 19, 2001 9:22 AM To: zope(a)zope.org Subject: [Zope] News Product Hi, we are looking for a product to display news in a way the www.zope.org Site does on its first page. We doent't use CMF. Thank you Marcus -- _____________________________________ (0> Marcus Schopen //\ P.O. Box 10 25 25 V_/_ 33525 Bielefeld, Germany ICQ#120991527 _____________________________________ Live as variously as possible _______________________________________________ Zope maillist - Zope(a)zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

1 0