sorel
|
Posted: 01/03/2002, 9:16 AM |
|
For some reason my msSql database is returning a field with what appears to be some type of character padding. I have an inventory DB with 10 char part numbers, but the field is set to allow up to 20 characters. when the data for that field is returned to be used as querystring parameter, it has a bunch of "+" attached to the end of the part number - (M202111238++++++++). I have played with my datatypes without success. I have now set up a trim function in my global settings (the one that has been discussed here), however, I can not figure out how to manage the code to trim the parameter. I can edit the asp code but it would be nice to not have to fix the page everytime its generated. Can this be done within CC?
Thanks!
|
|
|
Brent
|
Posted: 01/03/2002, 10:04 AM |
|
The question you should be asking is how did the value get entered into the table?
If you enter the data using a GUI (not using CC or a web page), do the "+"'s
still get entered?
If they don't get entered then your webpage is likely putting the "+" in.
I use PHP and the URLEncode function will replace each space in the string with
a "+" so these values can be easily passed as part of the URL. To get rid of
the "+"'s the URLDecode function can be used to return the string to its
unencoded value.
|
|
|
|