values passed in URL [Resolved]

[ober0330]

If I there is a space that is submitted in a form as a value in a textbox, it puts it in the URL as %A0. This is causing problems in my update statement because it says it can't convert a varchar to a float.

Does anyone know how to get around that or deal with the %A0, which prints out as a space even after a trim?

[Electroman]

I don't understand the probelm here? And doesn't a space turn into %20 ?

If in the Text box it was a space then in the URL it will be %20 then when you read it in through the $_GET['name'] it will have been changed back into a space for you?

[ober0330]

Ok, well it must not be a space then, because nothing I do works and it's throwing an error saying my SQL statement is invalid. If I go back to the page there is a space in the textbox, and if I hit the backspace key and hit submit again, the UPDATE works, and the value being passed is nothing, where before it was "%A0".

[techgnome]

Before adding it to your sql insert, you need to use urldecode

TG

[ober0330]

I ended up doing this:

if($val != urldecode('%A0') 

and that seems to work.