> inserts to a variable, say x1, into a postgresql table.
> However, there is an additional variable, x2 that would
> have to be only entered once and would be the same for
> every record for which a different x1 is entered.
> it seems the <dtml-in> should do this.
Assign the variable x2.
Create a list of all the x1 variables. This step could be
a sql method, if the variables already exist in a table.
Assign the value of sequence-item to variable this_x1.
Create a sql method to execute the inserts, and call it
from within the first sql method, called using <dtml-in>.
Be sure to include "arguments" this_x1, x2.
So, altogether now:
The <dtml-in> statement retrieves the cursor, calling the
sql_insert for each item (sequence-item).
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -