Question Locked

ASP / Form Help Required

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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
%>

1 reply

This discussion is closed to new replies.