Hi all,
I am trying to insert data from front end(ASP) to oracle database, and it does insert fine, but when I am trying to get that data back to update them from the front end, the text does not show up complete.
Every string if it finds space all data is eliminated from over there.

e.g I entered "BIG BOSS", it enters fine. when I call in front end in the text box all I can see is "BIG" the word "BOSS" is eaten up.
Also if I do a response.write of that field in the earlier line than the text box I can see the data fine as "BIG BOSS".

I did a cstr also did not work.
I have done this thing earlier couple of times but never faced any issue, I dont know whats going on here.

advise please

Thank You

When u assign the value to a text box, use the following:

<input type=text name=test value="<%=rs("test")%>">

Om Prakash

Hey Om_Prakasah, I already got it solved.
Was looking at something else and changing something else, my bad :-)

Thank You

try with the below code
dim vardesc
vardesc=server.htmlencode(rs("desc"))
assign value like value="<%=varDesc%>">