[Zope] Re: Insert Help

Mon, 25 Feb 2002 08:53:14 -0500

--=====================_3423723==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

Dieter:

Could you explain a little more I still seem to be trying to input 
everything all on one record. I need to break out in an array then each 
needs to be added to the database as a separate record. Maybe I missed 
something.

Thanks,
Todd

Todd Loomis writes:
 > I want to insert to a database a id and a option, however each id can have
 > more than one option. And I want them inserted separately to make 2
records.
 >
 > The form will be checkboxes they check all the options they want and they
 > all get save in the database seperately but with the same id. I've tried to
 > no luck. Can anybody help?
Some basic observations:

ZSQL Method bodies are DTML objects. You use DTML there to generate
SQL in the same way you use DTML usually to generate HTML.
Especially, you have the "dtml-in" in order to iterate over
sequences.

A ZSQL Method can generate and execute several SQL commands.
These commands need to be separated by "<dtml-var sql_delimiter>".

Thus, you use something like:

<dtml-in options>
insert into ...
<dtml-unless sequence-end><dtml-var sql_delimiter></dtml-unless>
</dtml-in>

You need to be a bit careful with your options in the form.
It should probably contain something like:

<input type="hidden" name="options:list" value="dummy">
...
<input type="checkbox" name="options:list" value="...">
...

The hidden variable ensures that you always get something for options.
The ":list" ensures that the case of a single option leads to a list
as well as multiple options.
When you use the hidden variable approach as shown above, then
your options list contains a bogus first element. You need to drop
it again. The "dtml-in options" above becomes 'dtml-in expr="options[1:]"'.

Dieter

_______________________________________________
Zope maillist - Zope@z...
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 )

--=====================_3423723==_.ALT
Content-Type: text/html; charset="us-ascii"

<html>
Dieter: 
 
Could you explain a little more I still seem to be trying to input
everything all on one record. I need to break out in an array then each
needs to be added to the database as a separate record. Maybe I missed
something. 
 
Thanks, 
Todd 
 
Todd Loomis writes: 
&gt; I want to insert to a database a id and a option, however each id
can have 
&gt; more than one option. And I want them inserted separately to make
2 
records. 
&gt; 
&gt; The form will be checkboxes they check all the options they want and
they 
&gt; all get save in the database seperately but with the same id. I've
tried to 
&gt; no luck. Can anybody help? 
Some basic observations: 
 
ZSQL Method bodies are DTML objects. You use DTML there to generate 
SQL in the same way you use DTML usually to generate HTML. 
Especially, you have the &quot;dtml-in&quot; in order to iterate
over 
sequences. 
 
A ZSQL Method can generate and execute several SQL commands. 
These commands need to be separated by &quot;&lt;dtml-var
sql_delimiter&gt;&quot;. 
 
Thus, you use something like: 
 
&lt;dtml-in options&gt; 
insert into ... 
&lt;dtml-unless sequence-end&gt;&lt;dtml-var
sql_delimiter&gt;&lt;/dtml-unless&gt; 
&lt;/dtml-in&gt; 
 
You need to be a bit careful with your options in the form. 
It should probably contain something like: 
 
&lt;input type=&quot;hidden&quot; name=&quot;options:list&quot;
value=&quot;dummy&quot;&gt; 
... 
&lt;input type=&quot;checkbox&quot; name=&quot;options:list&quot;
value=&quot;...&quot;&gt; 
... 
 
The hidden variable ensures that you always get something for
options. 
The &quot;:list&quot; ensures that the case of a single option leads to a
list 
as well as multiple options. 
When you use the hidden variable approach as shown above, then 
your options list contains a bogus first element. You need to drop 
it again. The &quot;dtml-in options&quot; above becomes 'dtml-in
expr=&quot;options[1:]&quot;'. 
 
 
Dieter 
 
_______________________________________________ 
Zope maillist - Zope@z... 
<a href="http://lists.zope.org/mailman/listinfo/zope" eudora="autourl">http://lists.zope.org/mailman/listinfo/zope 
</a>** No cross posts or HTML encoding! ** 
(Related lists - 
<a href="http://lists.zope.org/mailman/listinfo/zope-announce" eudora="autourl">http://lists.zope.org/mailman/listinfo/zope-announce 
</a><a href="http://lists.zope.org/mailman/listinfo/zope-dev" eudora="autourl">http://lists.zope.org/mailman/listinfo/zope-</a><a href="http://lists.zope.org/mailman/listinfo/zope-dev" eudora="autourl">dev</a>
) 
</html>

--=====================_3423723==_.ALT--