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

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

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

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

2001-04-09 Thread Bryan Baszczewski
ODBCA 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 que

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

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

2001-04-09 Thread Bryan Baszczewski
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) -

[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?

[Zope-dev] SQL Server ..?

2001-03-15 Thread Bryan Baszczewski
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

[Zope-dev] ZmxODBC DA

2001-03-12 Thread Bryan Baszczewski
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] Zope/Win2K/Crash ...

2001-03-09 Thread Bryan Baszczewski
uot; 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] 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

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

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

[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

[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