Works for me in Richfield. Firefox 1.5 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard K Miller Sent: Thursday, April 06, 2006 3:06 PM To: LDS Open Source Software Subject: Re: [Ldsoss] Mapping on lds.org
On Apr 6, 2006, at 2:51 PM, Bryan Murdock wrote: > On 4/6/06, Greg Hart <[EMAIL PROTECTED]> wrote: >> Failed for me on both Safari v2.0.3 and Firefox v1.0.4 with the >> following error: >> >> Error: the XML response that was returned from the server is invalid. >> Received: >> Could not perform query: You have an error in your SQL syntax; check >> the manual that corresponds to your MySQL server version for the >> right syntax to use near 'KEEFE APT 10' AND zip = '94025'' at line 1 > > I got a very similar error: > > Error: the XML response that was returned from teh server is invalid. > > Reveived: > > Could not perform query: You have an error in your SQL syntax; check > the manual that corresponds to your MySQL server version for the right > syntax to use near 'S CIRCLE' AND zip = '98683' at line 1 > > Looks like part of someones address and the zip code in the area. > > Bryan Sloppy coding on my part -- I wasn't escaping my database queries, so somebody's address with an apostrophe fouled it up. Try again now. I also fixed a bug that caused it to fail for wards with 5-digit unit numbers. (I assumed all unit numbers had 6 digits.) Richard _______________________________________________ Ldsoss mailing list [email protected] http://lists.ldsoss.org/mailman/listinfo/ldsoss -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.5/302 - Release Date: 4/5/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.3.5/302 - Release Date: 4/5/2006 _______________________________________________ Ldsoss mailing list [email protected] http://lists.ldsoss.org/mailman/listinfo/ldsoss
