# QueryAddRow Return new query ## Method Signature ``` QueryAddRow(query=[query], rowData=[any]) ``` ### Arguments | Argument | Type | Required | Description | Default | | --------- | ------- | -------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | | `query` | `query` | `true` | The query to add the row(s) to. | | | `rowData` | `any` | `false` |

Data to populate the query. Can be a struct (with keys matching column names), an array of structs, or an array of arrays (in
same order as columnList)

| | ## Examples ### Builds a simple query using queryNew and queryAddRow CF10+ Pass in row data directly to queryAddRow argument. [Run Example](https://try.boxlang.io/?code=eJwljLEKAjEQRGvzFctWCtvYKhbC1RbiDwQzasCLurcxHOK%2Fu%2Bd1M8N7U9AG2tGrQscD2pI4J7Fsd7B4LoYrVN5Rz7eoTKtt%2BKP7lI4Pp4vrQp%2BwcI1pQ2vxOOveuEPDSAkXRBvopLWPhcN3ummaDV3tn%2FPJNP0AXTYr0A%3D%3D) ```java news = queryNew( "id,title", "integer,varchar" ); queryAddRow( news, { "id" : 1, "title" : "Dewey defeats Truman" } ); writeDump( news ); ``` ### Builds a simple query using queryNew and queryAddRow member syntax CF10+ Pass in row data directly to queryAddRow argument. [Run Example](https://try.boxlang.io/?code=eJwljMEKwjAQRM%2FmK5Y9VQiCV8Vbzx6kPxCaUQM26nZjKMV%2Fd4O3mWHey6gznehdIMsZtSNO0WvSB9hbzoobxH%2BCjPcgTNujy0bsQoyXp71XtzGA6UB7b%2FEPWuMeFQtFXBF0pkHKFDK7bxNUSYq%2BTK%2BOmqtNPzgHKZw%3D) ```java news = queryNew( "id,title", "integer,varchar" ); news.addRow( { "id" : 1, "title" : "Dewey defeats Truman" } ); writeDump( news ); ``` ### Builds a simple query using queryNew queryAddRow and querySetCell Using Script with the queryAddRow querySetCell functions to populate the query. [Run Example](https://try.boxlang.io/?code=eJydjTEKAjEURHtP8UmlkEZbsRC3XQv1AsGMGswm698fw97ejYtaCWI3DG%2FmBeSOVnRL4H6LPCXlrBYnHkoPOQjOYH03fLwYVjRbTp7o2tpdHOhQ5q9yD9nA%2B7Eta1s%2B5uor8PZUyOjJ4gQjHR04NSb8JVv8IKsRKBt%2FpRiojnEUZXaCKjXtR%2FMADRpalA%3D%3D) ```java news = queryNew( "id,title", "integer,varchar" ); queryAddRow( news ); querySetCell( news, "id", "1" ); querySetCell( news, "title", "Dewey defeats Truman" ); queryAddRow( news ); querySetCell( news, "id", "2" ); querySetCell( news, "title", "Men walk on Moon" ); writeDump( news ); ``` ### Builds a simple query using queryNew queryAddRow and querySetCell with rows number The example above could be simplified this way: [Run Example](https://try.boxlang.io/?code=eJx9jjEOwjAMRXdOYWUCKUu7IgZE1zIAF4jIByJSB9KEqLcnpWo2uliW%2Fd%2BzGamnHb0j%2FHBEWpMwWgYTLITMPQfc4eVH%2BetDeUGb7eoX3Wt9cjnNGZdUl%2FkZ4QBr50WWjZoql%2BpvplxrkDCQxg0q9HTxsVO8SE72Wix9UOwtmJKyT3JMrXM8U8mbgCZ2rwkZR1%2BrXFX%2B) ```java news = queryNew( "id,title", "integer,varchar" ); queryAddRow( news, 2 ); querySetCell( news, "id", "1", 1 ); querySetCell( news, "title", "Dewey defeats Truman", 1 ); querySetCell( news, "id", "2", 2 ); querySetCell( news, "title", "Men walk on Moon", 2 ); writeDump( news ); ``` ### Builds a simple query using queryNew queryAddRow with multiple rows as an array CF10+ The example above could be simplified even more this way: [Run Example](https://try.boxlang.io/?code=eJxdjrEOwjAMROfkK6xMIHmBEcSA1LUMiA0xRMRAReuAmxBViH8naSfYzqd7vmNKPWzgGUmGHaUZmMZhaEJLBrPmQFcSfFk536wYmK%2F1GN06t%2Fc5zRlHOGr11kpl1MAKFlj09COfpqJEAzi6kA09HCR2lo1WH%2Fyhln9UTQzJtnfwDLX3I6FPZUCSJlAVu8dUX6wvBTs49A%3D%3D) ```java news = queryNew( "id,title", "integer,varchar" ); queryAddRow( news, [ { "id" : 1, "title" : "Dewey defeats Truman" }, { "id" : 2, "title" : "Men walk on Moon" } ] ); writeDump( news ); ``` ### Additional Examples [Run Example](https://try.boxlang.io/?code=eJx1jjELwjAUhOfmVxyZKhRKqaAoDgUdHCzoKg7BBAw0qb4mliL%2Bd9OK0KFO7w7u3nemO3pFHTZ49LdUbQyuZWKFURyzNRNSKnmq2%2BYXKWRvY5hvM0EeYkhTtLqqQMp5ssjZdPbMomyRsIgPb%2FHUAoJIdLC1E07XlrPLQA3%2BpiiU%2F2AnmPM%2FzBeL9luskC0DuCwOu6BH%2FMaRv7rRgHc%2FQHpzH8PYBygtXwc%3D) ```java myQuery = queryNew( "id,name" ); addedRows = queryAddRow( myQuery, 3 ); // will return 3 queryAddRow( myQuery, [ 17, "added via array notation" ] ); anotherRow = queryAddRow( myQuery ); // will return 4 queryAddRow( myQuery, { ID : 18, NAME : "added via struct notation" } ); dump( myQuery ); ``` ## Related * [QueryAddColumn](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryaddcolumn) * [QueryAppend](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryappend) * [QueryClear](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryclear) * [QueryColumnArray](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumnarray) * [QueryColumnCount](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumncount) * [QueryColumnData](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumndata) * [QueryColumnExists](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumnexists) * [QueryColumnList](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycolumnlist) * [QueryCurrentRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querycurrentrow) * [QueryDeleteColumn](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querydeletecolumn) * [QueryDeleteRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querydeleterow) * [QueryEach](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryeach) * [QueryEvery](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryevery) * [QueryFilter](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryfilter) * [QueryGetCell](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querygetcell) * [QueryGetResult](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querygetresult) * [QueryInsertAt](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryinsertat) * [QueryKeyExists](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querykeyexists) * [QueryMap](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querymap) * [QueryNew](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querynew) * [QueryNone](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querynone) * [QueryPrepend](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryprepend) * [QueryRecordCount](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrecordcount) * [QueryRecordCount](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrecordcount) * [QueryReduce](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryreduce) * [QueryRegisterFunction](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryregisterfunction) * [QueryReverse](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryreverse) * [QueryRowData](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrowdata) * [QueryRowSwap](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryrowswap) * [QuerySetCell](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysetcell) * [QuerySetRow](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysetrow) * [QuerySlice](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/queryslice) * [QuerySome](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysome) * [QuerySort](https://boxlang.ortusbooks.com/boxlang-language/reference/built-in-functions/query/querysort)