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

Collapse
4: Re: Question about db_multirow and <multiple> (response to 3)
Posted by Brian Fenton on 11/12/03 10:44 AM
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
5: Re: Question about db_multirow and <multiple> (response to 4)
Posted by Mark Aufflick on 11/12/03 02:01 PM
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
6: Re: Question about db_multirow and <multiple> (response to 5)
Posted by Sean Harrison on 11/12/03 06:45 PM
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