[ZDP] BackTalk to Document The Zope Book (2.5 Edition)/Relational Database Connectivity
Tue, 01 Oct 2002 00:20:02 -0400
A comment to the paragraph below was recently added via http://www.zope.org/Documentation/Books/ZopeBook/current/RelationalDatabases.stx#3-85
Zope provides a special URL syntax to access ZSQL Methods that
always return a single result. The URL consists of the URL of
the ZSQL Method followed by the argument name followed by the
argument value. For example,
*http://localhost:8080/employee_by_id/emp_id/42*. Note, this URL will
return a single result object where as if you queried the ZSQL
Method from DTML and passed it a single argument it would return
a list of results that happend to only have one item in it.
% Anonymous User - Sep. 28, 2002 8:05 am:
/where as if/as if/ blf sorry for prev paragraf comment, should be here
% Anonymous User - Sep. 28, 2002 8:10 am:
- With ZSQL Methods that do return more than one result you mean that the Result object is a table?
- is the special url syntax also possible w several argument values?
% Anonymous User - Oct. 1, 2002 12:06 am:
When I try this sort of thing in Zope 2.5.1, I get the error:
The object at http://myurl/update_person_by_id/id/9 has an empty or missing docstring. Objects must have a
docstring to be published.
What do I do about this? For ZSQL Methods that have a single argument, I can select 'simple direct traversal'
and leave out the variable name, and everything's ok. Is it something about the variable name 'id'? Or what?
% Anonymous User - Oct. 1, 2002 12:20 am:
Ok, there *is* something special about 'id' (probably because it's a DTML variable in the namespace). If I
change to person_id, I get a new error "The requested resource does not exist". Hmm.