Re: Help with '&' character

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>