[Zope] sql query results - DTML method problem
Hi, I have a TINY problem, which I think there is a simple solution too... but for the life of me, I can't find it! I'd be grateful if someone could point me in the right direction. I have a database setup containing details of classes, students lecturers. The user is prompted to enter a class code (a unique key) which is used to query the database and return the class title. Simple. A DTML method prompts me for the class code -- I enter 52.139 and it posts to a method 'enterClassCodeAction', below. #1 dtml-var standard_html_header #2 h2Confirm/h2 #3 pYou entered idtml-var class_code/i/p #4 #5 p #6 Our records show that dtml-var class_code is called #7 #8 dtml-in expr="findClassTitle(code=52.139)" #9 dtml-var title #10 /dtml-in #11 #12 #13 /p #14 dtml-var standard_html_footer ^ The method works fine when the class code is manually inserted (line #8) but when I try to pass the variable from the previou post, held in dtml-var class_code I have probs. dtml-in expr="findClassTitle(code=dtml-var class_code)" *** syntax error findClassTitle is a ZSQL method for returning the class title given a class code: select title from classes where dtml-sqltest code op=eq type=float Hmm... anyone see the problem? Thanks a lot :) - Best regards, Lee ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] Re: sql query results...
It's okay folks - I figured it out. I believe that it was Homer Simpson who once said, "Doh!". Cheers, Lee ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] footer
/td/tr/table/center /font/td /tr tr td width="9%" bgcolor="#3D4E93" height="9"nbsp;/td td bgcolor="#3D4E93" colspan="2" height="9" div align="right"font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#FF"Written by Lee Reilly/font/div /td /tr /table /body /html ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] mySQL DA on Win32
Hi, Zope is currently being installed on the Unix machines at my uni but it won't be available for a while. However, I have set up a mySQL database in the Dept. and installed Zope on a Dept. machine (Windows 95). I can only access the database from uni so I must have a database adpater setup on this machine. I have seen the mySQL DA on Zope.org but I understand that it "does not support win32 platforms at this time". I need database access ASAP so can anyone offer any advice? Thanks very much, Lee ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] [ot] python book
Hi, I'm going through the tutorials available on Python.org but can anyone recommend a good book? I've always been impressed by O'Reilly's books and I see that there are a number of them available: - Python Programming on Win32 - Learning Python - Programming Python Which one of the above (or indeed, any others) would be best for me? Me? I've got some C experience and will be using Python with Zope to create a portal, some simple apps. Any advice would be greatly appreciated. - Best regards, Lee ___ Zope maillist - [EMAIL PROTECTED] http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] python methods
Hi,
I'm having problems with Python methods. I've followed the instructions
for the guestbook example [1] to the letter but when I add the Python
method [2] is causes an error as follows:
Error Type: NameError
Error Value: context
TraceBack: Traceback (innermost last): File
/usr/local/Zope-2.1.6-src/lib/python/ZPublisher/Publish.py, line 165, in
publish File
/usr/local/Zope-2.1.6-src/lib/python/ZPublisher/mapply.py, line 160, in
mapply (Object: addEntryAction) File... etc.
Can anyone offer any advice?
- Best regards,
Lee Reilly
[1] http://www.zope.org/Members/michel/ZB/SimpleExamples.html
[2] Python method
"""
Create a guest book entry.
"""
# create a unique document id
id='entry_%d' % len(context.objectIds())
# create the document
context.manage_addProduct['OFSP'].manage_addDTMLDocument(id,
title="", file=comments)
# add a guest_name string property
doc=getattr(context, id)
doc.manage_addProperty('guest_name', guest_name, 'string')
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
[Zope] chapter 5 Zope book - problems with the examples
Hi,
I'm going through the examples in Chapter 5 of the Zope book and am
having some problems. For those of you familiar with it, it is the 'Zope
Zoo' example.
Can anyone help me out?
1 - I create a DTML method called navigation as follows:
ul
dtml-in expr="objectValues('Folder')"
lia href="dtml-absolute_url;"dtml-var title_or_id/abr/li
/dtml-in
/ul
2 - On viewing this method it works fine - a hyperlink to all
sub-folders appears in the browser.
3 - I add 'dtml-var navigation' into my standard_html_header so it
reads:
html
head
titleZAPHOD - zopetastic!/title
font face="Verdana, Arial, Helvetica, sans-serif" size="2"
/head
body bgcolor="#FF" LINK="#99" VLINK="#55"
pfont face="Verdana, Arial, Helvetica, sans-serif" size="1"
If your name is Lee then click a href="manage"here/a to
login./font
br
dtml-var navigation
4 - On viewing index.html (containing header footer) everything except
the navigation method appears. Viewing the source of index.html reveals
that the ul tags are created... just no li elements.
5 - The HTML is fine... all tags closed in te right place.
Can anyone see a problem?
Thanks in advance for any replies. My appologies also for such a long
post.
- Best regards,
Lee Reilly
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
