query.slice()
creates a new query containing a part of the given query
query.slice( offset=number, length=number )
Returns: Query
| Argument | Description |
|---|---|
|
offset
number,
required
|
Start position in the original query to slice |
|
length
number,
optional
|
The number of rows to slice from the offset. |
Examples
q = queryNew( "id,name","int,varchar");
q.addRow(4);
q.setCell("id", 1, 1);
q.setCell("id", 2, 2);
q.setCell("id", 3, 3);
q.setCell("id", 4, 4);
q.setCell("name", "one", 1);
q.setCell("name", "two", 2);
q.setCell("name", "three",3);
q.setCell("name", "four", 4);
dump(q);
writeDump(q.slice(1,3));
writeDump(q.slice(2,3));
writeDump(q.slice(3,1));