[Zope] dtml / zsql datatype problem

[Adam Gotheridge]

got it... i set the variable and then called the sql without a parameter
like:

<!--#call "REQUEST.set('milestoneid',milestoneid)"-->
<select name=Selmilestoneid>
<dtml-in getMilestones>



----- Original Message -----
From: Adam Gotheridge <adam@foxvalley.net>
To: Chris McDonough <chrism@digicool.com>
Cc: zope <zope@zope.org>
Sent: Wednesday, December 01, 1999 11:50 PM
Subject: Re: [Zope] dtml / zsql datatype problem


> Thanks, but I still can't get it. I basically am retrieving a record from
a
> db (dtml-in), and when I get to a field where I need to display  as a
select
> box, I issue a second request to get records from another table. If I
single
> out the code pertaining to the select box and then set a variable
manually,
> I can call it like this:
>
> <!--#call "REQUEST.set('milestoneid',45)"-->
> <select name=Selmilestoneid>
> <dtml-in getMilestones>
>       <OPTION value='<dtml-var retmilestoneid>'><dtml-var
> retmilestone_name></OPTION>
> </dtml-in>
> </select>
>
> but... <dtml-in "getMilestones(milestoneid)"> doesn't work even here (I
> can't add the variable argument).
>
> There are other weird things as well. If I call the sql object as a string
> like
> <dtml-in "getMilestones(milestoneid='<dtml-var milestoneid>')"> and change
> the sql method to accept a string, the dtml document succeeds, but oracle
> returns an error about an invalid datatype. The odd thing is that when I
> test the sql method with a string, '54' (with quotes), it succeeds.
>
> Any other ideas?
>
> Adam
>
>
>
>
> > You can't use DTML inside of DTML...
> >
> > try:
> >
> > <dtml-in "getMilestones(milestoneid)">
> >
> > This assumes there is a variable named milestoneid in the namespace
> > somewhere.
> >
> > Adam Gotheridge wrote:
> > >
> > > I am trying to call an sql method which requires and integer argument.
> If I
> > > call it with
> > > <dtml-in "getMilestones(milestoneid='<dtml-var milestoneid>')">
> > >
> > > I get "Invalid integer value for milestoneid "
> > >
> > > If I use
> > >
> > > <dtml-in "getMilestones(milestoneid=<dtml-var milestoneid>)">
> > >
> > > I get "invalid syntax, for tag <dtml-in
> "getMilestones(milestoneid=<dtml-var
> > > milestoneid>)">, on line 24 of editTask
> > >
> > > Can anyone help? I have been at this for over 2 hours.
> > >
> > > Thanks,
> > >
> > > Adam
> > >
> > > _______________________________________________
> > > Zope maillist  -  Zope@zope.org
> > > http://lists.zope.org/mailman/listinfo/zope
> > >           No cross posts or HTML encoding!
> > > (Related lists -
> > >  http://lists.zope.org/mailman/listinfo/zope-announce
> > >  http://lists.zope.org/mailman/listinfo/zope-dev )
> >
> > --
> > Chris McDonough
> > Digital Creations, Inc.
> > Zope - http://www.zope.org
> >
> > _______________________________________________
> > Zope maillist  -  Zope@zope.org
> > http://lists.zope.org/mailman/listinfo/zope
> >           No cross posts or HTML encoding!
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )
> >
> >
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
>           No cross posts or HTML encoding!
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>
>