Re: Trouble getting this loop to work ...

2008-09-25 Thread gary gilbert
I have to agree with Gert on this one. That function needs to be rewritten so that it can accept a list of values. Would be interesting to see what the function is doing too. Running multiple queries in that way is unnecessarily network heavy. Gary Gilbert http://www.garyrgilbert.com/blog On

Re: Trouble getting this loop to work ...

2008-09-18 Thread Gert Franz
Well of course, you overwrite the query every time you iterate to the next value. The query always has the same name, so CFMX overwrites it. Nevertheless it is a bad solution. You should do something like this: select * from categories where category in ('#mcategories#') You could of course

Re: Trouble getting this loop to work ...

2008-09-18 Thread John Seelye
Thanks for the reply. ROL.getcategorydetailnames() Is actually a PostGRESQL function that is called within the The function only accepts one input (an integer) per iteration, so in my form that calls this page when someone selects more than one category I need the entire query to execute (and

Re: Trouble getting this loop to work ...

2008-09-17 Thread Gert Franz
com/group/railo/ english: http://groups.yahoo.com/group/railo_talk/ linked in: http://www.linkedin.com/e/gis/71368/0CF7D323BBC1 John Seelye schrieb: > Having trouble getting this loop to work. I'm not sure anymore if it is even > possible, but it seemed like a good way to go at the sta

Trouble getting this loop to work ...

2008-09-17 Thread John Seelye
Having trouble getting this loop to work. I'm not sure anymore if it is even possible, but it seemed like a good way to go at the start. What I'm trying to do is have the loop take the list (it can be anything from 1 to 42 items long) from a form and then run the function in the for