Displaying 2 results from an estimated 2 matches for "local_code".
Did you mean:
loc_code
2008 Mar 14
2
MySQL IN clause for an array of strings
...;','' if !zips_clause.blank?
zips_clause += ''\'''' + z + ''\'''' # wrap string in single-quotes
}
zips_clause = ''('' + zips_clause + '')''
conditions = sanitize_sql(["updated_at > ? AND local_code IN ?",
since_date, zips_clause])
This is the resulting SQL:
SELECT * FROM tips WHERE (updated_at > ''2008-03-14 11:55:29'' AND
local_code IN ''(\''94952\'',\''08054\'',\''11111\'')'')
And this is the error:...
2010 Oct 09
1
Loss of precision in read.csv.
...type name latitude_deg longitude_deg
elevation_ft continent iso_country iso_region municipality scheduled_service
1 6523 00A heliport Total Rf Heliport *40.0708 -74.9336 *
11 <NA> US US-PA Bensalem no
gps_code iata_code local_code home_link wikipedia_link keywords
1 00A 00A
And the precision is lost which we can show by using readLines:
fred<-readLines("airports.csv")
> fred[2]
[1] "6523,\"00A\",\"heliport\",\"Total Rf Heliport\",*
40.07080078125,...