[Zope] Error calling a Z SQL method

[Asad Habib]

Well, I have to specify the folder that contains the Z SQL method so your
code won't work with my structure. I appreciate your input. Thanks.

- Asad


On Thu, 24 Mar 2005, Cliff Ford wrote:

> This looks wrong to me, even if you have used it before. I would use the
> query like this:
>
> <dtml-in retrieve_data_sql>
> <dtml-var Column1> <dtml-var Column2> <br>
> </dtml-in>
>
> The REQUEST object is available to the ZSQL Method so you don't need to
> pass it explicitly. And you don't really need two DTML thingies - one
> will do.
>
> HTH
>
> Cliff
>
> Asad Habib wrote:
> > I am calling a Z SQL method from within a DTML method that is called by a
> > DTML document. The Z SQL method is contained within a folder called
> > 'selects'. The error I get is as follows:
> >
> > Error Type: ValueError
> > Error Value: Strings are not allowed as input to the in tag.
> >
> > The following is the syntax I use to call the DTML method from the DTML
> > document:
> >
> > <dtml-call "initialize_parameters(REQUEST, _)">
> >
> >
> > And, the following is the code I use to call the Z SQL method (i.e.
> > retrieve_data_sql) from within the DTML method (i.e.
> > initialize_parameters):
> >
> > <dtml-in "selects.retrieve_data_sql()">
> > </dtml-in>
> >
> >
> > I have used this same piece of code in other places without a problem. Any
> > help would be greatly appreciated. Thanks.
> >
> > - Asad
> > _______________________________________________
> > Zope maillist  -  Zope at zope.org
> > http://mail.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://mail.zope.org/mailman/listinfo/zope-announce
> >  http://mail.zope.org/mailman/listinfo/zope-dev )
>