[Zope] Embedding SQL Forms into DTML Methods

[Derek Basch]

Ioan,
The new version seems great. Documentation is done
very well. 

Here is where I am still stuck though. It's a long
one.

Under "How To Include" in the help instructions you
give directions for embedding the generated methods
into other DTML Documents/Methods. I have a SQL Form
named 'contacts_manager' in the Contacts folder that I
am calling from a DTML Method in the Contacts folder
like this:

<dtml-var "Contacts.contacts_manager.list(_.None,_)">

So as I understand it, you are passing a None value
and the current namespace to the generated list
method. In this case 'contacts_manager.list'. When I
use <dtml-var> to call the list method I get a
'KeyError:table_cell_spacing' error. I looked at the
list method and found that it is indeed asking for a
'table_cell_spacing' variable at line 18.

I added a <dtml-with "Contacts.contacts_manager.list>
surrounding the <dtml-var> which pushed
table_cell_spacing into the namespace. After I did
this I could view the page with the list method
embedded. So far, So good.

Now, If click on the 'List','Add', or 'Edit'(key
field) links it tries to open:

http://localhost:8080/Test/Contacts/(list,add,edit)

The links should point to:

http://localhost:8080/Test/Contacts/contacts_manager/list,add,edit)

It seems to me that the generated methods are only
configured to be called directly. The generated add,
list, and edit links point to the container of the
DTML Method that they are embedded in. In other words,
the links expect an SQL Form to be their container.

Am I correct? Sorry this is so long, but you asked for
my input :)

Thanks for all the help,
Derek Basch
 

--- Ioan Coman <ioan2k@yahoo.com> wrote:
> Hi!
> 
> I'm alive and I released version 3.1
>
http://www.zope.org/Members/Ioan/SQLForms/SQLForms.zip/view
> 
> Tell me what you think!
> (Contain your observation about maxlength
> and a full new documentation)
> 
> Ioan.
> 
> --- Derek Basch <dbasch@yahoo.com> wrote:
> > Ioan,
> > Are you alive? Did you get my previous letters? I
> > could use your help. I am stuck on a few things
> with
> > SQLForms.
> > Thanks,
> > Derek Basch
> > 
> > --- Ioan Coman <ioan2k@yahoo.com> wrote:
> > > > Ioan,
> > > > Yes I did get the SQLFormsDemo, but what I
> dont
> > > > understand is how the demo is supposed to work
> > > > without a database to support it?
> > > After you download
> > >
> >
>
http://www.zope.org/Members/Ioan/SQLForms/SQLFormsDemo.zexp
> > > and import it into Zope you'll get te demo
> folder!
> > > 
> > > Into demo folder there is 'db1' - a database
> > > connector
> > > (mine is ODBC, yours could be mysql, postgres,
> > > oracle,
> > > ...)
> > > 
> > > Erase 'db1' and create your own, then update SQL
> > > forms
> > > object named 'all'!
> > > 
> > > 
> > > SQL Forms reporter is not compatibile with 
> > > version 3.x of SQL Forms!
> > > '%LIKE%' should not exist into generated
> method!!!
> > > 
> > > 
> > > I don't have time right now to write doc for
> > > SQL Forms; then I have to rewrite SQL Forms
> > > Reporter.
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > Import 
> > >
> >
>
http://www.zope.org/Members/Ioan/SQLForms/SQLFormsDemo.zexp
> > > 
> > > Do you know how to import it?
> > > Save file 'SQLFormsDemo.zexp' into Zope folder
> > named
> > > 
> > > 'import'
> > > Then go on zope web management interface,
> > > create a new folder and use button
> 'Import/Export'
> > > and then fill box 'Import file name' with
> > > 'SQLFormsDemo.zexp'
> > > 
> > > 
> > > 
> > > Tell me how the demo is working!
> > > 
> > > Ioan.
> > > 
> > > 
> > > 
> > > 
> > >
> __________________________________________________
> > > Do you Yahoo!?
> > > New DSL Internet Access from SBC & Yahoo!
> > > http://sbc.yahoo.com
> > 
> > 
> > __________________________________________________
> > Do you Yahoo!?
> > New DSL Internet Access from SBC & Yahoo!
> > http://sbc.yahoo.com
> 
> 
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com