i got problem to load data from file to database. is it because my sql
command?
def uploadarc
@results = $m.query(“LOAD DATA LOCAL INFILE
‘C:/InstantRails/rails_apps/cron/sample.txt’ INTO TABLE archives FIELDS
TERMINATED BY ‘\n’ ENCLOSED BY '”’ LINES TERMINATED BY ‘\n\n’")
flash[:notice]=" Uploaded "
redirect_to :controller => ‘test’, :action => ‘index’