ASP / Form Help Required
I have the following Form which gets its input from a Access Database.
Everything works fine but in the decription field only the first word is loaded from the database field.
I have placed a response.write at the beginning to check that the field does contain everything I expect it to.
For example if the description field had "This is the final test" only "This" would appear on the form.
----------------------------------------------
<%
Response.Buffer = true
Dim Rec_Auction
Dim Recordset1_numRows
Rec_Auction = CStr(Request("FindEntry0"))
dim cnn,rst
set cnn = Server.CreateObject("ADODB.Connection")
set rst = Server.CreateObject("ADODB.RecordSet")
cnn.Open "driver={Microsoft Access Driver (*.mdb)};;DBQ=d:\Database\TaskRegister.mdb;"
sqltext = "SELECT * FROM TaskManager WHERE TaskEntry = '" + Rec_Auction + "' order by TaskEntry asc"
rst.Open sqltext,cnn,3,3
'rst.CursorType = 0
'rst.CursorLocation = 2
'rst.LockType = 1
rst_numRows = 0
response.write rst.Fields.item("TaskDescription")
%>
Task Maintenance
| Task Maintenance |
?
<% If Not rst.EOF Or Not rst.BOF Then %>
| EXIT |
?
?
?
<%
rst.Close()
Set rst = Nothing
%>