Forum OpenACS Q&A: Re: I got a 0or1row failed (exception NSINT, Query returned more than one row)

Collapse
5: Re: I got a 0or1row failed (exception NSINT, Query returned more than one row) (response to 1)
Posted by Don Baccus on 10/08/03 08:48 PM
It obviously isn't running that query because coun(*) always returns one row.

Do you have SQL logging enabled in AOLserver?  If so, could you post not only the error message but the actual query it thinks it is running?

Is the query inline or in a query file?  A new query, or did you overwrite an existing query?  Remember that queries in a query file override inline queries.

Collapse
6: Re: I got a 0or1row failed (exception NSINT, Query returned more than one row) (response to 5)
Posted by Rod Cap on 10/09/03 09:52 PM
Thank you very much!!!!
I've solve the problem, stupid I was. I was focus only in one query and the one that was making troueble was a simple one defined at the end. Thanks for your time. Hope I could solve the other one. I'll post it (ONES)