query,RequeteDBwheredate-method | R Documentation |
query method loads a request to the database and returns either an error or a data.frame
## S4 method for signature 'RequeteDBwheredate' query(object, ...)
object |
an object of class RequeteDBwheredate |
... |
further arguments passed to the query method, base will be passed to ConnectionDB to set the connection parameters, |
An object of class RequeteDBwheredate
Cedric Briand cedric.briand@eptb-vilaine.fr
## Not run: object<-new("RequeteDBwheredate") base=c("bd_contmig_nat","localhost","5432","user", "password") object@select<- "select * from t_operation_ope" object@datedebut=strptime("1996-01-01 00:00:00",format="%Y-%m-%d %H:%M:%S") object@datefin=strptime("2000-01-01 00:00:00",format="%Y-%m-%d %H:%M:%S") object@colonnedebut="ope_date_debut" object@colonnefin="ope_date_fin" object@and<-c("AND ope_dic_identifiant=1","AND ope_dic_identifiant=2") object@order_by<-"ORDER BY ope_identifiant" object@silent=FALSE object<-connect(object, base) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.