search for: position_to_zipcod

Displaying 1 result from an estimated 1 matches for "position_to_zipcod".

Did you mean: position_to_zipcode
2009 May 25
3
Interpolating variables within (RODBC library) SQL statements for MySQL
Hi everyone, I am desperately looking for a method to interpolate strings within an SQL statement as follows: I get a lot of rows out of a database (in my example POSITION_to_ZIPCODE Database with holds records for German ZIP Code <--> Gauss-Krueger Coordinate System ) and want this to be selected and computed individually row by row as follows: library(RODBC) channel <- odbcConnect("database") pos_to_zip <- sqlQuery(channel, "select YPOS, XPOS FROM...