Alas, neither of these options works. <!--#call addEntry(REQUEST)--> just does the same thing as my original format. No error, but no change to the database. <!--#call addEntry(REQUEST=REQUEST)--> when I try to submit the change gives me this error: Invalid attribute name, "addentry(request", for tag <!--#call addEntry(REQUEST=REQUEST)--> Any other ideas? Anybody have any samples I can look at that take the results of a form and put them into a SQL database? Thanks Ross et al, Sean

-----Original Message----- From: Ross J. Reedstrom [SMTP:reedstrm@wallace.ece.rice.edu] Sent: Monday, July 19, 1999 1:07 PM To: McMains, Sean [RICH4:2V64:EXCH] Cc: 'zope@zope.org' Subject: Re: [Zope] Writing to SQL Databases

On Mon, Jul 19, 1999 at 11:32:01AM -0400, Sean McMains wrote:

...

Hi folks,

I've been working with Zope for a month or two now off and on, trying to figure out how to port several of my existing websites to Zope, since it will make my life much easier and more pleasant. (I really am impressed with the work you've done, DC folks! Great job!)

One area that's giving me fits right now is inserting data into a SQL Database. By working with the existing documentation and sample code, I've gotten database connections set up and templates built, but am missing something at the insert phase.

Here's the template I'm using:

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)-->

<!--#call addEntry(REQUEST)-->

or perhaps

<!--#call addEntry(REQUEST=REQUEST)-->

should do it.

Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005