[Zope-dev] Newbie SQL Question

[Christopher Petrilli]

On 10/10/00 11:33 AM, "Yvonne Totty" <ytotty@atinucleus.com> wrote:

> HI!
> 
> I am having a slight newbie problem and for the life
> of me cannot find any references for how to do it.
> 
> I have input boxes on a page. I want the information
> from that box to be input into a database table upon
> clicking the Submit button.
> 
> I cannot figure out how to get that information from
> point 'A' to point 'B'.

Assuming your form has a field named the same as all of columns you want to
insert (i.e. Foo, bar, whatever)... Then you can have it post to another
method that has a line like this in it:

    <dtml-call name="sqlInsertValues">

And then have a SQLMethod called 'sqlInsertValues' that has a body like
this:

    INSERT INTO mytable (
        column1,
        column2,
        column3 ) VALUES (
        <dtml-sqlvar name="column1" type=string>,
        <dtml-sqlvar name="column2" type=int>,
        <dtml-sqlvar name="column3" type=string> )

Remember to put these in the arguments list, or they won't be caught from
the REQUEST namespace.

Chris 

-- 
| Christopher Petrilli                                     Digital Creations
| petrilli@digicool.com                                Where Zope comes from