Using AOLserver 3.3.1 with the postgres driver from openacs.org
the following code gives me the error if there are no rows:
exception NSDB, "Query was not a statement returning rows.")
while executing...
--
set selection [ns_db select $db $sql]
set list_to_return [list]
while {[ns_db getrow $db $selection]} {
lappend list_to_return [ns_set value $selection 0]
}
--
It works fine if there are rows returned.
I would have expected the 'ns_db select' to be ok but get 0 back from the
first call to 'ns_db getrow'
I would like to return an empty list if there are now rows matching the
query.
Any suggestion/code snippets? Surely the OpenACS team has dealt with this.
------
Keith Paskett [EMAIL PROTECTED]
Space Dynamics Laboratory PGP or GPG encrypted mail preferred
1695 North Research Parkway 435-797-4195
Logan, Utah 84341
