[Zope-DB] Help needed with multi-table insert form

[Norman Khine]

thanks martin,
i've got it working, by changing the resellerAdd.dtml method to

<dtml-call "sql_INSERT_form(
           business_name=business_name,
           business_url=business_url,
           business_type_id=business_type_id,
           street_name=street_name,
           town=town,
           city=city,
           postcode=postcode,
           county_id=county_id,
           title=title,
           initials=initials,
           fname=fname,
           surname=surname,
           telephone=telephone,
           fax=fax,
           email=email,
           regdate=regdate,
           status =status ,
           job_function_id=job_function_id
)">

but i would like to know how to do this using the REQUEST object via a
python script.

please advise.

thanks
----- Original Message -----
From: "Martin Gebert" <Murphy@members.netsolution-net.de>
To: "Norman Khine" <norman@khine.net>
Cc: <zope-db@zope.org>
Sent: Wednesday, January 22, 2003 7:11 PM
Subject: Re: [Zope-DB] Help needed with multi-table insert form


>
>
> Norman Khine wrote:
>
> > and resellerAdd.dtml DTML Method, which contains the following:
> >
> > <dtml-call sql_INSERT_form>
> > <h2>Customer <dtml-var name="business_name"> was added.</h2>
> >
> > everytime i add submit, the server returns nothing .....
>
> Well, you have to pass the form parameters (available via the REQUEST
> object) to your SQL Method. You should use a Python script for that;
> please read the appropriate chapter in the Zope book for that...
>
> Martin
>
>