[Zope] Zope and Data Entry

[Steen Suder]

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/