New updated patch, that fixes what I broke with the previous patch, which just shows you shouldn't be coding when under the influence of morphine...
This patch, which should be applied to the original gpskismet.c from the gpsdrive 2.10pre3 cvs checkout, properly escapes the characters in a SSID, that will generate a malformed SQL update or insert query. Just as the previous patch, it also adds a printout of the original SSID and the escaped SSID, if gpsdrive is run with debug output enabled.
The patch should be saved in the toplevel gpsdrive source directory, and applied with the command :
patch -p0 -l < newfixkismetescape.patch.txt
The patch can also be applied to the gpsdrive 2.09 source, with the same command, and has been tested with that version as well.
Sorry for the inconvenience...
Dutch