October 2000 - Zope - Zope lists

date off by one day per year cummulative
by Jonathan Cheyne 22 Oct '00

22 Oct '00

Hi all, Zope 2.2.0, displaying a date property from a zclass has been out by one day for a while, trick was just to +1 to the dtml. THought this was fine til dates into 2001 needed to go on and hey, they become one day too far now ... so now I need to add code to determine the year before adding or not. Not good. Quite grim, actually. It only happens when you use the fmt="xyz" to reformat the dates into UK dd/mm/yy (from the default yy/mm/dd). Should I just work around for now, or is this likely to remain like this for a while. If so then zope gets mildly unusable outside the USA. cheers Jonathan

2 1

Re: [Zope] Help needed with news articles
by Bak ＠ kedai 22 Oct '00

22 Oct '00

try kmnetnews from zope.org/Products or you can use dtml document to construct a simple news item. <untested code by newbie> <dtml-in "objectItems(['DTML Document'])" size=4 reverse sort=bobobase_modification_time> <dtml-var title>(and other stuff/properties) </dtml-in> </untested> the above code should be in a DTML Method -----Original Message----- From: Taco Scargo <taco(a)scargo.nl> To: zope(a)zope.org <zope(a)zope.org> Date: Sunday, October 22, 2000 5:23 AM Subject: [Zope] Help needed with news articles >Unfortunately nobody responded, so I am reposting this question again. I >just need a link to an example or explanation. > >Basically I want to create a page listing the last 4 articles from a Zope >folder. The articles need a publish from/to field, title and (dtml) text. I >somehow need to be able to find and display the article from another dtml >document. I read many FAQs and tried working with zcatalogs, but somehow I >am not getting there. It is probably not so difficult. If there is somebody >how can help me or give me a link to a clear explanation or example I would >be very very grateful. Thanks ! > >Taco > > >_______________________________________________ >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

Help needed with news articles
by Taco Scargo 22 Oct '00

22 Oct '00

Unfortunately nobody responded, so I am reposting this question again. I just need a link to an example or explanation. Basically I want to create a page listing the last 4 articles from a Zope folder. The articles need a publish from/to field, title and (dtml) text. I somehow need to be able to find and display the article from another dtml document. I read many FAQs and tried working with zcatalogs, but somehow I am not getting there. It is probably not so difficult. If there is somebody how can help me or give me a link to a clear explanation or example I would be very very grateful. Thanks ! Taco

3 2

RE: [Zope] Problems with mysql and sql methode
by Farrell, Troy 22 Oct '00

22 Oct '00

You may try: SELECT pyname, pyprice FROM payment WHERE merchantpayment.meid = 418 AND merchantpayment.pyid = payment.pyid I have a feeling mysql is not liking you for not selecting results from table MERCHANTPAYMENT becuase you said you would. Troy -----Original Message----- From: Jens Grewen [mailto:zope@grewen.de] Sent: Friday, October 20, 2000 11:04 AM To: Zope Maillist Subject: [Zope] Problems with mysql and sql methode Hi, I have a problem with an SQL Methode with the this sql statement select PAYMENT.PYNAME, PAYMENT.PYPRICE from MERCHANTPAYMENT, PAYMENT where MERCHANTPAYMENT.MEID = 418 and MERCHANTPAYMENT.PYID = PAYMENT.PYID on the following tables: MERCHANTPAYMENT --------------------------------- MPID int(30) MEID int(30) PYID int(30) --------------------------------- PAYMENT --------------------------------- PYID int(30) PYNAME varchar(50) PYPRICE varchar(50) --------------------------------- the statement runs under MS ACCESS (link over myODBC) and I get the correct resut but under zope sql methode I get no result. (There was no data matching) Any ideas Jens Grewen

3 2

Request for donation of site. Linux Router Project
by Dave Cinege 22 Oct '00

22 Oct '00

I'm lead dev for the Linux Router Project. (LRP is a powerful thin-server OS that taks up less then 2MB of boot space) As you can see http://www.linuxrouter.org/ is not exactly what you would call an amazing site. I've played with zope a little bit and really like it, but I lack both the time to learn zope, and any general artistic ability. : > The project has become quite large and yet we lack a 'professional' web pressence, as well as disorganized documentation. I'd like to see the LRP site 'zopified' with a portal flare. Some thing that would really have is devs (and users) being able to build up a FAQ's and docs online. The more extensive the better, but I'd be happy if someone stepped forward with something 'nice'. (IE basic zopification plus a touch up on graphics) Any person/company willing to take on this endeavor will recieve a plug on the LRP sponsors page if they so desire. Hey it may even look good on resume. Please mail me personally if you're interested. Dave

1 0

Multiple queries in a ZSQL method?
by Noah 21 Oct '00

21 Oct '00

Hi, I'm using MySQL. I need to have a ZSQL Method that does an insert and a select in one call. After I do an insert I need to check the LAST_INSERT_ID to get the primary key of the record that I just inserted. Something like this: insert into author (id, name, sort_name, email, bio, initials) values (null, <dtml-sqlvar name type=nb>, <dtml-sqlvar sort_name type=nb>, <dtml-sqlvar email type=nb>, <dtml-sqlvar bio type=nb>, <dtml-sqlvar initials type=nb>); select LAST_INSERT_ID(); If I put this into two different methods then I'm afraid that I will have some threading problems due to the fact that another client might come in and do an insert using the database connection I was using. LAST_INSERT_ID is safe as long as you have an unshared connection. Zope does connection pooling, so I worry that using two separate ZSQL Methods may not always work. And WILL NOT work if Zope gives me a different connection for the second ZSQL call. Is there a better way to do this? Yours, Noah

3 2

Strings, Names and dtml-var
by swallace＠trilobyte.net 21 Oct '00

21 Oct '00

Ok, Being fairly new at Zope, I am really confused, I think I have looked through all the FAQs, How to's, examples, and what ever, but I still can not get the right combination to get this to work (many combinations tried :-)...). The basic intent is to easily change a property "color_source" in a directory that will cause the "color1" property to be looked up from a different directory. The directory name "default" could be one of many that holds different color themes. Thanks in advance. ***************************Code This does not work: get_color method <dtml-let myname="'Colors.'+color_source+'.color1'"> <dtml-var expr="_[myname]"> </dtml-let> This works: <dtml-var "Colors.default.color1"> which renders #FFFFFF ***************************Key get_color = a method, /Business/Base/get_color color_selection = a property in the current directory containing the string "default" without quotes Colors = a folder, /Business/Colors default = a folder, /Business/Colors/default color1 = is a property under default containing the string "#FFFFFF" without quotes Zope = 2.2.2 OS = Win98 ***************************Error Message Error Type: KeyError Error Value: Colors.default.color1 Troubleshooting Suggestions This resource may be trying to reference a nonexistent object or variable Colors.default.color1. The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error.

2 1

Acquisitive
by Spicklemire, Jerry 21 Oct '00

21 Oct '00

Hi Zope Fans, I ran into an odd quirk today, and I'm hoping someone has an insight to share. There is a simple text string stored as a DTML Method, with ID = "set_table_0", e.g.: 'border="0" cellpadding="0" cellspacing="0"' When set_table_0 is in the Zope root folder, it isn't discovered through normal acquisition, but no error occurs. <table &dtml-set_table_0;> creates a table with defaults, e.g. border is visible. However, when set_table_0 is moved to a subfolder of the Zope root folder, with the name "table_settings", and the reference is made like so: <table %dtml-table_settings[set_table_0];> the DTML Method is found successfully, and the table border isn't displayed. The question is, why is the folder "table_settings" found in the Zope Root Folder, but not the method? Does Acquisition give higher preference to folders (container), objects than a DTML Method? Thanks, Jerry S.

2 1

I wonder how to access a zope siet
by robert 21 Oct '00

21 Oct '00

Hi there, I started to work through the Zope tutorial as layed out in the Content Manager Guide. I came across a coupple of problems I am seeking help for: 1. Stan (the tutorial avatar) is told to create a ZAcme folder in his root folder. Where is Stans root folder? If it is just the folder which is accessed when Stan logs in why is it not displayed in any of the screenshots in the tutorial. I have the impression the rest of the screenshots are very "acurate". 2. How do I access any of the folders from outside the management screen? I tried to use Http://localhost/ZAcme for the tutorial site, but only get an accesserror thrown at me by IE5. 3.Do I have to create the tutorialals pages in Stans root folder or in the ZAcme folder? Thank you for helping a newby of a great product. regards Robert

1 0

Acquisitiver and Acquisitiver
by Spicklemire, Jerry 20 Oct '00

20 Oct '00

OK, now I'm really confused. I stumbled on a way to make the DTML Method work, that is, the one that wasn't being found before, via Acquisition. All I have to do is forget to add the terminating ';' in : <table &dtml-set_table_0;> so that it looks like so: <table &dtml-set_table_0> Any guesses? Thanks again, Jerry S.

1 0