Seb:
Does anybody have a good suggestion how to develope SQL Method ftfs (through the filesystem) rather than ttw.
Perferably in someway similare to the HTMLFile way
try something like this:
from Products.ZSQLMethods.SQL import SQL import PoPy
def manage_add_user(self,email,password):
conn = 'PoPy_database_connection' self.sql_add_user=SQL('sql_add_user', '', conn, 'email password', _sql_add_user)
_sql_add_user = """ insert into tbl_users(email,password) values ( <dtml-sqlvar email type=string>, <dtml-sqlvar password type=string> ) """
Hi Seb, I guess I could skip putting it in a method and create the SQL instance as a attribute of the class (that I currently would be working on)? Why do I need to import the database module? Couldn't I just try to locate/create a DA when my class is instantiated? Would it be poor design to create a DA connection as an attribute of the class? Or would it be perferd to create it in the __init__ as a instance attribute? Thanks, Johan