On Monday, January 27, 2003, at 01:20 PM, [EMAIL PROTECTED] wrote:
This is all well and good, but every database that RevDB supports does have rows.The concept of rows is _the result of your SQL query_. Learn about the SELECT statement in SQL. The general form is
What confounds me is that RevDB has an API to fetch columns, but not rows. It seems arbitrary, and less useful to me. Of course I may be missing something, but I'm still not seeing what that is! Even if there were a function to fetch *all* of the columns, that would seem like a step in the right direction.
select [columns...] from <table> where [conditions...]
select * from my_stuff # returns all rows and cols
select id, name, date from my_stuff # returns 3 cols and all rows
select id, name, date from my_stuff limit 1 # returns 3 cols and 1 row
select id, name, date from my_stuff order by name limit 1 # returns 1 row, based on sort
select id, name, date from my_stuff where id = 12345 # returns this specific row
Alex Rice, Software Developer
Architectural Research Consultants, Inc.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
