Example of database connection using ns_db 1row

https://web.archive.org/web/20161211211830/naviserver.sourceforge.net/ns_logobig.gif

MainHome Page Source Code Downloads API Documentation Mailing Lists Bugs Developers


ns_db 1row

Tcl example of database connection using ns_db 1row.

ns_register_proc GET /index.html db_test_1row

proc db_test_1row {} {
    set pool "main"
    set sql "select * from users where user_id = 1"
    set db [ns_db gethandle $pool]
    
    set row [ns_db 1row $db $sql]
    
    set html "dbtest_1row: [ns_set array $row]"

    ns_db releasehandle $db

    ns_return 200 text/html $html
}