Differences

This shows you the differences between two versions of the page.

--- v5:userguide:learn_abstraction:basic_query [2016/03/15 01:23] – mnewnham
+++ v5:userguide:learn_abstraction:basic_query [2016/03/15 14:27] (current) – mnewnham
@@ Line 1: / Line 1: @@
 <- v5:userguide:learn_abstraction:establishing_connection|Establishing A Connection ^ v5:userguide:learn_abstraction:start_lesson|Start Of Lesson ^ v5:userguide:learn_abstraction:key_value_pairs|Key/Value Pairs ->
+~~NOTOC~~
 ====== A Basic Query ======
 The simplest way that ADOdb can retrieve data is through the [[v5:reference:connection:getall|getAll()]] method. This method reads the selected rows from the database into an array. Once retrieved, the data in the recordset is inserted into an array.
@@ Line 51: / Line 51: @@
 ^Command^Description|
-|[[v5:reference:connection:getcol|getCol()]]|Executes a provided SQL statement and returns the first row of the entire recordset into a numeric array|
+|[[v5:reference:connection:getcol|getCol()]]|Executes a provided SQL statement and returns the first **column** of the entire result set into a numeric array, no matter how large. If multiple columns are retrieved by the SQL statement, all but the first are discarded|
-|[[v5:reference:connection:getone|getOne()]]|Retrieves the first column of the first matching row of an executed SQL statement|
+|[[v5:reference:connection:getone|getOne()]]|Executes a provided SQL statement and returns the first **column** of the first matching **row** into a variable. If multiple columns are retrieved by the SQL statement, all but the first are discarded|
-|[[v5:reference:connection:getrow|getRow()]]|Retrieves the first matching row of an executed SQL statement|
+|[[v5:reference:connection:getrow|getRow()]]|Executes a provided SQL statement and returns the first matching **row** into a array. If multiple rows are retrieved by the SQL statement, all but the first are discarded|