- Zope - Zope lists

Date format question urgent!!!
by Marko MARKOVIC 27 Jul '00

27 Jul '00

hi all, i have a few questions about date formating: i work with a sybase database and have tables where i used date fields. My field entrydate is of type Date. on my page i have a textbox to put the date: <input type="text" name="new_nsentrydate" value="01.01.2000" size="10"> i will formating it as 2000/01/01 and then put it in a sql query as a parameter. For the formating i use the follow code: <dtml-with "_.DateTime(new_nsentrydate)"> <dtml-var " '%s/%s/%s' % (year(), mm(), dd())"> </dtml-with> and i get 2000/01/01. Here is my dtml-code: <dtml-with "_.DateTime(new_nsentrydate)"> <dtml-var "'%s/%s/%s' % (year(), mm(), dd())"> </dtml-with> <dtml-with "_.DateTime(new_nsbirthday)"> <dtml-var "'%s/%s/%s' % (year(), mm(), dd())"> </dtml-with> with this code : <dtml-call "insertNoteService(nsentrydate = "_.DateTime(new_nsentrydate)" '%s/%s/%s' % (year(), mm(), dd()), nsname = new_nsname, nsadresse = new_nsadresse, nslocation = new_nslocation, nscountry = new_nscountry, nsbirthday = "_.DateTime(new_nsbirthday)" '%s/%s/%s' % (year(), mm(), dd()), nsbirthplace = new_nsbirthplace, nstext = new_nstext, nsstatus = 0, nstype = new_nstype, nssociety = new_nssociety, nsservice = new_nsservice)"> i get the folowing error: Invalid attribute name, "_.DateTime(new_nsentrydate)", for tag <dtml-call "insertNoteService(nsentrydate = "_.DateTime(new_nsentrydate)" '%s/%s/%s' % (year(), mm(), dd()), nsname = new_nsname, nsadresse = new_nsadresse, nslocation = new_nslocation, nscountry = new_nscountry, nsbirthday = "_.DateTime(new_nsbirthday)" '%s/%s/%s' % (year(), mm(), dd()), nsbirthplace = new_nsbirthplace, nstext = new_nstext, nsstatus = 0, nstype = new_nstype, nssociety = new_nssociety, nsservice = new_nsservice)">, on line 4 of addNoteService_html with this code : <dtml-call "insertNoteService(nsentrydate = "_.DateTime(new_nsentrydate)" '%s/%s/%s' % (year(), mm(), dd())", nsname = new_nsname, nsadresse = new_nsadresse, nslocation = new_nslocation, nscountry = new_nscountry, nsbirthday = "_.DateTime(new_nsbirthday)" '%s/%s/%s' % (year(), mm(), dd())", nsbirthplace = new_nsbirthplace, nstext = new_nstext, nsstatus = 0, nstype = new_nstype, nssociety = new_nssociety, nsservice = new_nsservice)"> i don't get Errors, but it doesn't work. Here is my sql code: INSERT INTO noteservice (ns_entrydate, ns_name, ns_adresse, ns_location, ns_country, ns_birthday, ns_birthplace, ns_text, ns_status, ns_type, ns_society, ns_service) VALUES('<dtml-var nsentrydate>', '<dtml-var nsname fmt=sql-quote>', '<dtml-var nsadresse fmt=sql-quote>', '<dtml-var nslocation fmt=sql-quote>', '<dtml-var nscountry fmt=sql-quote>', '<dtml-var nsbirthday>','<dtml-var nsbirthplace fmt=sql-quote>', '<dtml-var nstext fmt=sql-quote>', <dtml-var nsstatus>, <dtml-var nstype>, <dtml-var nssociety>, <dtml-var nsservice>) when i use this code : <dtml-with "_.DateTime('01.01.1900')"> <dtml-var "'%s/%s/%s' % (year(), mm(), dd())"> </dtml-with> i get 1900/01/01 when i use this code : <dtml-let tert="'01.01.1900'"> <dtml-var "_.DateTime(tert)" fmt="%Y/%m/%d"> </dtml-let> i get 2036/02/07 Why? when i use this code : <dtml-var "_.DateTime('01.01.1900')" fmt="%Y/%m/%d"> i get 2036/02/07 Why? when i use this code : <dtml-var "ZopeTime('01.01.1900')" fmt="%Y/%m/%d"> i get 2036/02/07 Why? Could you explain me how i must handle date fields in zope? Finally, i want formatting a date as 2000/01/01 and then put in my table with a sql method. Any suggestions or a good example will be apprecieated... $Regards MM

2 1

Réf. : Re: [Zope] dtml question from a newbizzzzz I want to access a dtml page under a subfolder subfolder : [Zope] dtml question from a newbizzzzz I want to access a dtml page under a subfolder subfolder
by dsergent＠imexpert.com 27 Jul '00

27 Jul '00

thks for your answer, but I use the variable PARENTS[0] in index2 and with your syntax, the result is not the same. "Marcel Preda" Pour : zope(a)zope.org <marcel@punto cc : .it> Objet : Re: [Zope] dtml question from a Envoyé par : newbizzzzz I want to access a dtml page under a zope-admin@zo subfolder subfolder pe.org 27/07/00 10:54 On Thu, 27 Jul 2000 dsergent(a)imexpert.com wrote: > > I want to access a dtml page under a subfolder > > - portal (folder) > - index1 (dtml) > - reunion (folder) > - index2 (dtml) > > > I want to acces the index2 variable in the index1 dtml page. How can I do > it ? > > thks for your answer > David Sergent > <dtml-with reunion> <dtml-var index2> </dtml-with> OR <dtml-var "reunion.index2"> PM _______________________________________________ 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

SQL and customise screen
by Vincent DELHOMMOIS 27 Jul '00

27 Jul '00

Hi, I would like to use an SQL request to search some data in an access database. The request need to be executed when somebody clic on a button (onclick="") The result need to be displayed on the screen, but not on one line. I must be able to place the results in different places on the document. If somebody has any idea. Vincent - Thanks PS : At least, I must be able to customise the array display with the search zope wizard

2 1

dtml question from a newbizzzzz I want to access a dtml page under a subfolder subfolder
by dsergent＠imexpert.com 27 Jul '00

27 Jul '00

I want to access a dtml page under a subfolder - portal (folder) - index1 (dtml) - reunion (folder) - index2 (dtml) I want to acces the index2 variable in the index1 dtml page. How can I do it ? thks for your answer David Sergent

3 2

zwiki mailing list ? RFC
by Simon Michael 27 Jul '00

27 Jul '00

I'm getting a steady trickle of private mail, interesting comments & patches, all of which would benefit the community but currently end up mouldering in my mail archives. I'm thinking of activating the zwiki mailing list at sourceforge, as a repository for the above and perhaps a testbed for mailing-list/zwikiweb integration. On the other hand I'm against too much fragmentation of our discussions - things are bad enough already! - and I like to use the zope list where possible. If you have any thoughts either way, I'd like to hear 'em. - Simon

2 1

Your feedback: what should DateTime strftime() behavior be?
by Brian Lloyd 27 Jul '00

27 Jul '00

Hi all - There has recently been some confusion over the expected behavior of various approaches to DateTime formatting in Zope regarding timezone representation. I would like to resolve this for the next release by making a proposal and asking you to reply to the list with a "vote": +1 == agree +/-0 == no strong opinion -1 == disagree So then, here is the situation. In Zope 2.2 (and earlier), formatting a date using either: <dtml-var theDate fmt="%A, %B %d %Y, %H:%M:%S"> <dtml-var "theDate.strftime('%A, %B %d %Y, %H:%M:%S')"> ...would give you the date *formatted based on GMT rather than the timezone (usually local) representation of the object*. Simply doing: <dtml-var theDate> ...however, would print the date in the current timezone of the datetime object. Many feel that this difference is unintuitive and a pain. The proposal is that both: <dtml-var theDate fmt="%A, %B %d %Y, %H:%M:%S"> <dtml-var "theDate.strftime('%A, %B %d %Y, %H:%M:%S')"> ...would be changed to apply the format to the current TZ representation of the object rather than convert to GMT. Of course, this could be a problem if there are people currently counting on the output being GMT, which is why we're putting it to a vote. If this change is made for 2.2.1, those who still wanted the output in GMT could just call the 'toZone()' method of the datetime object to get a GMT version before formatting: <dtml-var "theDate.toZone('GMT').strftime('%A, %B %d %Y, %H:%M:%S')"> What do you think? Brian Lloyd brian(a)digicool.com Software Engineer 540.371.6909 Digital Creations http://www.digicool.com

14 13

ZOracleDA
by Aaron Bostick 27 Jul '00

27 Jul '00

Zope list members, I have been developing a zope site with oracle on linux as a backend. Currently, I run both zope and oracle on the same machine using the ZOracleDA for connectivity. However, for production, I plan to seperate the tiers and run zope and and oracle on different servers. From looking at the build instructions for the DCOracle, it seems as though it will only work when the web server and database server are on the same filesystem/in the same memory space. Is there a way to have my zope server talk to a remote (across the network somewhere) database server? Do I have to move to something like ODBC for this? Thanks for your help! Aaron Bostick Network Architect Exodus Professional Services

4 3

Re: [Zope] new wiki functionality/zope.org issues
by Simon Michael 27 Jul '00

27 Jul '00

Simon Michael <simon(a)joyful.com> writes: > Yah I found the zwiki pages alright :) but couldn't find any trace of > the new search or history functionality ? so I downloaded the 2.2 deb (thank you Gregor), looked in the management UI, and found the history tab. Very nice! I'll admit, I feared 2.2 for it's new ownership system.. but nothing's bit me yet and the whole thing is looking very slick and polished. Many thanks to all involved.

1 0

newbie DTML namespace
by Brad Moulton 27 Jul '00

27 Jul '00

Hi all, as a newbie to both python and zope i am struggling with understanding the howto and the syntax of accessing stuff in namespace eg I would like to build a table depending on some tests peformed on stuff returned form a Z SQL method 1. I have a form with a name="spam" value="egs" this value is passed onto next dtml document --------------------------------- table <tr> <td><dtml-var spam> <td> // displays 'eggs' to test spam is OK </tr> <dtml-var sqlstuff> // this does a join of two tables <dtml-in sqlstuff> <dtml-if {CAN'T WORK OUT SYNTAX TO ACCESS spam to compare with lets say sqlstuff.spam} <tr><td><dtml-var sqlstuff.column></td>....etc </dtml-if> </dtml-in> ---------------------------------------------- I have read DTML Reference but dtml-if says "a valid python expression" Can I still access spam inside the dtml-in if so how <dtml-var spam>, spam 'spam', ['spam'] and then how do i refer to a table column name returned in the SQL query to make the comparison TIA brad

1 0

Re: [Zope] while
by Leichtman, David J 27 Jul '00

27 Jul '00

But that's more like a for loop. No test condition. Basically, I want to keep redoing a method until a condition is met. -----Original Message----- From: Daniel Rusch [mailto:drusch@globalcrossing.com] Sent: Wednesday, July 26, 2000 3:19 PM To: Leichtman, David J Cc: 'zope(a)zope.org' Subject: Re: [Zope] while Try: <dtml-in "_.range(1,10)"> <dtml-var sequence-item> </dtml-in> "Leichtman, David J" wrote: > Is there an easy way to simulate the functionality of a while loop in DTML? > > _______________________________________________ > 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 )

2 1