Unanswered: ASP request.form variable content truncates at space in
Please help! I am using data from a form to insert into an Access database record. The value for one of the fields is set automatically based on the value of a querystring that is passed through the URL. I know it passed correctly because when I include a troubleshooting line in my code:
it prints out correctly.
The querystring value is then collected in a form thusly:
<input type="hidden" name="txthouse" size="30" maxlength="50"
However, when the value is put into the database via the
(request.form("txthouse")) variable the information is truncated at the first space. In other words if the value is "Saint Clair", the value inserted into the database is only "Saint". I have been researching this for days and have run out of ideas. Any help would be indescribably appreciated!!!!!