|ASP form collection iteration deleting spaces|
| 10:14 pm on Mar 30, 2013 (gmt 0)|
I have this weird problem.
All the field values from a form collection iteration get the spaces deleted.
For example if a field value is "John Doe", it gets written as "JohnDoe" into the database.
Or in the case below, into a text file (used for troubleshooting purposes).
I can't figure this out.
I tried urlencoding and htmlencoding, nothing works.
Thanks in advance
for x = 1 to Request.form.count()
| 10:28 pm on Mar 30, 2013 (gmt 0)|
By the way, if i use:
the form fields are correct (with spaces).
It is for sure the form collection iteration that is killing the spaces.
| 11:14 pm on Mar 30, 2013 (gmt 0)|
It sounds like you have a filter, possible intended to remove unwanted characters, that is removing the spaces.
Every form should use one, so there should be one there somewhere. Check the input fields and if they look something like cleanName(request("name")) then "cleanName" is the name of the function being used.
| 11:47 pm on Mar 30, 2013 (gmt 0)|
There are no filters, the form results arrive ok at the page.
I found a work around.
I am splitting the form results at the "&" and grabbing the results.
Still not sure why the form collection iteration was removing the spaces.
Myarray = Split(Request.Form, "&")
For i = 0 To UBound(Myarray)
writefile.writeline Split(Myarray(i),"=", 2)(0) ' field name
writefile.writeline Split(Myarray(i),"=", 2)(1) & vbcrlf ' field value