Hey guys. Can anybody tell me what is wrong with this line of SQL? I keep getting a syntax error message.
Here is the line:
prepStat = connection.prepareStatement("INSERT INTO WeatherHistory (Date, Location, Overview, Temperature, WindDirection, WindSpeed, Pressure) VALUES ('"+date+"','"+location+"','"+temp+"','"+windDir+"','"+windSpd+"','"+pressure+"')");
All the field names and variables exist correctly, so I really can't see what is wrong here!