The second problem was solved with the group by rm.room_id,rm.room_name, thanks Samer; but the original problem is not solved, I get it in a diferent query, look:
Query:
db_multirow reporte foo "select rm.room_name as room_name, pa.email, rv.start_time, rv.end_time, rv.people from reserve rv, rooms rm, parties pa where rv.room_id=$room_id and rm.room_id=rv.room_id and pa.party_id=rv.user_id"
The error:
Database operation "getrow" failed (exception 1406, "nsoracle.c:2055:ora_get_row: error in `OCIStmtFetch ()': ORA-01406: fetched column value was truncated
SQL: [nil]")
while executing
"ns_db getrow $db $selection"
invoked from within
"db_getrow $db $selection"
("while" body line 4)
invoked from within
"while { 1 } {
if { $more_rows_p } {
set more_rows_p [db_getrow $db $selection]
} else {
break..."
("uplevel" body line 16)
"Thanks in for your help"
Rodrigo C.
