PDA

View Full Version : How do I extract the data of an individual entry?



thewackonerd
01-11-2006, 11:43 PM
Hi, I want to pull data from a table and display each line but not use a repeat region.

The database table design is as follows

-------------
Name, Type, Size, Decimals, Null, Primary key
-------------
Id, Integer, 11, 0, no, yes
Setting, Varchar, 100, 0, No
Value, Longtext, -1, 0, no
--------------

So I get a table of data like this.
--------------------
Id, Setting, value
---------------------
1, sitename, memo
2, siteurl, memo
3, Siteemail, memo
4, Copynotice, memo
--------------------

I then create a record set called ‘rs_settings’

How do I extract the data of an individual entry? say the 4th, 7th and 10th entry

Thank you