Difference between revisions of "Talk:Accessing A Database"

From AOLserver Wiki
Jump to navigation Jump to search
 
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
the examples are malformed, the brackets <nowiki>[ ]</nowiki> are estranged or omitted. in other words, cut and paste produces non-working code.
+
the examples are malformed, the brackets <nowiki>[ ]</nowiki> are estranged or omitted. in other words, cut and paste produces non-working code. possible suggestions are using the "&lt;nowiki&gt;" or "pre" tags, but i dislike this as an overall solution because linking ns_db to [[ns_db]] could be useful and the nowiki or pre tag would remove that. isn't there a simple way to insert a bracket character? or would we need to use the entity code with &amp;code for brackets? that would make pasting code into the wiki very hard.
 +
 
 +
suggestion, use "pre" for now and not worry about wiki linking from code examples:
 +
 
 +
<pre>
 +
  <%
 +
    # change "poolname" to match the pool you defined in your config.tcl
 +
    set pool "poolname"
 +
    # change to reflect the SQL you wish to execute
 +
    set sql "SELECT NOW()"
 +
 
 +
    set db ""
 +
    catch {
 +
      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]"
 +
      }
 +
    }
 +
    catch { ns_db releasehandle $db }
 +
  %>
 +
</pre>
 +
 
 +
* A single bracket is a literal bracket except when surrounding a URL.  Double brackets link to internal page names.  I'll go fix the examples to render properly in MediaWiki.  Thanks for bringing it up. ''-- [[User:Dossy|Dossy]] 19:35, 1 December 2005 (EST)''

Latest revision as of 00:35, 2 December 2005

the examples are malformed, the brackets [ ] are estranged or omitted. in other words, cut and paste produces non-working code. possible suggestions are using the "<nowiki>" or "pre" tags, but i dislike this as an overall solution because linking ns_db to ns_db could be useful and the nowiki or pre tag would remove that. isn't there a simple way to insert a bracket character? or would we need to use the entity code with &code for brackets? that would make pasting code into the wiki very hard.

suggestion, use "pre" for now and not worry about wiki linking from code examples:

   <%
     # change "poolname" to match the pool you defined in your config.tcl
     set pool "poolname"
     # change to reflect the SQL you wish to execute
     set sql "SELECT NOW()"

     set db ""
     catch {
       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]"
       }
     }
     catch { ns_db releasehandle $db }
   %>
  • A single bracket is a literal bracket except when surrounding a URL. Double brackets link to internal page names. I'll go fix the examples to render properly in MediaWiki. Thanks for bringing it up. -- Dossy 19:35, 1 December 2005 (EST)