- Zope - Zope lists

Qurying a TinyTable (plus)
by Philip Kilner 05 May '04

05 May '04

Hi List, Have developed a parameter driven process which is driven by a list of sets of parameters listed in a tiny table. Am trying to find the correct syntax to pull out a given column where the index is specified, in a python script. Can anyone give me a clue, or point to a fuller example than those in the TinyTable docs please? (Google doesn't have much to say on this - examples are all DTML, or driven by more than the requirement to pull a single value out!) -- Regards, PhilK Email: phil(a)xfr.co.uk / Voicemail & Facsimile: 07092 070518 "The lyf so short, the craft so long to learne" - Chaucer

3 5

Z-SQL crashes Zope -- mxODBC test works -- but Z-SQL test fails ... for data longer than ~140 characters ... (windows/interbase)
by Jason LeMonier 05 May '04

05 May '04

Hey, Using [eGenix mxODBC Database Connection at /db_bos] [Test] select * from t20_user_experience --> retrieves 2 rows -- 1 field has 200+ characters Z-SQL method using SAME db connection: /db_bos select uid from t20_user_experience (ok) select * from t20_user_experience --> python.exe - Application Error -- instruction at 0x... Ok to term, Cancel to Debug. Debug (Vis Studio): Runtime error -- abnormal program execution. Bottom Line: Z-SQL method crashes Zope when a field has 200+ characters in it! Progress: This problem started when I was trying to update fields w/ ~200+ characters using Z-SQL methods. I bypassed Z-SQL updates completely by running updates like this: def run_sql (sql, dsn): """ bypass z-sql ??? """ import mx.ODBC.Windows # Connect to the database (using iODBC) conn = mx.ODBC.Windows.DriverConnect('DSN=%s'%(dsn)) curs = conn.cursor() # Create a database cursor curs.execute(sql) # Execute a statement on the cursor conn.commit() curs.close() conn.close() # return "run_sql output: dsn=%s sql=%s "%(dsn,sql) return 1 Only to find the same data crashes zope upon reading the data into a resultset! I've been looking in: \python\Shared\DC\ZRDB at dbi_db.py and others to try and track down what code is running for Z-SQL. in dby_db.py --> def query(self,query_string, max_rows=9999999): return 'stop now!!' # This did NOT change anything!! what code is running??? Any help with: finding the code that runs to execute Z-SQL bypassing Z-SQL selects but still get the needed resultsets General tips on what may be happening would be so greatly appreciated!! ----------------------------------------------------------------------------- Environment: Plone 1.0.5, Zope 2.6.1, W2K Server, Interbase 6 -----------------------------------------------------------------------------

1 0

RE: [Zope] Can't run Zope remotely
by Takahashi, Michael 05 May '04

05 May '04

I have changed Apache's default port to 8080 and was able to reach the server remotely. So port 8080 is working. Also, I am not sitting behind a DHCP server, yet I still cannot get Zope to work remotely. Very frustrating... -----Original Message----- From: Wade Pearce [mailto:Wade.Pearce@dpac.tas.gov.au] Sent: Tuesday, May 04, 2004 4:05 PM To: MTakahashi(a)oid.ucla.edu; zope(a)zope.org Subject: RE: [Zope] Can't run Zope remotely If you're sitting behind a DHCP server with NAT forwarding, make sure the port is being forwarded correctly (ie. not only open the port on your firewall but the NAT mapping as well). >>> "Takahashi, Michael" <MTakahashi(a)oid.ucla.edu> 5/05/2004 10:00:55 am >>> Apache was used initially as a web server. Then I found Zope and decided to install it. Shouldn't I be able to access Zope remotely via http://mydomain.com:8080 <http://mydomain.com:8080> anyways since I can access it locally using http://localhost:8080 <http://localhost:8080> ? This is what I am having difficulty with. I will try changing Apache's default port to 8080 and try that. Any other suggestions are greatly appreciated! Thanks Mike -----Original Message----- From: Ausum Studio [mailto:ausum_studio@hotmail.com <mailto:ausum_studio@hotmail.com> ] Sent: Tuesday, May 04, 2004 3:56 PM To: zope(a)zope.org Subject: RE: [Zope] Can't run Zope remotely Insufficient information. What are you using Apache for? Should the answer be that is has nothing to see with Zope, and that it runs on port 80 its own stuff, then I would suspect on the port mapping at your firewall. To check it you use Apache. Change its default port to 8080, shutting down Zope for a while, and see what happens. If you are unable to reach your Apache server, then you have a net problem. Ausum >From: "Takahashi, Michael" <MTakahashi(a)oid.ucla.edu> >To: "'zope(a)zope.org'" <zope(a)zope.org> >Subject: [Zope] Can't run Zope remotely >Date: Tue, 4 May 2004 13:52:08 -0700 > >Hey guys, I am having a problem running Zope remotely. I can access Zope >locally using http://localhost:8080 <http://localhost:8080> <http://localhost:8080/ <http://localhost:8080/> > , but when I >try to access it from another computer (using http://mydomain.com:8080 <http://mydomain.com:8080> ), it >just hangs. I am running Zope 2.7 with Apache 2.0 and have setup my >firewall to accept port 8080. Apache runs fine...it's just Zope and! port >8080. Any help is greatly appreciated. > > > >Thanks! > > > >Mike > > > >_______________________________________________ >Zope maillist - Zope(a)zope.org >http://mail.zope.org/mailman/listinfo/zope <http://mail.zope.org/mailman/listinfo/zope> >** No cross posts or HTML encoding! ** >(Related lists - > http://mail.zope.org/mailman/listinfo/zope-announc! e <http://mail.zope.org/mailman/listinfo/zope-announce> > http://mail.zope.org/mailman/listinfo/zope-dev <http://mail.zope.org%0d%0a/mailman/listinfo/zope-dev> ) _________________________________________________________________ Watch LIVE baseball games on your computer with MLB.TV, included with MSN Premium! http://join.msn.com/?page=features/mlb <http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/dir ect/01/> &pgmarket=en-us/go/onm00200439ave/direct/01/ _______________________________________________ Zope maillist - Zope(a)zope.org http://mail.zope.org/mailman/listinfo/zope <http://mail.zope.org/mailman/listinfo/zope> ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce <http://mail.zope.org/mailman/listinfo/zope-announce> http://mail.zope.org/mailman/listinfo/zope-dev <http://mail.zope.org/mailman/listinfo/zope-dev> )

1 0

TinyTable plus (reprise)
by Philip Kilner 05 May '04

05 May '04

Hi List, Asked this last night, but none to coherently. I'm working on a set-up which essentially makes a variety of multi-page data-entry processes generic. I've got a /completely/ generic page template which nicely renders any formulator form we chuck at it, and handles errors etc., and the sequence of formulator forms is defined in a script, which fires each form in turn, accumulating the data in the session object until the a script performs the database write(s). So far, so good. The last step (until we have another bright idea! <g>) is to make the /controlling/ script generic (the final database handling stuff being inherently /not/ generic). The idea is to get to a point where non-technical business-level folk can prototype a non-trivial, linear data-capture process by creating formulator objects and defining the sequence in which they run, and the only "techie" bit is writing the script to handle the data. We have the forms nicely managed, so we just need a "manageable" data structure to define the sequence, and carry any additional attributes which we might use in the generic process. After a bit of casting about, I think TinyTablePlus should be just the job. I have two questions: - - Given the outline of what we are doing, is there a better way of doing it? - Is there a syntax we can use in the Python script to directly access a column by it's index. e.g. if our table reads: - "1", "TestCase" "2", "NutCase" "3", "HeadCase" ...I'd like to be able to say something like: - container.REQUEST.SESSION.set ('formulator_object', getattr(container.process_spec('1'), form_name)) ...where '1' is the index of the current step and 'form_name' is the column name where the name of our formulator form lives. I've searched high and low for an example of this, but have found nothing helpful. I'd be really grateful if someone could help me out here, because my notes of how I've got this far should be a big help to the next poor sap with my skill set who thinks that all this stuff should be easier to puzzle out, documented, or just plain easier... -- Regards, PhilK Email: phil(a)xfr.co.uk / Voicemail & Facsimile: 07092 070518 "The lyf so short, the craft so long to learne" - Chaucer

1 0

Having date format problems
by aleckz＠rapidreporting.com 05 May '04

05 May '04

Hello, When i open a request, and enter a certain date, it has the MM-DD fields mixed around, so its DD-MM, how can i flip these? thanks, alex

2 1

Put a Dtml page in a Plone's slot:main
by Shane McCombs 05 May '04

05 May '04

Hi Paul My name is Shane. I am Completely New to Zope and Plone (Sorry). I have my Plone Site Up and minor Customization complete, at this point I am wanting to Create a Plone Document that Returns the result of a SQL Query. I Simply can't figure out how to make this work, I feel like I must be missing the Obvious. I have a working Z SQL Method that returns as simple Query. From the ZMI the Test tab looks exactly as I would Expect, but how to translate into PLONE? I have 2 full days invested of trying to figure this out. I have found many How-to s but just cant get them to work for me. The Z Sql Method is located at /Plone/testodbc/testsqlmethod The Page Template is at /Plone/testodbc/allpcs I have been programming in various lang/scripts for 8 years... it is frustrating being a Newbie again... Any Help / Direction or Ideas would be wonderful. Thank you in advance - Shane Shane McCombs Innovation Developer Raymond Building Supply Corp. 239.478.6284

2 1

Pan European Portals Conference 2004 - Nottingham, UK
by Paul Browning 05 May '04

05 May '04

Apologies for multiple sightings. A reminder that all delegate bookings for this year's Pan European Portals Conference (PEPC) received before 7th May 2004 will qualify for a 10% discount on the conference package. (This does not apply to accommodation). The conference is being held at the University of Nottingham on the 18-20th July 2004. Booking can be made online at www.nottingham.ac.uk/pepc2004/ Paul -- The Library, Tyndall Avenue, Univ. of Bristol, Bristol, BS8 1TJ, UK E-mail: paul.browning(a)bris.ac.uk URL: http://www.bris.ac.uk/

1 0

Field Index PDF for Catalog
by Montenegro, Bosco 05 May '04

05 May '04

Hello again. I am trying to index the content of PDF files in Zcatalog, but at the moment I have only been able to index their titles or id. My question is, what attribute and what type of index should I use for this? Do I need to install some component, pluggin of some sort? Please help me. I am running Zope 2.6 (without CMF). Thank you. Bosco

2 1

Z MySQL database adapter
by Aaron 05 May '04

05 May '04

HI I am new to Zope and have been trying to set up a connection from Zope to my Mysql datatbase. Z MySQL database adapter asks that I have the _mysql extension installed. But I can't seem to get it to happen for me. I don't have root permissions on the webhost. Is there anyway for me to install _mysql? Thanks Aaron

4 5

Tool to create static mirror of a Zope site
by Stefan Bund 05 May '04

05 May '04

Hello Zopistas, I have written a script to create a static mirror of a Zope site. In reply to a question on this list, I have promised the poster to make this script publicly available. So here it is: Documentation is at <http://www.j32.de/j32/pages/service/tools/fetchsit/download/doc.txt> The script itself is at <http://www.j32.de/j32/pages/service/tools/fetchsit/download/fetchsite.py> I post these direct links because my homepage is in german. My homepage (http://www.j32.de/) has been created using the fetchsite tool. I have written this tool specifically to support Zope. I used to use wget for this task but soon got frustrated, because I often needed to patch the generated pages. Another problem for me was, that wget would create files with '?' in their filename. When uploading those files to a web server, they are not accessible (of course). So I wrote myself this tool to solve these problems once and for all. It will parse and find URL's in CSS and JavaScript code and OBJECT params. I would appreciate any feedback. The script has been tested on Linux (my computer) and Windows (my friends computer), but will certainly have many bugs. And the documentation could be better. So feel free to ask or post any comments, Stefan. -- -- *DON'T* TRY TO REACH ME DIRECTLY AT ABOVE EMAIL ADDRESS. Any reply -- received off-list at that address will be *silently* and -- *unconditionally* dropped. You can attribute this inconvenience to -- the proliferation of spammers on the Internet. I hope, you can -- understand my position and accept my counter measures.

1 0