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
troubleshooting code: =============================================== set fs=server.createobject("Scripting.FileSystemObject") filename=server.mappath("test.txt") set writefile=fs.OpenTextFile(filename,2,true)
for x = 1 to Request.form.count() writefile.writeline Request.form.item(x) next
writefile.close set writefile=nothing set fs=nothing
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.