RE: [Zope-dev] ZSQL and Normalized databases (or why ZSQL sucks)

2001-04-20 Thread Bryan Baszczewski

 ...I mean that:
   SELECT tab1.col1, tab2.col1
   FROM ... etc ...
Does not expose 'tab1.col1' and 'tab2.col1'.  In otherwords, it
doesn't gracefully handle name clashes.  I realize that calling out
the variable 'tab1.col1' out of the namespace is a pain, but
(hopefully) in the future it would be made easier

I havent followed the entire conversation so forgive me if we are on the
same page but in different books.  Have you tried to alias the column names?

e.g.:  SELECT tab1.col1 AS COL1_A, tab2.col1 AS COL1_B
FROM etc...




-Original Message-
From: The Doctor What [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 10:21 AM
To: [EMAIL PROTECTED]
Subject: Re: [Zope-dev] ZSQL and Normalized databases (or why ZSQL
sucks)


* Adrian Hungate ([EMAIL PROTECTED]) [010420 05:06]:
 May be I am misunderstanding your problem here, but are you suggesting
that

 SELECT tab1.col1 col1, tab2.col1 col2
 FROM ... etc ...

 Does not expose 'col1' and 'col2' in the namespace for you? This is not my
 experience. Ok, I only have about 50 ZSQL methods on my intranet but they
 are all complex queries with column naming clashes. If it failed to work
as
 you are suggesting, I would not have continued using Zope - Database
 connectivity was one of my criteria.

I mean that:
   SELECT tab1.col1, tab2.col1
   FROM ... etc ...

Does not expose 'tab1.col1' and 'tab2.col1'.  In otherwords, it
doesn't gracefully handle name clashes.  I realize that calling out
the variable 'tab1.col1' out of the namespace is a pain, but
(hopefully) in the future it would be made easier.

Perhaps like so:
dtml-var name='tab1.col1' (note single quotes)

 The normality (or abnormality) of your databases should make no
difference,
 (Except to how complex your individual SQL statements become). What
database
 are you running against? Maybe you have hit a database connector bug?

Postgresql.  I've tried all three of the DAs: Psyco, Popy and
PostresDA

[Nice Example Snipped]

What DB was that?  The syntax isn't what I expect from Postgres,
Tandem and MySQL.

 As far as the 'foo=0' example, if you set foo to 0, and do nothing in
 between to change it, of course a test for not equal to 0 will fail, what
 would you expect?

Here is the example again, but better:
paramfoo:int=0/param
dtml-if expr="foo  0"Not Zerodtml-elseZero/dtml-if

If called like so:
dtml-var expr="zsql_example(foo=200)"

It will ALWAYS print 'Zero'.

This makes it hard to do something with a param that defaults to
nothing like:

paramcategory_id=""/param
SELECT
url.id,
url.name
dtml-if category_id,
xref_url_category.categoryid as category_id,
/dtml-if
FROM
url
dtml-if category_id,
xref_url_category
/dtml-if
dtml-sqlgroup where
dtml-if category_id
  dtml-sqltest category_id column="xref_url_category.categoryid"
type="int"
  dtml-and
  xref_url_category.urlid = url.id
/dtml-if
/dtml-sqlgroup


You can't even replace the param with "category_id:int=0" and then
check for category_id = 0 in the dtml-ifs.

I finished my project, so I'm happy for the moment.  I have another
ZSQL project (a DVD, Comic Book and Video tracker for my Manga and
Anime), so I'll be back.

Thanks to everyone who spent time to help out.

Ciao!

--
Who are you going to believe, me or your own eyes?
-- Groucho Marx

The Doctor What: Guru to the Godshttp://docwhat.gerf.org/
[EMAIL PROTECTED]   KF6VNC


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] ZODBCA questions...

2001-04-11 Thread Bryan Baszczewski

You may be interested in recent developments:
http://www.zope.org/Wikis/DevSite/Proposals/DatabaseStategy/HistoricalRevisi
ons/827.44494.7026.26188

I dont know why the DC folks havent stayed on top of ODBC.  They should.
Plenty of Zope/SQL Server users.


-Original Message-
From: Mark Pratt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 11:46 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Zope-dev] ZODBCA questions...


Hi Andy,

I would venture a guess that your ZODBC problems have to do
with the DA being Level 1.

visit the somewhat dated URL:

http://www.zope.org/Members/petrilli/DARoadmap

for details on what Level 1 through 3 represent.

For an upcoming project we will need to work with MS SQL
server as well so I've been discussing with Paul a bit about what
it would take to fund a L3 DA. You might want to send him an
email.

Regards,

Mark

--
mark pratt  (managing director)  [EMAIL PROTECTED]
beehive elektronische medien GmbH   http://www.beehive.de
phone: +49 30 847-82 0  fax: +49 30 847-82 299



___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] ZODBCA questions...

2001-04-11 Thread Bryan Baszczewski

 This is true.  But it's likely the aame reason we dont have an ecommerce
module or an XSLT processor or a catalog which allows for easy indexing of
pdfs or our own object-relational mapping story, or, or, or, or. 

It would be naive of me to assume what reason that is, but I just wondered
why ZODBC DA was left in it's current (somewhat dated, somewhat stale...but
like a old chocolate chip cookie, you'll still eat it) state.


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] ZODBCA questions...

2001-04-09 Thread Bryan Baszczewski

After reading this about Level 2:  "While a sub-optimal solution, it
should be usable on any application that has minimal, or infrequent,
database access"

Then about the ZODBC DA itself:  "Long term progress. See information
below on the future of a X/Open CLI interface DA." ...blah blah blah...
"we will be transitioning to a new design for the ODBC DA, as well as
integrating support for IBM DB2 into the same DA."

I would not use ZODBC  SQL Server for my critical business apps as it looks
like its going away.

-Original Message-
From: Andy McKay [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 3:20 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [Zope-dev] ZODBCA questions...


According to the Database Adapter RoadMap
(http://www.zope.org/Members/petrilli/DARoadmap), ZODBCA will be level 2
compliant at one point. Yet ZODBCA hasnt been touched since 1999. Is ZODBCA
level 2 compliant?

Cheers.
--
  Andy McKay.


- Original Message -
From: "Bryan Baszczewski" [EMAIL PROTECTED]
To: "'Andy McKay'" [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 11:28 AM
Subject: RE: [Zope-dev] ZODBCA questions...


 Andy, We experienced bigtime problems with ZODBC too.  ZODBC locked all
 other requests out when waiting for a complex query.  Upgrade to ZmxODBC
 database adapter (search on zope.org to find it).  We found ZmxODBC to be
 alot better without locking requests.  BUT...it costs money(!)
 and seems no one else uses this though as SQL Server isnt widely supported
 by Digital Creations.  A shame really being that SQL Server is an
excellent
 database.

 For verificaion of your problem, check out the plans for ZODBC the
"Database
 Adapter RoadMap".

 -Original Message-
 From: Andy McKay [mailto:[EMAIL PROTECTED]]
 Sent: Monday, April 09, 2001 1:46 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope-dev] ZODBCA questions...


 Im getting some performance issues with my sites, im connecting Zope to a
 SQL Server (not using ZEO). I've got suspicion, but no proof, that its
 ZODBCA that is the problem. Does anyone have experiences with this on
large
 sites and / or a suggestion to replace it?

 Cheers.
 --
   Andy McKay.




 ___
 Zope-Dev maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope-dev
 **  No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope )




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] Windows FAQ / Help area?

2001-04-09 Thread Bryan Baszczewski

How about database access (i.e. ODBC adapters)

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Andy McKay
Sent: Monday, April 09, 2001 3:51 PM
To: [EMAIL PROTECTED]
Subject: [Zope-dev] Windows FAQ / Help area?


Just thinking how many little tidbits I know related to running Zope on
Windows that are very platform and installation specific. Do people think it
would be a good idea to start at least a wiki / faq section somewhere
covering this? Do other windows users think there is enough stuff to put in
there?

Things I can think of off the top of my head: windows service, getting
stdout when running as a service and I was about to add ZEO, but thats been
fixed...

Cheers.
--
  Andy McKay.




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] Windows FAQ / Help area?

2001-04-09 Thread Bryan Baszczewski

Your answer: http://www.zope.org/Members/djay/ZmxODBC

-Original Message-
From: Andy McKay [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 09, 2001 4:02 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [Zope-dev] Windows FAQ / Help area?


when I find the answer... ;)
--
  Andy McKay.


- Original Message -
From: "Bryan Baszczewski" [EMAIL PROTECTED]
To: "'Andy McKay'" [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 1:10 PM
Subject: RE: [Zope-dev] Windows FAQ / Help area?


 How about database access (i.e. ODBC adapters)

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
 Of Andy McKay
 Sent: Monday, April 09, 2001 3:51 PM
 To: [EMAIL PROTECTED]
 Subject: [Zope-dev] Windows FAQ / Help area?


 Just thinking how many little tidbits I know related to running Zope on
 Windows that are very platform and installation specific. Do people think
it
 would be a good idea to start at least a wiki / faq section somewhere
 covering this? Do other windows users think there is enough stuff to put
in
 there?

 Things I can think of off the top of my head: windows service, getting
 stdout when running as a service and I was about to add ZEO, but thats
been
 fixed...

 Cheers.
 --
   Andy McKay.




 ___
 Zope-Dev maillist  -  [EMAIL PROTECTED]
 http://lists.zope.org/mailman/listinfo/zope-dev
 **  No cross posts or HTML encoding!  **
 (Related lists -
  http://lists.zope.org/mailman/listinfo/zope-announce
  http://lists.zope.org/mailman/listinfo/zope )




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] Zope-SQL Server2000 question

2001-03-21 Thread Bryan Baszczewski


I am curious of how popular SQL Server, particularly 2000, is among Zope
developers.  We have
recenly upgraded from SQL 7 to 2000 and noticed most of the database support
for Zope centers around Oracle, MySQL, Postgres, Sybase, etc...

How many people are using this ZmxODBC database adapter? What kind of
support do you recieve, if any? And what kind of problems/issues/praise do
you have?

Any info would be appreciated.

Thanks a bunch!
Bryan




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] SQL Server ..?

2001-03-15 Thread Bryan Baszczewski


I am curious of how popular SQL Server is among Zope developers.  We have
recenly upgraded from SQL 7 to 2000 and noticed most of the database support
for Zope centers around Oracle, MySQL, Postgres, Sybase, etc...

How many people are using this ZmxODBC database adapter?  And what kind of
problems/issues/praise do you have?

Any info would be appreciated.

Bryan Baszczewski
Software Engineer/Technology Strategist
2s2i, Inc.
www.2s2i.com
phone: (703)534-9800 x-203
fax: (703)995-4866
"Because word of mouth has gone global, there's e-Intelligence from 2s2i."




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] ZmxODBC DA

2001-03-12 Thread Bryan Baszczewski

I am curious of how popular SQL Server is among Zope developers.  We have
recenly upgraded from SQL 7 to 2000 and noticed most of the database support
for Zope centers around Oracle, MySQL, Postgres, Sybase, etc...

How many people are using this ZmxODBC database adapter?  And what kind of
problems/issues/praise do you have?



Bryan Baszczewski
Software Engineer/Technology Strategist
2s2i, Inc.
www.2s2i.com
phone: (703)534-9800 x-203
fax: (703)995-4866
"Because word of mouth has gone global, there's e-Intelligence from 2s2i."




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] Zope/Win2K/Crash ...

2001-03-09 Thread Bryan Baszczewski

Anyone else using Zope on Win2K?  We have recently installed Zope as a
production server on Win2K (SP4) and everything was fine for the first
couple of weeks.  We started a little monitoring program which hits Zope
every 5 seconds, and noticed Zope started to crash intermitently.

In the NT Event Log I find:
"The description for Event ID ( 3 ) in Source ( PythonService ) could not be
found. It contains the following insertion string(s): Error getting
traceback - traceback.print_tb() failed, pywintypes.api_error, (1450,
'CreateProcess', 'No error message is available')."

What is this telling me?  That I ran out of memory?



Bryan Baszczewski
Software Engineer/Technology Strategist
2s2i, Inc.
www.2s2i.com
phone: (703)534-9800 x-203
fax: (703)995-4866
"Because word of mouth has gone global, there's e-Intelligence from 2s2i."




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] ZSQl Cache

2001-03-08 Thread Bryan Baszczewski

Anyone have an idea of what the optimal cache time is (all things considered
.. "normal" circumstances) for a ZSQL query = 50 rows?  Does Zope tend to
lag or suck too much memory at some point?


Bryan Baszczewski
Software Engineer/Technology Strategist
2s2i, Inc.
www.2s2i.com
phone: (703)534-9800 x-203
fax: (703)995-4866
"Because word of mouth has gone global, there's e-Intelligence from 2s2i."




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] RE: ZODBC problem

2001-03-07 Thread Bryan Baszczewski

Alan, I am having a similar lock-out problem while performing a complex
query on SQL Server 2K.  All other hits cannot connect until the query
returns the results.  My research has so far taken me here:

http://www.zope.org/Members/petrilli/DARoadmap
Which is telling me I am probably using at most a Level-2 DA with my ZODBC.

And then here:

http://www.zope.org/Members/djay/ZmxODBC/ZmxODBC_0_0_2.tgz/README
Which is a Level-3 mxZODBC DA (multithreaded).

If anyone sees a problem with what I am about to do, let me know.  What do
you think?



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Capesius, Alan
Sent: Wednesday, March 07, 2001 12:31 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [Zope-dev] RE: ZODBC problem


Thanks Dieter, I was kinda looking for a solution, I reviewed the mailing
lists but do not see any solutions. I've done some more testing here:

Summary: The user selects an involved financial report. The report takes
about 55 seconds for Zope to prepare. The first second is the SQL server
request and reply. The remaining time is Zope processing (dual 200mhz NT
box).

My queries are SELECT JOINS. No tables are modified at the server.

The problem I see here is that Zope/ZODBCDA is holding the connection to SQL
open via ODBC until all processing is complete and then issuing an SQL
statement:  IF @@TRANCOUNT0 COMMIT TRAN

Zope could free up this connection after one second. (at least in this case)
Until Zope does the commit, other users are locked out.

For read only queries, there is no need to have the request under
transaction control. In any case, Zope should be able to early release the
SQL connection and then process on the results.

Certainly increasing processor speed will mask this problem and provide
better response to users, but I'm hoping for a real fix.

Thanks,
Alan

Network Monitor trace  Wed 03/07/01 10:51:50  c:\cap1.TXT

Frame   TimeSrc MAC Addr   Dst MAC Addr   Protocol
1   4.413   006008F6062B   COMPAQ851F04   TCP
2   4.413   006008F6062B   COMPAQ851F04   TCP
3   4.413   006008F6062B   COMPAQ851F04   TCP
[]
193 5.072   006008F6062B   COMPAQ851F04   TCP
194 5.073   COMPAQ851F04   006008F6062B   TCP
195 5.090   COMPAQ851F04   006008F6062B   TCP
196 5.090   006008F6062B   COMPAQ851F04   TCP
197 5.090   006008F6062B   COMPAQ851F04   TCP
198 5.091   COMPAQ851F04   006008F6062B   TCP
199 5.109   COMPAQ851F04   006008F6062B   TCP
200 5.127   COMPAQ851F04   006008F6062B   TCP // SQL server goes idle
after this

// python DTML processing occurs here


201 10.834  006008F6062B   COMPAQ851F04   TCP // not sure what this is,
Data is 0xA8
202 10.834  COMPAQ851F04   006008F6062B   TCP // reply, data is empty

// page returns to user at 60 second mark
// then Zope closes the connection
203 60.385  COMPAQ851F04   006008F6062B   TCP
SQL: IF @@TRANCOUNT0 COMMIT TRAN
204 60.386  006008F6062B   COMPAQ851F04   TCP
205 60.601  COMPAQ851F04   006008F6062B   TCP


Capesius, Alan writes:
  ...
  with further testing I
  have determined that the Zope server itself is not locking up, but
rather
  requests to the database (MS SQL7 via ZODBCDA) seem to be queueing up.

My memory tells me faintly that such an issue has already been
discussed in the mailing lists (zope, zope-dev).
When I remember right, ZODBCDA synchronizes all database requests
-- searchable list archives...


Dieter

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



RE: [Zope-dev] dtml-in: next-batches

2001-03-07 Thread Bryan Baszczewski

I found this in some Zope documentation.  It wont give you "1,2,3,4,5...10"
it gives "(1-10)(11-20)(21-30)...". Monkey with it a little and you'll get
it.  Beware it will call your External Method or ZSQL as many times/10.

dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" previous orphan=1 size=10
start=qs
dtml-in previous-batches mapping
dtml-unless sequence-start, /dtml-unless
a href="dtml-var document_iddtml-var sequence-query
qs=dtml-var batch-start-number"
(dtml-var batch-start-number - dtml-var batch-end-number)/a
/dtml-in
/dtml-in

dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" next orphan=1 size=10
start=qs
dtml-in next-batches mapping
dtml-unless sequence-start, /dtml-unless
a href="dtml-var document_iddtml-var sequence-query
qs=dtml-var batch-start-number"
(dtml-var batch-start-number - dtml-var batch-end-number)/a
/dtml-in

/dtml-in
dtml-in expr="SOME_EXTERNAL_METHOD(REQUEST)" orphan=1 size=10 start=qs
dtml-var sequence-index)"
dtml-var expr="_.getitem('sequence-item')[1]"
dtml-var expr="_.getitem('sequence-item')[2]"
/dtml-in

-Bryan

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Brett Carter
Sent: Wednesday, March 07, 2001 6:34 PM
To: [EMAIL PROTECTED]
Subject: [Zope-dev] dtml-in: next-batches


Does anybody have an example of how to use the supposed next-batches
mapping returned by dtml-in?
I'm trying to build a google-like pageing feature into my application,
so we just show the first 5 results, then have a link to each next
page, ie "1,2,3,4..."
Thanks,
-Brett

___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] Zope Performance - Windows 2000 .. Newbie

2001-03-05 Thread Bryan Baszczewski

I am getting some serious Zope lag time (15-20 seconds) for simple HTML
pages when also trying to hit the same port with data requests.  The data
requests are = 50 records of text data and SQL Server is optimized (meaning
the querys dont take that long, just the connection to Zope).  We are using
port 8080 on Windows 2000 and was wondering if there is some kind of queue
or prioritizing of Zope requests?  If so, how can I work around this?
Thanks in advance!


___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )



[Zope-dev] Zope newbie question

2001-02-07 Thread Bryan Baszczewski


Within my dtml, I am retrieving a text field from a database and passing
this field to a javascript function.  However, the text field can be any
length of characters and dtml keeps cutting the text off at no pre-set limit
making it impossible to pass this field to javascript.  The javascript is
going to take this text and pop it up in another window for the user to
read.

I checked the html source and everything looks fine, but when I execute it
gives an "unterminated string" error.  Could Zope be causing this?

Bryan




___
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )