It's SqlResultSetRowList not SqlResultSetList
Project: http://git-wip-us.apache.org/repos/asf/cordova-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/cordova-docs/commit/97ca2d68 Tree: http://git-wip-us.apache.org/repos/asf/cordova-docs/tree/97ca2d68 Diff: http://git-wip-us.apache.org/repos/asf/cordova-docs/diff/97ca2d68 Branch: refs/heads/master Commit: 97ca2d68e47534b2ec89b082dc3d65f333d86f8e Parents: af24b6c Author: Simon MacDonald <simon.macdon...@gmail.com> Authored: Tue Jan 8 21:55:56 2013 -0500 Committer: Simon MacDonald <simon.macdon...@gmail.com> Committed: Tue Jan 8 21:55:56 2013 -0500 ---------------------------------------------------------------------- docs/en/edge/config.json | 2 +- .../storage/sqlresultsetlist/sqlresultsetlist.md | 137 --------------- .../sqlresultsetrowlist/sqlresultsetrowlist.md | 137 +++++++++++++++ docs/en/edge/cordova/storage/storage.md | 2 +- 4 files changed, 139 insertions(+), 139 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cordova-docs/blob/97ca2d68/docs/en/edge/config.json ---------------------------------------------------------------------- diff --git a/docs/en/edge/config.json b/docs/en/edge/config.json index 8498cef..f80fbf1 100644 --- a/docs/en/edge/config.json +++ b/docs/en/edge/config.json @@ -184,7 +184,7 @@ "cordova/storage/database/database.md", "cordova/storage/sqltransaction/sqltransaction.md", "cordova/storage/sqlresultset/sqlresultset.md", - "cordova/storage/sqlresultsetlist/sqlresultsetlist.md", + "cordova/storage/sqlresultsetrowlist/sqlresultsetrowlist.md", "cordova/storage/sqlerror/sqlerror.md", "cordova/storage/localstorage/localstorage.md" ], http://git-wip-us.apache.org/repos/asf/cordova-docs/blob/97ca2d68/docs/en/edge/cordova/storage/sqlresultsetlist/sqlresultsetlist.md ---------------------------------------------------------------------- diff --git a/docs/en/edge/cordova/storage/sqlresultsetlist/sqlresultsetlist.md b/docs/en/edge/cordova/storage/sqlresultsetlist/sqlresultsetlist.md deleted file mode 100644 index b164eeb..0000000 --- a/docs/en/edge/cordova/storage/sqlresultsetlist/sqlresultsetlist.md +++ /dev/null @@ -1,137 +0,0 @@ ---- -license: Licensed to the Apache Software Foundation (ASF) under one - or more contributor license agreements. See the NOTICE file - distributed with this work for additional information - regarding copyright ownership. The ASF licenses this file - to you under the Apache License, Version 2.0 (the - "License"); you may not use this file except in compliance - with the License. You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, - software distributed under the License is distributed on an - "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - KIND, either express or implied. See the License for the - specific language governing permissions and limitations - under the License. ---- - -SQLResultSetList -======= - -One of the properties of the SQLResultSet containing the rows returned from a SQL query. - -Properties -------- - -- __length__: the number of rows returned by the SQL query - -Methods -------- - -- __item__: returns the row at the specified index represented by a JavaScript object. - -Details -------- - -The SQLResultSetList contains the data returned from a SQL select statement. The object contains a length property letting you know how many rows the select statement has been returned. To get a row of data you would call the `item` method specifying an index. The item method returns a JavaScript Object who's properties are the columns of the database the select statement was executed against. - -Supported Platforms -------------------- - -- Android -- BlackBerry WebWorks (OS 6.0 and higher) -- iPhone -- webOS -- Tizen - -Execute SQL Quick Example ------------------- - - function queryDB(tx) { - tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB); - } - - function querySuccess(tx, results) { - var len = results.rows.length; - console.log("DEMO table: " + len + " rows found."); - for (var i=0; i<len; i++){ - console.log("Row = " + i + " ID = " + results.rows.item(i).id + " Data = " + results.rows.item(i).data); - } - } - - function errorCB(err) { - alert("Error processing SQL: "+err.code); - } - - var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); - db.transaction(queryDB, errorCB); - -Full Example ------------- - - <!DOCTYPE html> - <html> - <head> - <title>Storage Example</title> - - <script type="text/javascript" charset="utf-8" src="cordova-2.3.0.js"></script> - <script type="text/javascript" charset="utf-8"> - - // Wait for Cordova to load - // - document.addEventListener("deviceready", onDeviceReady, false); - - // Populate the database - // - function populateDB(tx) { - tx.executeSql('DROP TABLE IF EXISTS DEMO'); - tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)'); - tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")'); - tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")'); - } - - // Query the database - // - function queryDB(tx) { - tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB); - } - - // Query the success callback - // - function querySuccess(tx, results) { - var len = results.rows.length; - console.log("DEMO table: " + len + " rows found."); - for (var i=0; i<len; i++){ - console.log("Row = " + i + " ID = " + results.rows.item(i).id + " Data = " + results.rows.item(i).data); - } - } - - // Transaction error callback - // - function errorCB(err) { - console.log("Error processing SQL: "+err.code); - } - - // Transaction success callback - // - function successCB() { - var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); - db.transaction(queryDB, errorCB); - } - - // Cordova is ready - // - function onDeviceReady() { - var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); - db.transaction(populateDB, errorCB, successCB); - } - - </script> - </head> - <body> - <h1>Example</h1> - <p>Database</p> - </body> - </html> http://git-wip-us.apache.org/repos/asf/cordova-docs/blob/97ca2d68/docs/en/edge/cordova/storage/sqlresultsetrowlist/sqlresultsetrowlist.md ---------------------------------------------------------------------- diff --git a/docs/en/edge/cordova/storage/sqlresultsetrowlist/sqlresultsetrowlist.md b/docs/en/edge/cordova/storage/sqlresultsetrowlist/sqlresultsetrowlist.md new file mode 100644 index 0000000..4e08314 --- /dev/null +++ b/docs/en/edge/cordova/storage/sqlresultsetrowlist/sqlresultsetrowlist.md @@ -0,0 +1,137 @@ +--- +license: Licensed to the Apache Software Foundation (ASF) under one + or more contributor license agreements. See the NOTICE file + distributed with this work for additional information + regarding copyright ownership. The ASF licenses this file + to you under the Apache License, Version 2.0 (the + "License"); you may not use this file except in compliance + with the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, + software distributed under the License is distributed on an + "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY + KIND, either express or implied. See the License for the + specific language governing permissions and limitations + under the License. +--- + +SQLResultSetRowList +======= + +One of the properties of the SQLResultSet containing the rows returned from a SQL query. + +Properties +------- + +- __length__: the number of rows returned by the SQL query + +Methods +------- + +- __item__: returns the row at the specified index represented by a JavaScript object. + +Details +------- + +The SQLResultSetRowList contains the data returned from a SQL select statement. The object contains a length property letting you know how many rows the select statement has been returned. To get a row of data you would call the `item` method specifying an index. The item method returns a JavaScript Object who's properties are the columns of the database the select statement was executed against. + +Supported Platforms +------------------- + +- Android +- BlackBerry WebWorks (OS 6.0 and higher) +- iPhone +- webOS +- Tizen + +Execute SQL Quick Example +------------------ + + function queryDB(tx) { + tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB); + } + + function querySuccess(tx, results) { + var len = results.rows.length; + console.log("DEMO table: " + len + " rows found."); + for (var i=0; i<len; i++){ + console.log("Row = " + i + " ID = " + results.rows.item(i).id + " Data = " + results.rows.item(i).data); + } + } + + function errorCB(err) { + alert("Error processing SQL: "+err.code); + } + + var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); + db.transaction(queryDB, errorCB); + +Full Example +------------ + + <!DOCTYPE html> + <html> + <head> + <title>Storage Example</title> + + <script type="text/javascript" charset="utf-8" src="cordova-2.3.0.js"></script> + <script type="text/javascript" charset="utf-8"> + + // Wait for Cordova to load + // + document.addEventListener("deviceready", onDeviceReady, false); + + // Populate the database + // + function populateDB(tx) { + tx.executeSql('DROP TABLE IF EXISTS DEMO'); + tx.executeSql('CREATE TABLE IF NOT EXISTS DEMO (id unique, data)'); + tx.executeSql('INSERT INTO DEMO (id, data) VALUES (1, "First row")'); + tx.executeSql('INSERT INTO DEMO (id, data) VALUES (2, "Second row")'); + } + + // Query the database + // + function queryDB(tx) { + tx.executeSql('SELECT * FROM DEMO', [], querySuccess, errorCB); + } + + // Query the success callback + // + function querySuccess(tx, results) { + var len = results.rows.length; + console.log("DEMO table: " + len + " rows found."); + for (var i=0; i<len; i++){ + console.log("Row = " + i + " ID = " + results.rows.item(i).id + " Data = " + results.rows.item(i).data); + } + } + + // Transaction error callback + // + function errorCB(err) { + console.log("Error processing SQL: "+err.code); + } + + // Transaction success callback + // + function successCB() { + var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); + db.transaction(queryDB, errorCB); + } + + // Cordova is ready + // + function onDeviceReady() { + var db = window.openDatabase("Database", "1.0", "Cordova Demo", 200000); + db.transaction(populateDB, errorCB, successCB); + } + + </script> + </head> + <body> + <h1>Example</h1> + <p>Database</p> + </body> + </html> http://git-wip-us.apache.org/repos/asf/cordova-docs/blob/97ca2d68/docs/en/edge/cordova/storage/storage.md ---------------------------------------------------------------------- diff --git a/docs/en/edge/cordova/storage/storage.md b/docs/en/edge/cordova/storage/storage.md index 8a82e75..d2ecc6c 100644 --- a/docs/en/edge/cordova/storage/storage.md +++ b/docs/en/edge/cordova/storage/storage.md @@ -43,7 +43,7 @@ Objects - Database - SQLTransaction - SQLResultSet -- SQLResultSetList +- SQLResultSetRowList - SQLError - localStorage