On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote:
>
> dbMem eval {select distinct(owner) from lockinfo order by owner} {
> <do something with $owner>
> }
>
> That works correctly in my original app using 3.4.2, but complains
> that
> there is no such variable "owner" when using 3.5.9.
Solution 1:
dbMem eval {SELECT DISTINCT owner FROM lockinfo ORDER BY owner} {
puts $owner
}
Solution 2:
dbMem eval {SELECT DISTINCT(owner) AS owner FROM lockinfo ORDER BY
owner} {
puts $owner
}
Solution 3:
dbMem eval {SELECT DISTINCT(owner) FROM lockinfo ORDER BY owner} {
puts ${(owner)}
}
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
