Forum OpenACS Development: Re: Question about db_multirow and <multiple>

Collapse
Posted by Sean Harrison on
P.P.S. I also realize that there are better ways to accomplish what I'm trying to accomplish; I would be happy to follow some other approach if you think it would be better. Thanks. --SAH
Collapse
Posted by Brian Fenton on
This might seem a bit too obvious, but are you certain your new query is being watched? Try temporarily moving the query inline into your TCL file and see if it works from there.
Collapse
Posted by Mark Aufflick on
Take a look in the apm and see if there is still a "reload" link available even though the file is being watched. If you have a syntax error in a tcl file, or an xml error in an xql file, then the watch proc is not able to parse it, and the old version stays live.

that one used to get me all the time.

Collapse
Posted by Sean Harrison on
Mark and Brian,

That was it! Thank you very much. That complex query now is working perfectly, and although it is expensive (slow) it gets the job done, which is what I need right now.

Shawn Harrison