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 )