Re: Help with '&' character

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 the problem is the '&' on the url http://...&campaign=MBI%20List%20-%20Steel%20&%20Concrete

                                             ^
                                             |

there>---------------------------------------- this url is saying: 'campaign' = 'MBI List - Steel ' ' Concrete' = '' Chris Bruce wrote:

The problem is that the '&' character is already in a database. I am trying to do a query where I need to have it as '&', but like I said, when it comes into the script from the url it gets truncated. -- Chris Bruce chris@idextrus.com Idextrus E-Business Architects http://www.idextrus.com 3282 Wilmar Cres. Mississauga, ON L5L4B2 CA 905.828.9189 **************************************************************** This e-mail and its contents are privileged, confidential and subject to copyright. If you are not the intended recipient, please delete this e-mail immediately. Any unauthorized use or disclosure of the information herein is prohibited. On Feb 17, 2004, at 12:40 PM, Miguel J. Jiménez wrote:

Have you tried using '&' ? Chris Bruce wrote:

I am having trouble with a string becoming truncated at an '&' character. I am passing the variable via a link (http://...&campaign=MBI%20List%20-%20Steel%20&%20Concrete) and then when I try to grab the incoming value of campaign into a SELECT query, it becomes SELECT sum(sends) from campaigns where name='MBI List - Steel ' I have tried to urlencode the variable, and also use htmlentities, etc. to no avail. Does anyone have a solution for this? Thanks.

<mjjimenez.vcf>

-----BEGIN PGP SIGNATURE-----

Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAMlbwaxdA/5C8vH8RAhWIAKCgrG9WjjlU++J29eFj5MAnyPUtlgCgpf8s O0pMTmplEDKwsv4APITzBHk= =KS0s -----END PGP SIGNATURE-----