<?xml version="1.0" encoding="windows-1252"?>
<node id="162971" title="Re: The fine art of database programming" created="2002-04-29 20:57:32" updated="2005-08-11 11:35:42">
<type id="11">
note</type>
<author id="116292">
mpeppler</author>
<data>
<field name="doctext">
One additional pitfall for most people using a relational database for the first time: there are no record numbers!&lt;p&gt;
An RDBMS is based on set theory, and a particular row has no inherent position in its table (although some database systems fake this).&lt;p&gt;
Hence the very common question: &lt;i&gt;how do I fetch rows 100-120&lt;/i&gt;, where the &lt;i&gt;database independant&lt;/i&gt; answer is always: &lt;i&gt;use an appropriate WHERE clause&lt;/i&gt;.
&lt;p&gt;
Michael
</field>
<field name="root_node">
162771</field>
<field name="parent_node">
162771</field>
</data>
</node>
