Somewhere there is some decent documentation but I dont have that ref handy at the moment. The way I understand the records to work is this: In the form, your input tages need to be as so: <input type="text" name="item.a:records:required"> - required bit is superfluous. In the the dtml, you need to call the ZSQL method.... <dtml-if "REQUEST.has_key('Submit')"> <dtml-call submitFormZSQLMethod> </dtml-if> - note there are no parameters passed through this... It doesnt seem to work if you do that... I've tried with no success. In the submitFormZSQLMethod... The parameters passed in are : item:records then the ZSQL method: <dtml-in item> insert into table yaddayadda (a, b, c) values ( <dtml-sqlvar a type=string>, <dtml-sqlvar b type=string>, <dtml-sqlvar c type=string> ) <dtml-var sql_delimiter> </dtml-in> - you are naming all inputs as an class called 'item', and specifiying that they are 'records'. You need the dtml-in because 'records' implies of course more than one, so the REQUEST will show item.a = something item.b = something else and so on - I dont know if you can do this from a Filemaker form because I don't see how the item iteration would work into the Zope namespace... .but Im not the one top ask about that. ... I;m only showing what I know, which aint that much... Paz -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Chris Beaumont Sent: Sunday, April 15, 2001 10:49 AM To: zope@zope.org Subject: [Zope] Need help with ':records' form construct Hello, I'm hoping that one of you can help me out with the not-very-well-documented ' :records ' form construct. I have a long form which contains information from around 100 separate database records.. This is being sent into Zope from a FileMaker form.. Its displayed in a long Zope form (it displays properly...) and edited.. and then I'm hoping to submit it from Zope and use the information to populate a SQL database via a ZSQL method.. I've tried two different ways to get it into my database, both iterating through the results and calling the SQL method on each iteration, and also doing my dtml-in in the ZSQL method itself. Neither have worked.. The ZSQL documentation doesn't give much to go on.... so I'm hoping some of you can give me some pointers.. The data is mixed strings and integer data, but that shouldnt be a problem.. When I point the forms action at a method with simply <dtml-var REQUEST> in it, I see that it appears that the data is being concatenated together.. Is this what is supposed to be happening? Any ideas or suggestions on how to make this work are welcome.. -Chris This is the first part of the form and then the <dtml-var REQUEST> output.. ___cut here________ <input type="hidden" NAME="sqlinput.PERS_FMPID:records" value="&dtml-PERS_FMPID;"> <TR><TD ALIGN="RIGHT">Last Name</TD><TD><INPUT TYPE="TEXT" NAME="sqlinput.PERS_LNAME:records" value="&dtml-PERS_LNAME;"></TD></TR> <TR><TD ALIGN="RIGHT">First Name</TD><TD><INPUT TYPE="TEXT" NAME="sqlinput.PERS_FNAME:records" value="&dtml-PERS_FNAME;"></TD></TR> <TR><TD ALIGN="RIGHT">Person Type</TD><TD> submit Process sqlinput [PERS_AFFILIATION: , PERS_ARRIVALDATE: , PERS_DEPARTDATE: , PERS_EMAIL: alperin, PERS_FMPID: 33133, PERS_FNAME: Roger, PERS_LNAME: Alperin, PERS_OFFICE: , PERS_TYPE: gm, PERS_AFFILIATION: , PERS_ARRIVALDATE: , PERS_DEPARTDATE: , PERS_EMAIL: andersen, PERS_FMPID: 33179, PERS_FNAME: Jorgen, PERS_LNAME: Andersen, P _______________________________________________ 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 )