R help - Nov 2012 - can not read table in dbReadTable

> tbs<-dbListTables(con)
> 
> tbs
[1] "lowend" "time"   "week30" "week33"
"week39" "week42"
> my.data.copy <- dbReadTable(tbs, "week42")
Error in function (classes, fdef, mtable)  : 
  unable to find an inherited method for function "dbReadTable", for
signature "character", "character"

I have created tables in db. but there is this error show up when I try to read
the table in my db.. whats wrong with it??



Thanks a lot.


Tammy 
 		 	   		  
	[[alternative HTML version deleted]]

I suspect it should be

my.data.copy <- dbReadTable(con, "week42")

(with con instead of tbs as first argument)

Jan




Tammy Ma <metal_licaling at live.com> schreef:
>> tbs<-dbListTables(con)
>>
>> tbs
> [1] "lowend" "time"   "week30"
"week33" "week39" "week42"
>
>> my.data.copy <- dbReadTable(tbs, "week42")
> Error in function (classes, fdef, mtable)  :
>   unable to find an inherited method for function "dbReadTable",
for
> signature "character", "character"
>
> I have created tables in db. but there is this error show up when I  
> try to read the table in my db.. whats wrong with it??
>
>
>
> Thanks a lot.
>
>
> Tammy
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.