[Zope] Newbie SQL problem: Query Error: Cannot render query template

2000-08-30 Thread Farrell, Troy
the error "Query Error: Cannot render query template". Can you tell me what the cause is. I think it might be a permissions problem, but I have everything wide open and I can't figure it out. Thanks. Troy Farrell Troy Farrell Video Operations Technician II Williams VYVX Services 91

RE: [Zope] Log file settings

2000-08-31 Thread Farrell, Troy
From z2.py: # Location of the ZServer log file. This file logs all ZServer activity. # You may wish to create different logs for different servers. See # medusa/logger.py for more information. if not os.path.isabs(LOG_FILE): LOG_PATH=os.path.join(CLIENT_HOME, LOG_FILE) else:

RE: [Zope] Newbie SQL problem: Query Error: Cannot render query template

2000-09-01 Thread Farrell, Troy
. Never did find an NT solution, I just moved everything to Linux. It's worth a try. - Steve On Wed, 30 August 2000, "Farrell, Troy" wrote: Hello. I am running Zope as a service on NT4WS. I have multiple MS Access databases connected to different ZJetDAs and I am not able to modify

RE: [Zope] ZODB How To please HELP

2000-09-07 Thread Farrell, Troy
Could you send the SQL you used? Also, what platform and Database are you using? -Original Message- From: Norman Khine [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 07, 2000 7:05 AM To: [EMAIL PROTECTED] Subject: [Zope] ZODB How To please HELP I am trying to

[Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1

2000-09-07 Thread Farrell, Troy
As you have no doubt heard my cries for help, I figure that very few are running NT4. I am having a permissions difficultie with ZJetDA trying to modify data in an Access97 database. On my server, the DA is able to SELECT * FROM tablename with no problem, but when it comes to INSERT INTO

RE: [Zope] Need help with ZJetDA, Winnt4 and Zope 2.2.1

2000-09-08 Thread Farrell, Troy
ccessfully with permissions wide open with and without acquisision. More to come. Thanks. Troy -Original Message- From: Rik Hoekstra [mailto:[EMAIL PROTECTED]] Sent: Friday, September 08, 2000 4:33 AM To: Farrell, Troy Cc: '[EMAIL PROTECTED]' Subject: Re: [Zope] Need help with ZJetDA, Winnt

RE: [Zope] Is Squishdot ready for prime time?

2000-09-09 Thread Farrell, Troy
I don't know about squishdot, but making DA's work with ZOpe on NT has been giving me fits. Plan plenty of setup time. Oh, how I wish i could use *n(u/i)x. I think I'll sneak it on to the dev server. Troy Troy Farrell Video Operations Technician II Williams VYVX Services 918.573.3029

RE: [Zope] Best way to handle SQL update with variable number of fields?

2000-09-10 Thread Farrell, Troy
I'm trying to understand exactly what you mean. I have some ZSQL Methods that have an empty (INSERT INTO site_location VALUE('New York', '')) value in them. For the above I use: INSERT INTO site_location VALUE(dtml-sqlvar site_city type=string, dtml-sqlvar site_zipcode type=int). Can you

RE: [Zope] Edit Window size limit on Netscape communicator 4.7

2000-09-28 Thread Farrell, Troy
At this point, I'm thinking the document needs to be broken out into multiple docs or methods or edited and FTP'd. Beside, textareas don't have many features. Troy -Original Message- From: Oleg Broytmann [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 28, 2000 8:22 AM To: Marcello

RE: [Zope] Question!

2000-10-16 Thread Farrell, Troy
Yes you can. You will need ZODBC to connect to the SQLServer. Make sure that SQL server is available as a "System DSN" on it's host. You will also need a username and password to connect. Zope will ask you for this in the DSN string. Best of luck to you. Troy Troy Farrell Video Operations

RE: [Zope] Question!

2000-10-19 Thread Farrell, Troy
iption, and a server name. Let me know what else you need to know. Troy -Original Message- From: Carlos Vasconez [mailto:[EMAIL PROTECTED]] Sent: Monday, October 16, 2000 10:56 AM To: Farrell, Troy Subject: Re: [Zope] Question! Hi I download de ZODBC but are not how connect to the data

RE: [Zope] dtml-sqlvar quote

2000-10-20 Thread Farrell, Troy
It is not safe if you have malicious users. You will need to pass your dtml-var name="search_field" through a filter. This will help. A better example is a user taking advantage of an insert method: insert into data values (dtml-var name="value_1", dtml-var name="value_2", dtml-var

RE: [Zope] Problems with mysql and sql methode

2000-10-20 Thread Farrell, Troy
You may try: SELECT pyname, pyprice FROM payment WHERE merchantpayment.meid = 418 AND merchantpayment.pyid = payment.pyid I have a feeling mysql is not liking you for not selecting results from table MERCHANTPAYMENT becuase you said you would. Troy -Original Message- From: Jens Grewen

RE: [Zope] OT:NT and rebooting (was:How many houres do I need to manage a Zope) site?

2000-10-25 Thread Farrell, Troy
My 2 ZoNT (Zope on NT workstation) boxen haven't needed rebooting yet. They sit mostly idle with occasional light loads. They are P100/32MB/1.2GB old(er than dirt) Industrial Computer Supply boxes. You know, 19" rack mount 4U units. Good, solid, slow hardware. They survive NT rather well.

RE: [Zope] preventing acquisition

2000-10-31 Thread Farrell, Troy
. You might look at http://www.zope.org/Members/rossl/SpecificContext It is not specific to your problem, but it might help. Troy -Original Message- From: Robin Becker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 31, 2000 2:52 PM To: Farrell, Troy Cc: [EMAIL PROTECTED] Subject: Re

RE: [Zope] images in directories

2000-11-02 Thread Farrell, Troy
Aha! Acquisition! http://www.zope.org/Members/Amos/WhatIsAcquisition Assuming that IMAGES is a subfolder of the PWD, try this (untested): dtml-with IMAGES dtml-var image1 /dtml-with Also look here: http://www.zope.org/Members/michel/HowTos/WithTagHow-To Troy What is a fool that has no

[Zope] img tags, dtml-vars and css

2000-11-09 Thread Farrell, Troy
I must be ignoramus, but I can't figure out modify img tags as generated by a image object. I have this: I use dtml-var expr="img.logo_image" to add an image object to a dtml document. How can I add a STYLE="color:silver;" or any other tag the HTML source? Troy Farrell Video Operations

RE: [Zope] Generating text/csv from DTML method, Mime Type?

2000-11-10 Thread Farrell, Troy
I know this sounds silly, but try making the url end with .csv I wrote a perl cgi script some time ago that spit out a csv file. When it ended with .csv, IE seemed to ignore the server's Content-type: text/html header. http://finance.yahoo.com/q?s=WCGd=v1 Look, my stock is falling! Actually,

RE: [Zope] Generating text/csv from DTML method, Mime Type?

2000-11-10 Thread Farrell, Troy
I telneted into the link I gave below and here is the RESPONSE: HTTP/1.0 200 OK Date: Fri, 10 Nov 2000 19:26:52 GMT Cache-Control: private Connection: close Content-Type: application/octet-stream Set-Cookie: B=48be9l0t0oivtb=2; expires=Thu, 15 Apr 2010 20:00:00 GMT; path=/; domain=.yahoo.com

RE: [Zope] help

2000-11-13 Thread Farrell, Troy
You need to add a user. The superuser cannot own any objects inside zope. Go to the folder called acl_users and add a user with manager permissions. Close all copies of your browser. Open a new one and login as the new user. Then you will be able to add objects. See also:

RE: [Zope] Zope and Windows DB's = NOT! ?

2000-11-14 Thread Farrell, Troy
I've been using ZODBCDA 3.1.0b3 for 3 months on MS Acccess with no problems. Zope 2.2.2 Access 97 SR2 NT 4 SP6a 100MHz P5 32MB Ram Troy ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML

RE: [Zope] Problems using M18

2000-11-20 Thread Farrell, Troy
This is known bug 59387 with mozilla. It is related to the usage of frames. http://bugzilla.mozilla.org/show_bug.cgi?id=59387 Troy -Original Message- From: Andreas Tille [mailto:[EMAIL PROTECTED]] Sent: Monday, November 20, 2000 8:06 AM To: Zope user list Subject: [Zope] Problems

RE: [Zope] date in Z Gadfly Database

2000-11-30 Thread Farrell, Troy
Note that Gadfly does not support the DATE datatype. You can use VARCHAR to store a string, or switch to a different database, such as PostgreSQL (my personal preference) or MySQL. The answer to your question is found here: http://www.chordate.com/kwParsing/gadfly.html#table The main Gadfly

[Zope] Windows NT, Zope, PostgreSQL, PoPy, and ZPoPyDA

2000-12-01 Thread Farrell, Troy
Is anyone using NT (or W2K), Zope, PostgreSQL, PoPy and ZPopyDA? Do PoPy and ZPoPyDA build on NT? with cygwin? Thanks for any type of input you have. Troy Troy Farrell Video Operations Technician III Williams VYVX Services 918.573.3029 918.573.1441 fax mailto:[EMAIL PROTECTED]

RE: [Zope] Cannot create Primary Key

2000-12-07 Thread Farrell, Troy
See this question from the gadfly faq: http://www.chordate.com/kwParsing/gffaq.html#key -Original Message- From: Angietel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 29, 2000 10:17 PM To: [EMAIL PROTECTED] Subject: [Zope] Cannot create Primary Key I'm using the Z Gadfly

RE: [Zope] site structure

2000-12-14 Thread Farrell, Troy
If you are like me, you like to keep your standard_html_[header,footer] fairly stock. I have started including dtml-method components in my pages like this: dtml-var name="standard_html_header" dtml-var name="top_navbar" *CONTENT HERE* dtml-var name="bottom_navbar" dtml-var

RE: [Zope] Windows NT, Zope, PostgreSQL, PoPy, and ZPoPyDA

2000-12-14 Thread Farrell, Troy
Right now, I have PostgreSQL 7.0.3 on Cygwin: $ uname -a CYGWIN_NT-4.0 hostname 1.1.6(0.30/3/2) 2000-11-21 21:00 i686 unknown I followed the instructions found here: http://people.freebsd.org/~kevlo/postgres/portNT.html I haven't bothered with PoPy yet, but using the --with-odbc option seems

RE: [Zope] POST METHOD

2000-12-19 Thread Farrell, Troy
Please be more specific: What type of field? What error is Zope giving you? What browser are you using? If you are curious about what form variables Zope is getting, set the form method to a DTML method with this in it: dtml-var name="standard_html_header" dtml-var name="REQUEST" dtml-var

RE: [Zope] [Newbie] Can Zope ...

2001-01-09 Thread Farrell, Troy
Same as ZPL http://demo.worldpilot.com:8080/site/LICENSEWPL.txt -Original Message- From: Andy McKay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 09, 2001 4:06 PM To: tav; [EMAIL PROTECTED]; Smith Ray Subject: Re: [Zope] [Newbie] Can Zope ... I'd personally stay from Worldpilot

RE: [Zope] HOW TO UNLOCK????

2001-01-10 Thread Farrell, Troy
Did you try deleting the cookie on the browser? Please don't yell. Troy -Original Message- From: Rommel Novaes Carvalho [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 10:28 AM To: '[EMAIL PROTECTED]' Subject: [Zope] HOW TO UNLOCK WE NEED TO UNLOCK A VERSION THAT

RE: [Zope] Adding content type to internet explorer

2001-01-16 Thread Farrell, Troy
In W95/NT: Open a File Explorer window (not IE) and select Options from the View menu. The popup will have a tab labeled File Types. This is how you change windows MIME types. In W98/2k: I don't remember and I don't have it with me. It is a similar option under IE (since there is no

[Zope] [ZClass]User Form to add an Instance of one ZClass to an instanceof another ZClass of another ZClass

2001-01-16 Thread Farrell, Troy
Hello all- Being new to ZClasses, I'm having some difficulties. I have a ZClass NetShowLogFile. I can add this to normal Folder Objects through the management interface. I have a second ZClass StreamingEvent. I would like an user to be able to add a NetShowLogFile to an existing Folder Object

RE: [Zope] Adding content type to internet explorer

2001-01-16 Thread Farrell, Troy
Actually, I'm not a newbie, but that is the nicest greeting a "newbie" has gotten on this list that I know of. Thanks. To see how IE looks at MIME types, look here: http://msdn.microsoft.com/workshop/networking/moniker/overview/appendix_a.as p From the looks of it: IE first looks at the

RE: [Zope] links for PostreSQL

2001-01-19 Thread Farrell, Troy
The newer ZPoPyDA is at: http://www.zope.org/Members/tm/ZPoPyDA You can find a ZClass used to diagram a database here: http://www.zope.org/Members/aeg/ZPostgresUtils Troy -Original Message- From: Andreas Heckel [mailto:[EMAIL PROTECTED]] Sent: Friday, January 19, 2001 7:53 AM To:

RE: [Zope] Shut down zope from python script

2001-01-19 Thread Farrell, Troy
Yes, we all wish we were on *N[UI]X. However the question was "How do we shut this thing down?" Using ThroughTheWeb(TTW) scripting: http://usernamewithabilitytoshutdownzope:password@zopeserver:8080/Control_Pa nel/manage_shutdown adjust the portnumber to match your server. You can do this with

RE: [Zope] searching names in a query

2001-01-19 Thread Farrell, Troy
Jacintha, This is from the Gadfly SQL support page at: http://www.chordate.com/kwParsing/gfSQL.html * Some important omissions from ODBC 2.0 at this point are Nulls. Outer joins. CHECK conditions. Enforced data type constraints. Alter table (can't implement until NULLs arrive). Date, Time,

RE: [Zope] Object DB versus Relational DB

2001-01-22 Thread Farrell, Troy
Maybe you need an ORDB (Object-Relational DB) like postgresql. PGSQL supports Inheritance: http://www.postgresql.org Troy -Original Message- From: Luciano Ramalho [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 6:12 AM To: Tom Deprez Cc: Rik Hoekstra; [EMAIL PROTECTED]

RE: [Zope] Opensource DBMS for WIN?

2001-01-23 Thread Farrell, Troy
PostgreSQL compiles on Win32, but only under RedHat's(formerly Cygnus') Cygwin Unix Compatibility Layer. http://www.postgresql.org http://people.freebsd.org/~kevlo/postgres/portNT.html MySQL, the newly GPL'd version, was declared stable yesterday. http://www.mysql.com SapDB is to be open-sourced

RE: [Zope] Is it possible to make a thumbnail from an added image..?

2001-01-24 Thread Farrell, Troy
You could use the Python Imaging Library with some external methods: http://www.pythonware.com/products/pil/index.htm dtml-var typical_open_source_hint_hint_hint Troy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 24, 2001 8:19 AM To:

RE: [Zope] DNS/access problems

2001-01-25 Thread Farrell, Troy
What browser are you using? Netscape 6 (I'm on NT4) has a nasty habit of remembering (or not remembering) ports associated with addresses. When I run Zope 2.2.5 on port 80 and 2.3.0b? on port 9000, and access the first as http://localhost and the second on http://localhost:9000, Netscape 6

RE: [Zope] How to make broken images/links broken!

2001-01-25 Thread Farrell, Troy
I will try, although I don't completely understand your problem. Instead of refering to your images with html, try using dtml. This requires that the images are Zope Image Objects. Try this: dtml-if expr="images.myimage.jpg" dtml-var expr="images.myimage.jpg" /dtml-if That will place the