From: Jack Tanner <ihok_at_hotmail.com>

Date: Sat 31 Jul 2004 - 02:23:37 EST

R-help@stat.math.ethz.ch mailing list

https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Sat Jul 31 03:02:28 2004

Date: Sat 31 Jul 2004 - 02:23:37 EST

> Not sure about what sqlQuery is doing but you can wrap your return value > in a eval(parse(text = x)) to evaluate the "as.integer(.)" string. As in, > > a <- eval(parse(text = a))

This works, except it doesn't.

> a <- sqlQuery(irrdb, "select count(field) from mytable where field=1")

> print(a)

count(field)

1 8

> paste(a)

[1] "as.integer(8)"

> eval(parse(text=a))

[1] 8

> paste(eval(parse(text=a)))

[1] "8"

That's great, but...

> paste(list(eval(parse(text=a)), eval(parse(text=a))))

[1] "as.integer(8)" "as.integer(8)"

Argh!!! What the hell is going on?

R-help@stat.math.ethz.ch mailing list

https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Sat Jul 31 03:02:28 2004

*
This archive was generated by hypermail 2.1.8
: Fri 18 Mar 2005 - 02:41:26 EST
*