[http://naviserver.sourceforge.net/ns_logobig.gif]

[NaviServer%|%Main%|%]
✸ http://naviserver.sourceforge.net/w/NaviServer%|%Home Page%|%
✸ http://bitbucket.org/naviserver/naviserver/%|%Source Code %|%
✸ http://sourceforge.net/project/showfiles.php?group_id=130646%|%Downloads %|%
✸ http://naviserver.sourceforge.net/n/toc.html%|%API Documentation %|%
✸ http://sourceforge.net/mail/?group_id=130646%|%Mailing Lists%|%
✸ http://sourceforge.net/tracker/?group_id=130646&atid=719006%|%Bugs %|%
✸ https://www.ohloh.net/p/naviserver/contributors%|%Developers %|%

----

**ns_db dml**
Tcl example of database connection using ns_db dml.
======tcl
ns_register_proc GET /index.html db_test_dml

proc db_test_dml {} {
    set pool "main"
    set db [ns_db gethandle $pool]

    set sql "INSERT INTO users(user_id, firstname, surname, email)
             VALUES(1, 'Jane', 'Doe', 'jane@doe.com')"
    
    ns_db dml $db $sql

    ns_db releasehandle $db
}
======
'''Note'''

ns_db dml is normally used for INSERT, UPDATE and DELETE queries.
<<categories>>NaviServer