as a matter of fact, I've got something that does that! I've got a better, more universal example someplace else (I'll find it tomorrow) but for now, here ya go. Give me some sample data and I'll stick it into the newer version I have of this script at the office.<html>
<head>
<title>Virtual DB test</title>
<style>
table.dvdList {
font: .8em Verdana, sans-serif;
border-collapse: collapse;
width: 100%;
}
table.dvdList th {
background-color: #EEE;
border: 1px solid #666;
padding: 5px;
}
table.dvdList td {
border: 1px solid #666;
padding: 3px;
}
table.dvdList caption {
font: 1.5em 'Trebuchet MS',Verdana, sans-serif;
}
table.dvdList caption em {
font-size: .8em;
}
div.example {
color: red;
font: 1em 'Courier New', mono;
}
</style>
<script type="text/javascript">
function dvdlist(listName) {
this.listname = listName;
this.format = new Array("Title","Actor","Director","Company","Length","Year","Format","Genre","Comments");
this.list = new Array();
var i = 0;
this.list[i++] = new dvd("Cadence","Charlie Sheen, Martin Sheen","Martin Sheen","Movie Group","97 mins",1990,"NTSC","Action/Adventure","Dad and son in Army jail drama");
this.list[i++] = new dvd("Conspiracy Theory","Mel Gibson, Julia Roberts","Richard Donner","Warner Bros","130 mins",1997,"PAL","Thriller","Taxi driver with a past");
this.list[i++] = new dvd("Devils Advocate","Keanu Reaves, Al Pacino","Taylor Hackford","Twentieth Century Fox","138 mins",1997,"PAL","Thriller","Legal/Satan twist");
this.list[i++] = new dvd("Gladiator","Russell Crowe","Ridley Scott","Dreamworks Pictures","149 mins",2000,"PAL","Action/Adventure","Set in Ancient Rome");
this.list[i++] = new dvd("House II","Ayre Gross","Ethan Wiley","Digital Entertainment Ltd","88 mins",1987,"PAL","Horror","Gramps is cool!");
this.list[i++] = new dvd("Lost Boys","Jason Patric, Keifer Sutherland","Joel Shumacher","Warner Bros","93 mins",1987,"PAL","Thriller","Vampire film with a twist");
this.list[i++] = new dvd("True Lies","Arnold Swarzenegger","James Cameron","Warner Bros","135 mins",1994,"PAL","Action/Adventure","Spy action");
this.list[i++] = new dvd("Wyrd Sisters","Various (Animation)","Jean Flynn","Various","140 mins",2000,"PAL","Sci-Fi/Fantasy","Animation of Terry Pratchett book");
this.list[i++] = new dvd("Fistful of Dollars","Clint Eastwood","Sergio Leone","United Artists/MGM","97 mins",1964,"PAL","Western","Spaghetti Western");
this.list[i++] = new dvd("Few Dollars More","Clint Eastwood","Sergio Leone","United Artists/MGM","126 mins",1965,"PAL","Western","Spaghetti Western");
this.list[i++] = new dvd("The Good The Bad The Ugly","Clint Eastwood","Sergio Leone","United Artists/MGM","154 mins",1966,"PAL","Western","Spaghetti Western");
this.list[i++] = new dvd("Eraser","Arnold Swarzenegger","Charles Russell","Warner Bros","107 mins",1996,"PAL","Action/Adventure","Witness Protection type");
this.list[i++] = new dvd("6th Day","Arnold Swarzenegger","Roger Spottiswoode","Columbia Pictures","124 mins",2000,"PAL","Sci-Fi/Fantasy","Arnie clone takes over his life");
this.list[i++] = new dvd("Matrix","Keanu Reaves","The Wachowski Bros","Warner Bros","135 mins",1999,"PAL","Sci-Fi/Fantasy","Sci-Fi with excellent graphics");
this.list[i++] = new dvd("End of Days","Arnold Swarzenegger","Peter Hyams","Universal","121 mins",1999,"PAL","Action/Adventure","Fight the devil");
this.quantity = i;
this.error = "Title Not Found";
}
function dvd(title, actor, director, company, length, year, format, genre, comments){
this.title = title;
this.actor = actor;
this.director = director;
this.company = company;
this.length = length;
this.year = year;
this.format = format;
this.genre = genre;
this.comments = comments;
this.selected = true;
}
function dvdlist.prototype.display(qty) {
var shown = 0;
if (typeof qty == 'undefined') var qty = this.quantity;
document.write('<table class="dvdList"><tr>');
for (var i=0; i<this.format.length; i++)
document.write('<th>'+this.format[i]+'</th>');
document.write('</tr>');
for (i=0; i<this.quantity; i++) {
if (this.list[i].selected && shown++ < qty) {
document.write('<tr>');
for (var j in this.list[i]) {
if (j != 'selected') {
var t = eval('this.list['+i+'].'+j);
document.write('<td>'+t+'</td>');
}
}
document.write('</tr>');
}
}
document.write('<caption>'+this.listname+'</caption>');
document.write('</table>');
}
function dvdlist.prototype.select(field, val) {
var r = new RegExp(val,"i");
for (var i=0; i<this.quantity; i++) {
var t = eval('this.list[i].'+field);
if (!r.test(t)) this.list[i].selected = false;
}
}
function dvdlist.prototype.selectAll() {
for (var i=0; i<this.quantity; i++) {
this.list[i].selected = true;
}
}
function dvdlist.prototype.sortBy(field) {
this.list.sort(sortHandler);
function sortHandler(a, b) {
var aa = eval('a.'+field);
var bb = eval('b.'+field);
if (aa == bb) return 0;
return (aa > bb) ? 1 : -1;
}
}
function dvdlist.prototype.get(field, val) {
for (var i=0; i<this.quantity; i++) {
var t = eval('this.list[i].'+field);
if (t == val) return this.list[i];
}
return this.error;
}
</script>
</head>
<body>
<script>
var myList = new dvdlist("My DVDs");
document.write('<br /><div class="example">Example of full list, unchanged</div>');
myList.display();
document.write('<br /><div class="example">Example of limiting results to 5</div>');
myList.display(5);
document.write('<br /><div class="example">Example of limiting results to 5 and sorting by "year"</div>');
myList.sortBy('year');
myList.display(5);
document.write('<br /><div class="example">Example of sorting by "year" where "actor" contians "arnold"</div>');
myList.sortBy('year');
myList.select('actor','arnold');
myList.display();
document.write('<br /><div class="example">Example of sorting by "title" where "genre" is Action/Adventure</div>');
myList.selectAll();
myList.sortBy('title');
myList.select('genre','action');
myList.display();
document.write('<br /><div class="example">Example where "genre" is Action/Adventure and "company" is "Warner Bros"</div>');
myList.selectAll();
myList.select('genre','action');
myList.select('company','warner');
myList.display();
</script>
</body>
</html>