[Zope] Displaying SQL results correctly
dieter at handshake.de
Thu Nov 25 14:37:02 EST 2004
Dean Hale wrote at 2004-11-25 11:13 +0000:
>I'm extracting content from a database which contains several numbers
>for example 72, 354. Each number is separated by commas. The numbers
>correspond to other id's within the table.
>I'm using below which kind of works however the url is specified as
Note that the use of "%20" (this is a blank) is forbidden
in query strings. In query strings, blank must be coded as "+".
>CourseLike is the field which corrospond to other ID's - 72, 354
>CourseTitle is the course title
><a href="" tal:define="CourseLike result/CourseLike"
> goes here</span></a>
>i'd like each id to be repeated separately rather than in the one long
I have problems to understand what you want...
When you repeat the ids separately, the URL will become longer...
Repeating separately would look like:
repeatedIds python:'&'.join(['id:list=%s' % id for id in ids]);
The code above assumes that "result/CourseLike" returns a
sequence of ids. If instead it returns a string, it will
need to be split at its element separator (apparently ", ") to
obtain a list of ids.
More information about the Zope