Dear list,
 
Dear list,
I am using read.csv.sql() from the sqldf package to read
individual-based data from a csv file that is too large for R. 
My original file contains a column called “ID” that
identifies the individual. I would like to read in data for only 
one individual at a
time, for example "Bobby". 
read.csv.sql("filename",sql = 'select * from file where ID = “Bobby”') works fine, but 
Name <- "Bobby"
read.csv.sql("filename",sql = 'select * from file
where ID = Name') gives me an error message 
 “Error in sqliteExecStatement(con, statement,
bind.data) : 
RS-DBI driver: (error in statement: no such column: Name)”
 
I would like to use a variable in the select statement because I have many individuals in the original csv file, is this possible ? I have no experience with sql, perhaps someone can kindly point out how to do this correctly or offer an alternative solution ?
Thank you very much and happy Friday,
Juliane 
Dr. Juliane Struve
Fisheries and Aquatic Sciences
7922 NW 71st Street, Gainesville, FL 32653
352-273-3632 (tel)
352-392-3672 (fax)
email:mailto:jstruve@ufl.edu
	[[alternative HTML version deleted]]

