I am submitting test-related data via a form to Access using a CGI script. Some of the text fields (e.g., user's name) contain spaces (John Smith). When the data is posted to Access, spaces are removed (JohnSmith). I have used the same script with success to post test results directly from a test(submit test results), but when doing it manually using a form and user-defined variables, I have this problem. Any suggestions to preserve the spaces in my data?I am submitting test-related data via a form to Access using a CGI script. Some of the text fields (e.g., user's name) contain spaces (John Smith). When the data is posted to Access, spaces are removed (JohnSmith). I have used the same script with success to post test results directly from a test(submit test results), but when doing it manually using a form and user-defined variables, I have this problem. Any suggestions to preserve the spaces in my data?
