January 2002 - Zope - Zope lists

Re: [Zope] Multiple Inserts Using Sybase DAV
by tgraham＠speakeasy.net 25 Jan '02

25 Jan '02

Hi Kia, Search the archives for the string "delete multiple records sql python" It will give some good code examples of what I think you're trying to accomplish. Basically I think you need to use the 'list' argument in your html form and pass the list it to a python script for manipulation Todd On 25 Jan 2002, Kia A. Arab wrote: > The sql_delimiter does work with Sybase. > However, the thing that is tripping me up is > that the values I'm trying to get into the > database are in a list. The html form is a > multiple selection menu and the selections are > put in a list under one name (in this case, > NAME=keywords). > > The ACTION on my html form is a dtml-method > that verifies the input, and then makes a > dtml-call to a sql method. But, how do you > make a dtml call to a python script and pass > it a 'list' parameter? If I can pass it > correctly, the Python-script would then > manipulate the list and send each list value > to a sql-method to insert the value in a > database. Tried every which way, but not luck. > I can't seem to 1 - get the values from my > html form passed to a python script, then 2 - > get the python script to pass the list values > to a sql-method > > Any help is appreciated. Again, please email > me directly. Thanks, > K. > > Gilles Lenfant wrote: > > > > <dtml-var sql_delimiter> is supposed to work > > with most DA. Dunno for Sybase but it works > > with MySQL. Workaround (no sql_delimiter) : > > Try a python script that calls both (or any > > number of) ZSQL methods in sequence > > providing the parameters through a dict or > > mapping object: > > > > context.mysqlmethod({'param1': value1, > > 'param2': value2}) ... > > > > _____________________________________________- > __ > 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/listinf- > o/zope-announce http://lists.zope.org/mailman- > /listinfo/zope-dev )

1 0

Multiple Inserts Using Sybase DAV
by Kia A. Arab 25 Jan '02

25 Jan '02

Hi, I'm creating a web application where users can submit and retrieve library resources online. The backend of this application is a Sybase database. I use two tables: one that stores a unique id, title, author, name, etc. And another that stores keywords related to the resource for searching purposes. All this information is captured on one form. The keywords are captured in a list by way of the Python cgi module. The problem I'm having is inserting this information into the two tables. I can easily insert the title, author, etc info into one table. But, when I try to put the keywords in a separate table, it fails. Seems like a simple task but I'm at a loss. Does anyone have any suggestions. And please also email me directly since I'm not subscribed to this list. Thank you, Kia Here is my insertAction. The appropriate parameters are in the argument list: INSERT into lib_entry ( submitter, office_num, resource_type, resource_title, resource_author, resource_pubdate, resource_abstract) VALUES ( <dtml-sqlvar submitter type="string">, <dtml-sqlvar office_num type="string">, <dtml-sqlvar resource_type type="string">, <dtml-sqlvar resource_title type="string">, <dtml-sqlvar resource_author type="string">, <dtml-sqlvar resource_pubdate type="string">, <dtml-sqlvar resource_abstract type="string">) After this, how do I insert the keywords?

2 2

Re: Zope digest, Vol 1 #1892 - 46 msgs
by Gary Poster 25 Jan '02

25 Jan '02

> From: "Lennart Regebro" <lennart(a)regebro.nu> > From: "Heimo Laukkanen" <huima(a)fountainpark.org> > > Now if someone in service1 tries an URL www.service1.com/service2/foo - > > Zope tries to find -- and can access if it exists -- service2/foo. Is > > there a way to prevent this kind of thing happening? > > I don't know if you can stop the aqcuisition. But setting rights properly > should > at least stop any security problems. Simple solution, if it is acceptable to you, and does not involve creating too many items: in each virtual root folder, mask the other folders by creating a document object named, in your example, service2. Put an error message in it, or make it a script that raises a redirect to something else. Gary

1 0

Zope humor?
by Derek Simkowiak 25 Jan '02

25 Jan '02

Maybe it's just me, but I got a short chuckle out of this: https://www.zope.org/ (Notice it's https, not http.)

2 1

RE: [Zope] Static fail-over
by Meilicke, Scott 25 Jan '02

25 Jan '02

What is the best way to keep ZEO server data.fs files in synch for IP takeover? Shared drives? Thanks - Scott From: sean.upton(a)uniontrib.com [mailto:sean.upton@uniontrib.com] Sent: Thursday, January 24, 2002 2:49 PM To: dereks(a)realloc.net Cc: zope(a)zope.org Subject: RE: [Zope] Static fail-over --snip-- I also use IP takeover for my relational database, file serving, and ZEO storage server setups. --snip-- The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.

1 0

index_html
by Terence Ng 25 Jan '02

25 Jan '02

Hi! I want to activate the standard_html_header in a folder (e.g /abc) rather than the standard_html_header in / if people visit my site. But what is the command? Best regards, Terence Ng _________________________________________________________ Do you Yahoo!? SMS Messenger 手機電腦互動新趨勢 Instant messaging between PC and mobile http://hk.mobile.yahoo.com/sms_msgr.html

3 3

interbase adapter
by Stephan Herschel 25 Jan '02

25 Jan '02

Hello, I need an interbase DA that does no serializing, i.e. that is level 3 compliant. The one we use (gvibDA) is serializing requests and therefore queries that take a longer time to return tend to slow down the whole system. Can anyone help me? Thanks, Stephan

2 1

turn string into date
by Steffen Hausmann 25 Jan '02

25 Jan '02

Hi, I have a problem with a python script... I want to know the month of a date. Therefor I use 'lastDate.strftime( '%m' )'. If I catch the date with 'lastDate = DateTime()' everything works fine, but if I define it manually ( 'lastDatee = 2002/01/18 21:34:18.4746 GMT+1' ), I am getting an attribute error: Error Type: AttributeError Error Value: strftime How can I turn the string into a date, so that strftime works again? MfG Steffen -- Es gibt keine perfekten Menschen, nur perfekte Absichten.

5 7

Re: [Zope] Empty lines in forms?
by Juan Garcia Garcia 25 Jan '02

25 Jan '02

Hi, i suggest you an easy solution. You can erase the line with the hidden input, and in the document that it's called from the form you must check if the variable exists, and if it's false you set an empty list for this variable. The code: <dtml-if "not REQUEST.has_key('variable')"> <dtml-call "REQUEST.set('variable', [])"> </dtml-if> Bye. Juan

1 0

Fwd: Restriction on file upload sizes
by Uwe Seithe 25 Jan '02

25 Jan '02

This is a forwarded message From: Uwe Seithe <internet(a)seithe.de> To: webmaster(a)zope.org <webmaster(a)zope.org> Date: Friday, January 25, 2002, 4:14:06 AM Subject: Restriction on file upload sizes ===8<==============Original message text=============== Hello webmaster, I'm a Zope Newbie, and very interested in a HOWTO about that stuff. I need a Restriction on file upload sizes for my own server too. Please send me just a short description how to make it. Thanks. uwe. \\\|/// ( o o ) --------ooO--(_)-Ooo----------- Enjoy your day.... ===8<===========End of original message text=========== Best regards, Uwe mailto:internet@seithe.de

2 1