Difference between revisions of "Conf/Examples/DatabseExample"

From AOLserver Wiki
Jump to navigation Jump to search
Line 1: Line 1:
 
   <html>
 
   <html>
     <head><title>Testing of ADP</title></head>
+
     <head><title>Testing of Database connection</title></head>
 
   <body>   
 
   <body>   
 
   A simple tcl script example of Database Configuration
 
   A simple tcl script example of Database Configuration

Revision as of 13:51, 11 January 2012

 <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 row [ns_db select $db $sql]
  while {[ns_db getrow $db $row]} {
   ns_adp_puts "row: [ns_set array $row]"
  }	
  ns_db releasehandle $db
 %>
 </body>
 </html>