-----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
[EMAIL PROTECTED]

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-----

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to