[Zope] Displaying SQL results correctly

Dean Hale dean.hale at sunderland.ac.uk
Thu Nov 25 06:13:07 EST 2004


Hi

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

http://157.228.32.93:9191/education/nug_db/detail_html?id=72,%20354

and i'm using below to get the results

CourseLike is the field which corrospond to other ID's - 72, 354
CourseTitle is the course title

<a href="" tal:define="CourseLike result/CourseLike" 
tal:attributes="href
string:detail_html?id=$CourseLike" tal:content="result/CourseTitle" 
target="_blank">
<span tal:replace="result/CourseTitle">CourseTitle
         goes here</span></a>

i'd like each id to be repeated separately rather than in the one long 
url.

Any help appreciated.

Thanks very much
dean

---------------
Dean Hale

Web Development Manager
Information Services

University of Sunderland

w: http://www.library.sunderland.ac.uk

t: +44 (0) 191 515 2424
f: +44 (0) 191 515 2904



More information about the Zope mailing list