I am trying to use R (version 2.2.1) to extract and analyse data from  
a MySQL database on Mac OS X 10.4.4.  I've installed DBI and RMySQL,  
and it all works fine when I try to extract a single field of data,  
but when I try to extract more than one field R crashes and has to be  
restarted.  The SQL statements run absolutely fine when I try them  
directly in MySQL.  The lines below are a typical example: this  
crashes R as written here but works OK if I delete either the year or  
the sum_serv field from the query.

This problem holds for all queries I've tried in all databases.

Any suggestions about how I might be able to sort out this problem  
would be hugely appreciated.

Tom Love



------------------------------------------------------------------------ 
------------
aus <- dbConnect(drv="MySQL", username="xxx", password="yyyy",  
dbname="Australia")
vol <- dbSendQuery(aus, "SELECT STasman.YEAR, SUM(STasman.SERVICES)  
AS SUM_SERV FROM STasman GROUP BY STasman.YEAR")


	[[alternative HTML version deleted]]


