Description Usage Arguments Details Value Note Author(s) See Also Examples
Run arbitrary SQL queries against the MonetDB and return the results as a data.frame
1 |
con |
an Open MonetDB Connection handle |
sql |
Arbitrary SQL to execute |
parameters |
list of string values substituted into the ? placeholders |
autocommit |
optional - boolean flag TRUE to auto commit |
lastid |
optional - boolean flag TRUE to return the last row ID affected - good for INSERT statements |
page |
optional - boolean flag TRUE to page the results - does nothing at the moment :-) |
1 2 3 4 5 6 | con <- RMonetConnect("db.yml")
res <- RMonetQuery(con, "SELECT * FROM voc.craftsmen WHERE trip > ? LIMIT ?", list(3,15))
print(res)
RMonetClose(con)
|
Returns a data.frame of the table contents selected
Not much to note here.
Piers Harding
RMonet
, RMonetConnect
, RMonetGetInfo
, RMonetQuery
, RMonetLoadDataFrame
, RMonetExecute
, RMonetClose
, RMonetStartTransaction
, RMonetCommit
, RMonetIsConnected
, RMonetQuote
, RMonetUnQuote
, RMonetExists
, RMonetListTables
, RMonetListFields
1 2 3 4 5 | ## Not run:
# read the VOC craftsmen table with parameter substitutions
RMonetQuery(con, "SELECT * FROM voc.craftsmen WHERE trip > ? LIMIT ?", list(3,15))
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.