The way I do this: I have a table called lookups that is essentially a dictionary with key-value pairs grouped according to category. For Example: category=animals lookup=12 value=cat category=animals lookup=14 value=dog category=animals lookup=18 value=mouse sql statement "anilookup": select lookup,value from lookups where category='animals' order by value In your form: (field name in data table (not lookup) is anichoice) <dtml-in SqlSelectForCurrentDataRecord> <select name="anichoice" size =1> <option value=0 <dtml-if "anichoice==0">selected</dtml-in>>None Selected</option> <dtml-in anilookup> <option value="<dtml-var lookup>" <dtml-if "anichoice==lookup">selected</dtml-in>><dtml-var value></option> </dtml-in> </select> </dtml-in> __________________________________________________________________ Jim Sanford . Database Engineer / \ / Accelerated Technology, Inc. / / 720 Oak Circle Drive East / / \ Mobile, AL 36609 / / \ Voice: 334-661-5770 fax: 334-661-5788 / \ E-Mail: jsanford@atinucleus.com Web: http://www.atinucleus.com Source Code, No Royalties, Any CPU...It just make sense ! __________________________________________________________________ ----- Original Message ----- From: Martijn Faassen <faassen@vet.uu.nl> To: <darryl@igor.penguinpowered.com> Cc: <zope@zope.org> Sent: Friday, January 07, 2000 3:48 PM Subject: Re: [Zope] Zope and Data Entry darryl@igor.penguinpowered.com wrote:
I am designing a site which will be used for a lot of data entry. I have zope 2.1.2 and mysql talking nicely. Now my problem is design.
I want the user to be able to fill in a form using some HTML select fields, these fields should then be translated into their respective item IDs for input into my table. So even though the user chooses:
cat dog mouse
the sql final method should be:
insert into table animals (cID, dID, mID) values (12, 14, 18)
In a CGI, I would use a python dictionary or perl hash to translate the keys into their values before makeing. But I'm a little stumped with zope? Should I handle this with an external method or can I do it with straight sql methods and built-ins?
You may want to look at my ZFormulator product. You could make a new field type in it that does this. You can also do it with external methods or even with DTML; you can do things like: REQUEST.set("cID", {'cat': 10, 'dog': 11}[cID]) before you pass REQUEST along to a zsql method. Regards, Martijn _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )