[Zope] REQUEST.set size

2000-10-10 Thread Paul Zwarts
Hi all, I am new to Zope but worked for 2 years in a dev-env called Uniface so Im fairly up to speed on Zope quickly. But I am having a problem writing data through a REQUEST.set that is larger than its apparent limit. (sorry can remember the exact error i get from Zope) What I am trying to do

Re: [Zope] REQUEST.set size

2000-10-10 Thread Paul Zwarts
and NOT the request.set as I had imagined. Then that leads to overflow tables... which I cant seem to create in PGSQL as I know with Solid. Anyone have suggestions? Cheers, Paz Paul Zwarts wrote: Hi all, I am new to Zope but worked for 2 years in a dev-env called Uniface so Im fairly up to speed

[Zope] dtml-in loop to capture records

2000-10-12 Thread Paul Zwarts
Hi all, I have a number of simple forms that retrieve all occurences of a table into editable fields in a page. Each input tag is named: table stuff dtml-in getList ... input type="hidden" name="item.fieldname:records:required" value="dtml-fieldname;" ... /dtml-in /table Note,

[Zope] [Fwd: Re: [Zope] dtml-in loop to capture records]

2000-10-12 Thread Paul Zwarts
Me again, To further explain my dilemna, I just noticed that using the in ITEM loop doesnt seem to work if the dtml-call statement has an extra parameter. I had dtml-call "verifyLog(mdate=mdate)" publish.. dtml-in item ... ... /dtml-in Then use as in other working forms: dtml-call verifyLog

Re: [Zope] dtml-if and dtml-var question

2000-10-13 Thread Paul Zwarts
Hi there, I've been having problems with DateTimes as well. My colleague and I (using Zope 201) found a problem with the module that causes any dbase timestamp to be rendered to a non-standard UNIX time that has an annoying DST appended if in the Daylight savings time zone, thus leaving the

[Zope] Upgrade from 201 to 222

2000-10-17 Thread Paul Zwarts
Hi all, I have installations of Zope, one for development and one for our live system. We had run Zope 201 on both machines for quite some time, and have just migrated the devshop to the latest Zope build 222. I have noticed that the import/export mechanisms work and I can import across both

Re: [Zope] ZSQL question

2000-10-17 Thread Paul Zwarts
I have a table with lots of data in my Gadfly database. I would like to add a couple of new columns to that table. Is it at all possible to add columns to existing table or do I have to create a new table all together? Nope, ALTER TABLE TABLE_NAME ADD COLUMN_NAME FORMAT_TYPE i think should

Re: [Zope] MailHost: bcc broken ?

2000-10-24 Thread Paul Zwarts
Hi, Im using this: dtml-sendmail smtphost="mail.host" port="25" To: dtml-var email From: dtml-var emailfrom Subject: dtml-var subject Hi, blah blah /dtml-sendmail Im supposing that the double brackets is due to the fact that the email address itself is encapsulated with brackets as well as

Re: [Zope] dtml-if newbie question

2000-11-09 Thread Paul Zwarts
Another thing you can do, not sure if Im using it right, but the effect is good... dtml-unless first_name dtml-raise type=ValidationError font face="Arial, Helvetica, sans-serif" size="-1" color="#00"bYou must specify a font color="red"First Name/b/font. /font

[Zope] querying status in zsql

2000-11-10 Thread Paul Zwarts
Hi Zopers, I have a processing script that takes emails and puts them into a table. I bring up a table for confirmation and then submit the whole thing by a iterative item:records zsql method. My problem is that the table requires a unique primary key and quite regularly there duplicates. So

Re: [Zope] querying status in zsql

2000-11-10 Thread Paul Zwarts
Thanks for that... Although Im not terribly sure what the magic behind the sequence-start is, but it works very well. Cheers, -- Paz Oratrix Development BV http://www.oratrix.com GRiNS SMIL Editor - Rik Hoekstra wrote: I have a processing script that takes emails and puts them into a

[Zope] Transaction sizes

2000-11-16 Thread Paul Zwarts
Hi all, I have a few forms that really work intermitently. They are quite large in processing, accessing several thousand occurences in several tables, several times. Wont go into details, but its a resource hog. Alot of times the page eventually returns a No data error. This causes me to wonder

[Zope] Using a Session variable in a dtml-var

2001-01-22 Thread Paul Zwarts
Hi all, Im trying to call a variable from SQLSession and then use it in a var. I am using SQLSession to store the 'zone' value which I want to call in the index_html document to then include a specific dtml-method depending on the variable that the Session returns. SESSION['zone'] will equal

[Zope] Opensource DBMS for WIN?

2001-01-23 Thread Paul Zwarts
Greetings, Was wondering if there was an open source dbms to use with Zope on a Win2k machine...? I found references of using cygwin to run PGSQL (which we have on our unixbox) but would prefer something that doesnt run over an extender-shell... TIA, Paz

[Zope] SQLSession not working

2001-01-24 Thread Paul Zwarts
Hi all, I have a unix machine with PGSQL and Zope 2.2.1? and my app uses SQL session brilliantly. But I've created another test machine with Zope 2.2.5, Win2kPro and MySQL 3.3.23 (i think)... and SQL Session no longer works properly. Every time I call a page, a different Session is used and Im

Re: [Zope] PCGI and MS-IIS on Nt5

2001-01-31 Thread Paul Zwarts
ould IIS be configured for the pcgi file to be a header or...? I'll try the siteaccess, but i assume its in 2.3? how is it invoke if it is a built in product? Thanks again, Paz Max M wrote: From: Paul Zwarts >so, technically I did set it up correctly, but I want to configure the >default do

RE: [Zope-dev] Curiously Zope Hanging

2001-07-12 Thread Paul Zwarts
I've had this problem as well, although I changed from ZPopPy to psycopg0.99.4 which solved the problem. What I found in REdhat Linux 7.1, where the ps -ef command now queries more info from its children, I finally saw the status of my dbms threads. The Zope hanging maybe wasnt zope directly. It

RE: [Zope-dev] Curiously Zope Hanging

2001-07-12 Thread Paul Zwarts
unhappy customers anymore. Paz -Original Message- From: Federico Di Gregorio [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:30 PM To: Paul Zwarts Cc: Andre Schubert; [EMAIL PROTECTED]; zope Subject: RE: [Zope-dev] Curiously Zope Hanging On 12 Jul 2001 15:20:16 +0200, Paul Zwarts

RE: [Zope-dev] Curiously Zope Hanging

2001-07-12 Thread Paul Zwarts
Ah, the common paradigm. someone TOLD me that smoking cigarettes wiht ceral and milk will make me barf, and I can assume that to be so. But when i do indeed barf, do I come satisfied with that or now question if that it had to do with te spoon or the bowl? Paz -Original Message- From:

RE: [Zope-dev] DocumentLibrary 1.0b3 / Zope 2.4.2 (newbie?) problem

2001-11-02 Thread Paul Zwarts
Hi, Are you using dtml-var ZopeTime().Date() instead of dtml-var _.ZopeTime().Date() ZopeTime I suspect doesn't come from the local namespace. Cheers, Paul Zwarts -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Kolb, Hap Sent: Friday, November

RE: [Zope-dev] ZSQL methods lookup vars in REQUEST only (why?)

2001-10-11 Thread Paul Zwarts
. It requires the programmer to keep even more close care that all variables generated at runtime are first cleaned and wiped so that this same REQUEST couldn't just be anticipated by someone who's interested. Or can you suggest a way around this? Thanks, Paul Zwarts -Original Message- From: [EMAIL

RE: [Zope-dev] ZSQL methods lookup vars in REQUEST only (why?)

2001-10-11 Thread Paul Zwarts
instead, but I'm not very good at it yet, and can crank out dmtl much faster. Just some tips if anyone's interested... Paul Zwarts -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Toby Dickenson Sent: Thursday, October 11, 2001 2:43 PM To: [EMAIL PROTECTED