[Zope] Zope and Data Entry

[Jim Sanford]

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 )