Example of database connection using ns

Main ✸ Home Page ✸ Source Code ✸ Downloads ✸ API Documentation ✸ Mailing Lists ✸ Bugs ✸ Developers

ns_db dml

Tcl example of database connection using ns_db dml.

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', '[email protected]')"
    
    ns_db dml $db $sql

    ns_db releasehandle $db
}

Note

ns_db dml is normally used for INSERT, UPDATE and DELETE queries.

Category NaviServer

Example of database connection using ns_db dml

ns_db dml

Note