Difference between revisions of "Talk:Accessing A Database"
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 "<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: | ||
+ | |||
+ | <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)