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?
<CUT> I might not understand your question right, but can't you just use the value attribute of the OPTION element in html (the OPTION element used with SELECT and the one you probably is using at the moment)? (http://www.w3.org/TR/1999/REC-html401-19991224/interact/forms.html#h-17.6). Then return selections as a list:int all the way into a ZSQL Method which takes list:int as argument. Sorry to step on your toes if I'm talking down to you. -- Best regards / Mvh., Steen Suder, sysadm kollegie6400.dk -|- OpenSource --- Sign of the time Scan-Aqua ADVARSEL WARNING http://www.uk.k64.dk/sfs/Scan-Aqua/