[Ldsoss] Mapping on lds.org

[Jim Hansen]

Works for me in Richfield.  Firefox 1.5
 

-----Original Message-----
From: ldsoss-bounces at lists.ldsoss.org
[mailto:ldsoss-bounces at lists.ldsoss.org] 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 <greg at queezy.com> 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
Ldsoss at lists.ldsoss.org
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