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:
<%response.write(request.querystring("house"))%>
it prints out correctly.
The querystring value is then collected in a form thusly:
<input type="hidden" name="txthouse" size="30" maxlength="50"
value=<%=request.querystring("house")%>
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!!!!!

woudl you like to post all of the code relating to the datbase insert so we can get a better idea of how this is all working?

Hi - Yes - here is the insert code. The field in question is the last one (txthouse) whose value it taken from <%=request.querystring("house")%>
Your help is immensely appreciated!

strSql="Insert into [residents](enteredby,dateentered,firstname,lastname,house) values( "& "'" & replace(request.form("txtenteredby"),"'","''") & "',"& "'" & replace(request.form("txtdateentered"),"'","''") & "',"& "'" & replace(request.form("txtfirstname"),"'","''") & "',"& "'" & replace(request.form("txtlastname"),"'","''") & "',"& "'" & replace(request.form("txthouse"),"'","''") & "')"

conn.open mydsn

conn.execute(strsql)

conn.close

set conn=nothing

doh! missed the fault. it was in your first post...

Holy cow! You're the greatest! I have been working on this problem for two days and the answer comes down to a set of quotes - go figure.
I am very, very grateful for your help!!

no worries, happy to help out. drop by if you need a hand with anything else.