You need to use 2 handles:
set db [ns_db gethandle "foobar" 2]
set db1 [lindex $db 0]
set db2 [lindex $db 1]
set sel [ns_db select $db1 "SELECT foo FROM bar"]
while {[ns_db getrow $db1 $sel]} {
.....
set sel2 [ns_db select $db2 "SELECT bar FROM foo"]
ns_db getrow $db2 $sel2
.....
}
Jim
>
> Hello AOLServer users,
>
> I have following problem:
>
> set db [ns_db gethandle "foobar"]
> set sel [ns_db select $db "SELECT foo FROM bar"]
> while {[ns_db getrow $db $sel]} {
> .....
> set sel2 [ns_db select $db "SELECT bar FROM foo"]
> ns_db getrow $db $sel2
> .....
> }
>
> After second loop of first "while", aolserver said:
> Get row called outside fetch row loop.
>
> I'm new to AOLServer and similar code works fine for me under Apache+PHP.
>
> I'm using AOLServer 3.4, PostgreSQL 7.1.2, pgdriver 2.0 from openacs on my
> Debian GNU/Linux (i686)
>
> Thanx for your advice and sorry for my ugly english :)
>
> --
> Best regards,
> Roman "RoFi" Fiser
> [EMAIL PROTECTED]
>
> TrimCon s.r.o., Czech republic
>
> ICQ: 2554226
> Cell: +420 (605) 215216
> Web: www.management.cz
>
