- Zope - Zope lists

ZSQL insert: None, '' and null behaviour
by Matt Goodall 11 Nov '01

11 Nov '01

Hi, Can anyone give me a good reason why an object with value None, used to insert data into a database inserts the text string 'None' rather than a NULL value? It seems to me that None is pretty much equivalent to SQL's NULL. I found an excellent document, http://www.zope.org/Members/jshell/ZSQLMethods-InsertingData, which explains how to get things to work (use type=nb and optional in the sqlvar tag) but it doesn't work for values of None, only empty strings. I am now going to "fix" all the code I have but I would love to understand why I need to (in my opinion) code around this. If it makes any difference I'm using Red Hat Linux 7.2, Python 2.1.1, Zope 2.4.2, PostgreSQL 7.1.3 and psycopg from CVS. I get the same behaviour on FreeBSD, Python 2.1.1, PostgreSQL 7.0.3 and psycopg 0.99.7 (IIRC). Thanks, Matt

1 0

installing a .diff file
by Greg Conway 11 Nov '01

11 Nov '01

Hi all, Can anybody please point me in the direction of instructions for applying a .diff patch? I have a couple of plugins I want to have a play with but they need these patches to run, and since I've been bashing my head against this one for the past week or so, I thought it was time to ask for help! Any suggestions gratefully received! Regards, Greg Conway. -- ================================== Greg Conway Technical Director GML Networking Technologies Email/MSN: greg(a)gmlnt.com ICQ#: 100219981 mobile tel.: +44 (0) 7974 666 967 mobile fax: +44 (0) 7970 087 935 Internet: http://www.gmlnt.com office tel.: +44 (0) 1255 672 103 office fax: +44 (0) 1255 679 909 ================================== *********************************************************************** This is a confidential communication between sender and addressee. If you are not the intended recipient of this message, please notify the sender and do not read, copy, use or disclose this communication to others. Any opinions or views expressed are those of the individual, and unless otherwise stated, are not those of the company. All attachments and intellectual rights remain the property of GML (NT) Limited. ***********************************************************************

2 1

SnS e-Daily - Hong Kong, Mon, Nov 12, 2001 - Building Bridges for 20000 e-Professionals Worldwide... 24 x 7!
by SnS_team＠sweet-n-sour.com 11 Nov '01

11 Nov '01

To: zope(a)zope.org SnS e-Daily is a free ezine sent to over 20000 e-Professionals worldwide. It provides ground zero reporting from major cities on the latest hot news in e-commerce, upcoming events, exclusive member discounts...and much, much more! To join, please: mailto:members@s-n-s.com Welcome to SnS e-Daily - Hong Kong, Mon, Nov 12, 2001 ///////////////////////////////////////////////////////////////////////////////////////////////////////////// Please click at the link below for today's edition http://standard.sweet-n-sour.com/edaily_11122001.htm <A HREF="http://standard.sweet-n-sour.com/edaily_11122001.htm"> AOL users click here</a> Back up copy of today's edition http://www.hi-tech.com.hk/edaily_11122001.htm <A HREF="http://www.hi-tech.com.hk/edaily_11122001.htm"> AOL users click here</a> \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ In Today's Edition:- 1. Hong Kong - legal seminar, chinese dance, chinese opera, fine dining, financial training masterclass, christmas ball 2. Singapore - e-seminar, business seminar, info session 3. Evanston, IL, USA - career nights 4. New York, NY, USA - beaujolis party 5. London, England - lecture Editor's Note:- If you would like to receive our SnS e-Daily in html format, please email us at customerservice(a)s-n-s.com. Thank you for your continuing support. Sincerely, the SnS Team Please visit our web site www.s-n-s.com to learn more about us. To request advertising rates, please mailto:b2b@s-n-s.com To subscribe to SnS e-Daily, please mailto:members@s-n-s.com To submit improvement ideas, please mailto:feedback@s-n-s.com For other inquiries, please mailto:customerservice@s-n-s.com 1997 - 2001 Hi-Tech Development Co., Ltd. All rights reserved. --- This email was sent to: zope(a)zope.org To stop receiving our SnS e-Daily, please reply to leave-hk11-142464S(a)cooldude.sweet-n-sour.com with a blank email. Thank you.

1 0

wtf, Getting MySQL working for Zope is a tramatic experience, I think I need therapy
by Jacob Singh 11 Nov '01

11 Nov '01

So here is what I have tried: I installed the Python-MySQLDB mod, but was using an old version of python, then I upgraded python and re-installed it. then I banged my head against the wall trying to figure out how to use my python executable and not Zope's. Finnally figured that out (basically undocumented) So then ZMySQLdb showed up as functional but gave the following message and restarted the server whenever I tried to use it: WARNING: Python C API version mismatch for module _mysql: This Python has API version 1010, module _mysql has version 1007. I have no idea what this means, so I tried making a symlink between a directory in my lib/python and lib/python2.1 directories to the directory containing the Python-MySQLdb .so file and using the Zope provided interpreter (to no avail). It can't find the module. I think one of my problems may also lie in that I don't know how to uninstall the old python, I didn't really upgrade, I just installed the new one and overwrote the python executable, with the new one, I know this probably wasn't too smooth, but this is a learning process. NEway, any help would be GREATLY appreciated. And if any Zope Dev's are reading this. PLEASE make MySQL and PostGRES connectivity standard with any Zope installation. Thank you Jacob Singh

1 0

Gadfly
by Ben Ocean 11 Nov '01

11 Nov '01

Hi; I'm implementing a product called zCommerce for the development of a simple shopping cart. The author (who is probably enjoying the weekend and not checking his email) recommends using Gadfly for the backend db and I've followed his advice. However, I can't figure out how to get the data out of Gadfly! If I were in MySQL, I'd run show databases and then show tables to figure out what was going on. But I don't even know how to get *into* Gadfly. What do? TIA, BenO

2 2

login methods
by miah34＠msn.com 11 Nov '01

11 Nov '01

Hi everybody. I've asked some questions in the past about login methods and the answers I got were pretty confusing / over my head. So I've taken some time here to research this and want to see if I've got this down and then I have a couple more specific questions. Okay, so we have the following: 1. Basic HTTP authentication 2. Cookie authentication 3. URL rewriting with something like Cookieless Session. I imagine you could use a session variable like UserID taken from a user database? I don't know if this is a typical authentication method and I've just started looking into this. So I'm still learning about this, but my understanding is as follows. 1. Basic HTTP authentication is out if you want a customized login page. 2. I get mixed reactions to cookies - some people turn off cookies, etc. So maybe this isn't a great authentication method. Which would bring me to option 3. At this point, I don't have a specific problem/solution in mind, I'm just trying to learn about this so I have the appropriate tools in hand when I need them. So, finally, my questions: 1. Is there a way to do authentication without the use of cookies and without url rewriting? 2. How does Zope.org authenticate it's users? I've noticed that I can log in as more than one user at the same time from a single computer. I don't see a URL rewrite and I didn't think cookie authentication allowed you to do that. I'm not sure if that is clear, so here's an example of what I mean: I created a practice site using mysqlUserFolder and cookie authentication. If I login to that site and then open up a new browser window and go to that same site, it shows me as being logged in already. Zope.org doesn't do this. Thanks again everybody. -Jeremiah

2 1

I Got the Concatenation Blues
by Ben Ocean 11 Nov '01

11 Nov '01

Hi; I've built a site with inline frames. Each page has one inline frame that bears the same name as the page calling it with the tag *_frame*. I want to code into my template a way to call the dtml document and render it within a noframes tag in the calling document. I have created a Python method called concatFrame.py: import string def concatFrame(str): frame = string.join(str,'_frame') return frame I'm trying to call it thusly: <dtml-var "concatFrame(title_or_id())"> It ain't working. What do I need to do? TIA, BenO

2 1

Re: [Zope] I Got the Concatenation Blues
by Danny William Adair 11 Nov '01

11 Nov '01

On Sunday 11 November 2001 16:12, Ben Ocean wrote: > Hi; > I've built a site with inline frames. Each page has one inline frame that > bears the same name as the page calling it with the tag *_frame*. I want to > code into my template a way to call the dtml document and render it within > a noframes tag in the calling document. I have created a Python method > called concatFrame.py: > > import string > > def concatFrame(str): > frame = string.join(str,'_frame') > return frame > > I'm trying to call it thusly: > > <dtml-var "concatFrame(title_or_id())"> > > It ain't working. What do I need to do? 1.) "title_or_id()" returns a string. 2.) "concatFrame(a_string)" returns another string 3.) <dtml-var "this_new_string_which_actually_is_an_id"> will probably return your document html quoted :-o Try <dtml-var "_[this_new_string_which_actually_is_an_id]"> to render your document So it's: <dtml-var "_[concatFrame(title_or_id())]"> hth, Danny

2 1

Zope 2.4.2 crashes, and crashes... help is needed!
by BZ 11 Nov '01

11 Nov '01

Ok, so my crashing problem has not gone away. I updated from 2.3.2 -> 2.4.2 about a week ago and since then Zope has been crashing every 15 minutes or so! Since it is a set of live sites I thought to try another one sitting by itself and yes, it runs for hours. Here is the very consistant output in the debug mode (get this over and over and over again) ++++++++++++++++++ [root@server1 bluewildfire]# WARNING: Python C API version mismatch for module _imaging: This Python has API version 1010, module _imaging has version 1007. /usr/local/zope/bluewildfire/lib/python/SearchIndex/__init__.py:91: DeprecationWarning: The usage of the SearchIndex package is deprecated since Zope 2.4. This package is only kept for backwards compatibility for a while and will go away in a future release. Please use instead the re-factored modules in Products/PluginIndexes. warnings.warn("The usage of the SearchIndex package is deprecated since \ WARNING: Python C API version mismatch for module _imaging: This Python has API version 1010, module _imaging has version 1007. /usr/local/zope/bluewildfire/lib/python/SearchIndex/__init__.py:91: DeprecationWarning: The usage of the SearchIndex package is deprecated since Zope 2.4. This package is only kept for backwards compatibility for a while and will go away in a future release. Please use instead the re-factored modules in Products/PluginIndexes. warnings.warn("The usage of the SearchIndex package is deprecated since \ ++++++++++++++++ I did remove the Imaging (but not the products) and that one warning went away but it still crashes. I have also run it with a -M to a log file and it really does not produce anything useful. There seems to be no pattern accept crashing. Any, help, at all... would be great. Thanks, BZ

1 0

Concatenation
by Ben Ocean 11 Nov '01

11 Nov '01

Hi; I'm trying to concatenate a <dtml-var> with a string. I have this poor attempt: <dtml-var expr="_.string(title_or_id.'_frame')(_,_.None)"> where *title_or_id* is (of course) the <dtml-var> and *_frame* is the string. How should I do this? TIA, BenO

4 4