Hi, I feel I've managed to get a grip on search query's through web interfaces, but I can't find any documentation to show me how to setup a web page that will allow me to use an sql method with the 'INSERT INTO' string so that I can insert data into my database. Can anyone offer any documentation links or tell me how to do this ? Thanks
I feel I've managed to get a grip on search query's through web interfaces, but I can't find any documentation to show me how to setup a web page that will allow me to use an sql method with the 'INSERT INTO' string so that I can insert data into my database.
Can anyone offer any documentation links or tell me how to do this ?
The Z SQL Methods User's Guide http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.html This shows you everything you need to know to do things the Zope way. It assumes you have a basic understanding of HTML forms and the SQL language. -jfarr
In general the process is: - create a database adapter - create a zsql method to do the insert - create an html form to submit the data - create a dtml method to call the zsql method as the form's submit action Here's a pretty good how-to that describes the entire process in detail. http://www.zope.org/Members/jshell/ZSQLMethods-InsertingData I find these pages to be an essential reference for zsql: Creating SQL database methods http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.2.html Query templates http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.4.4.html This section covers some more advanced usage of zsql methods: Database Method Document Template Markup Language Tags http://www.zope.org/Documentation/Guides/ZSQL-HTML/ZSQL.1.5.html Hope this helps! -jfarr
participants (2)
-
Jonothan Farr -
M. Richardson