[Zope] question about forms and zsql

[Robert Hood, Ph.D.]

So far I'm enjoying zope.  I've rewritten several sites using it, and think 
it will make my work more efficient.  One of my older sites stores material 
in database.  I'm probably going to put everything in zope eventually, but 
for now I just want to improve the search on a (small MS Access) database.

So I now use zope to communicate with the database, and have created a form 
to search it, though at the moment my form is limited to exact 
matches--e.g., if you search on "Environmental Ethics" you'll get a result, 
but not if you search "Ethics."

In sql you can use LIKE %name% to let people search more flexibly.

So how do I pass the %name% from the form to the method?  Do I make the 
change to the form, or to the zsql method?

if the form has a field like:
<input type="text" name="CourseName" size=20>

and the zsql method is:
SELECT * FROM Courses
WHERE
(CourseName LIKE <dtml-sqlvar CourseName type=string> OR
SemesterTaught LIKE <dtml-sqlvar SemesterTaught type=string> OR
CourseType LIKE <dtml-sqlvar CourseType type=string> )

btw, the site is:
http://appliedphilosophy.mtsu.edu/syllabusproject/index.html

thanks,

Robert