Quote:
|
Originally Posted by valic
Goldfndr,
Great job on the new scripts !!
Wondering if anyone else has seen the following error?
Attachment 4812
From what I see, it looks like the apostrophe hasn’t been cleaned from the SSID:
Looking at the code here is what I see.
SubRoutine “OnPositionChangeDatabase” Cleans the SSID (Position Table)
SubRoutine “OnGPSPositionDatabase” Doesn’t clean the SSID (Readings Table)
SubRoutine “OnScanResultDatabase” Doesn’t clean the SSID (Readings Table) |
There's two ways to resolve that problem in an SQL query.
Depending upon what I'm doing I either do a replace of the ' with two of them '' or I replace the ' with '. I believe the general accepted way is to replace it with two of them '', not a ".