Conf/Examples/DatabseExampleZeroOrOneRow - Revision history

Visitatvishal at 15:50, 17 January 2012

2012-01-17T15:50:19Z

Visitatvishal at 09:34, 13 January 2012

2012-01-13T09:34:59Z

Visitatvishal: Created page with ' part of AOL Database Configuration with PostgreSQL Testing of Database connection A simple…'

2012-01-12T12:19:19Z

Created page with ' part of AOL Database Configuration with PostgreSQL <html> <head><title>Testing of Database connection</title></head> <body> A simple…'

New page

[[Conf/Examples/DatabseConfig| part of AOL Database Configuration with PostgreSQL]]

<html>
<head><title>Testing of Database connection</title></head>
<body>
A simple tcl script example of Database Configuration
<%
set pool "postgres_pool"
set sql "select * from users"
set db [ns_db gethandle $pool]

set rec [ns_db 0or1row $db $sql]
ns_puts [ns_set array $rec]
ns_db releasehandle $db
%>
</body>
</html>

------

'''Note'''

This command(ns_db 0or1row) expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.

@@ Line 11: / Line 11: @@
     set rec [ns_db 0or1row $db $sql]
-    ns_puts [ns_set array $rec]
+    if { $rec eq "" } {
     ns_db releasehandle $db
    %>

@@ Line 7: / Line 7: @@
    <%
     set pool "postgres_pool"
-    set sql "select * from users"
+    set sql "select * from users where user_id = 1"
     set db [ns_db gethandle $pool]