[I moved this thread to the zope list]
Hello: Thanks a lot for provide me useful information.
YOu're welcome
Can you give me a example?
Hm, perhaps you should read the ZSQL Guide, if you haven't already <URL: http://www.zope.org/Documentation/Guides/ZSQL> Probably it contains much of what you want to know right now. Giving an example out of the blue is a bit inefficient. Perhaps you could be a bit more specific as to what you try to accomplish
I can only do like this,And donnot know what fields I can edit...
Your database connection (usually) let's you browse the structure of your database (that is, the tables). THere you can find how your fields are called.
""" select * from testable where name = <dtml-sqlvar name type=string> """ Thanks in advance. Victor zhai.