Filemaker not correctly URL encoding this field...???
Posted on 2006-05-28
I'm a web developer and I've got a client using Filemaker. I've created a small script for them which charges credit cards with authorize.net using data supplied from the current invoice they're looking at when they click a "charge card" button within Filemaker. A URL is created using data from the invoice as querystring values. The problem is, it isn't correctly URL encoding the string. It's getting spaces correct, using %20 for spaces. The only problem I've run into is with # signs. It should put %23 for a # sign in a URL encoded string, but it's not, it's just leaving the # sign as is. This being the case, the web browser sees this as an anchor and stops reading the querystring values, so I can't use the values beyond the # sign in my script.
Any information on how I can make Filemaker handle #'s correctly when sending to a URL would be greatly appreciated. Thanks!