[Zope] Writing to SQL Databases

Graham Chiu anon_emouse@hotmail.com
Tue, 20 Jul 1999 08:24:04 +1200


In article <BEF0F85DF631D311B1200000F80932F9249979@crchy28c.us.nortel.co
m>, Sean McMains <smcmains@nortelnetworks.com> writes
>ID: addEntry
>Arguments: nameField emailField maidenField yearField websiteField
>
>Query Template:
>insert into alumDirectory
>(ALUMNAME,
> ALUMEMAIL,
> ALUMMAIDEN,
> ALUMYEAR,
> ALUMWWW
>) 
>values 
>(<!--#sqlvar nameField type=string-->,
> <!--#sqlvar emailField type=string-->,
> <!--#sqlvar maidenField type=string-->,
> <!--#sqlvar yearField type=string-->,
> <!--#sqlvar websiteField type=string-->
>)
>
>I've verified that this template works when I use the TEST function. But
>when I try to call it:
>
><!--#call addEntry.manage_test(REQUEST)-->
>
>I don't get an error, but neither do I get the data inserted as it should
>be. I've also included this code:
>
>Name:<!--#var nameField--><BR>
>Year:<!--#var yearField--><BR>
>E-Mail:<!--#var emailField--><BR>

<!--#var nameField(nameField=formvar1, emaiField=formvar2, ... )-->


-------
Regards,        Graham Chiu
gchiu<at>compkarori.co.nz