[Zope] Non-query SQL with Zope (naive question)

[Bruce Elrick]

Martijn Pieters wrote:
> 
> What problems have you run into when you tried?
> 
> ZSQL methods support all SQL your database supports, including updates,
> inserts and deletes. When I install a Zope server elsewhere, that uses a
> database, I include the table create statements as well. Just run one DTML
> method, and the whole database is set up.
> 
...
Thanks Martijn...
It would appear that I was too quick to think I failed.  When you test the
output screen states the "This is not a query".  After getting errors earlier
due to malformed SQL, I assumed this was an error too.  I was expecting
something along the lines of what the command line would give, like
"Inserted 1", indicating that I was successful.  Live and learn.

Thanks again for clearing that up.

By the way, in your message you showed this way of calling the SQL Method:

   <!--#call "insertNewContact(name='Martijn Pieters', 
email='mj@antraciet.nl')"-->

Is that equivalent to the browser doing 
http://site.com/path/to/method/insertNewContact?name=Matin+Pieters?email=mj@antraciet.nl

when you create a form that has the method as an action?

Cheers...
Bruce
--
Bruce Elrick, Ph.D.                       Saltus Technology Consulting Group
Cell:     (403) 870-4429
Personal: belrick@home.com                          IBM Certified Specialist
Business: belrick@saltus.ab.ca          ADSM, AIX Support, RS/6000 SP, HACMP