html textbox

liunx · Jan 9, 2008

I am using MS SQL server 2000 for my database. I am trying to display a text field value from a table in my database in a HTML textbox. The display is truncated as soon as a blank space is encountered. How can this be corrected? 
 
Eg. I want to display 'Prathima B S' in a text box 
Only 'Prathima' is diplayed. The initials are truncated. 
 
Note: this happens only when i try to display a text value fetched from a table. If i give a constant, there is no problemwhat do you have the database table set at? text or varchar or whatever? also make sure you box is big enough to commadate those letters.I am using MS SQL server 2000 for my database. I am trying to display a text field value from a table in my database in a HTML textbox. The display is truncated as soon as a blank space is encountered. How can this be corrected? 
 
Eg. I want to display 'Prathima B S' in a text box 
Only 'Prathima' is diplayed. The initials are truncated. 
 
Note: this happens only when i try to display a text value fetched from a table. If i give a constant, there is no problem 
 
 
23/01/2002 
 
Yes the textbox is huge and can accomadate the string. 
In my table, one field is a varchar and the other is a char. 
I am getting the same results(as stated above) while trying to display either of them in a html textbox!!!! 
 
__________________ 
pratI use SQL Server, with the nvarchar cell setting and am able to get entire sets of data with tons of spaces. We may need to see your code for the insert.also make sure when you set the value of the textbox it is INSIDE quote: <input type=text name=whatever value="$form.value#"> 
 
if not, it will only assign up the first space.I have printed below the code i am using to display text in a textbox. Here the table field addr is of type nvarchar(as u had suggested previously) and name is of type varchar. Both the fields are being truncated at the first space encountered when displayed in the html textbox!!!! 
 
The size (set to 100) is enough and more as i am filling only 25 characters. 
 
set conn = Server.CreateObject("ADODB.connection") 
set rs=server.CreateObject("ADODB.recordset") 
conn.open "HELPDESK","sa","sa" 
sql="select * from prat1" 
set rs=conn.Execute(sql) 
rs.MoveFirst() 
while not rs.EOF 
cname = rs("cname") 
caddr = rs("addr") 
rs.MoveNext() 
wend 
%> 
<INPUT type="text" id=text1 name=text1 value = <%=cname%>> 
 
<INPUT type="text" id=text2 name=text2 value = <%=caddr%> size=100>Prathima, 
 
I had already suggested that you put your value in quotes, else it will only assign up to the first space... but I see your code without quotes in the value: 
 
<INPUT type="text" id=text1 name=text1 value = <%=cname%>> 
 
<INPUT type="text" id=text2 name=text2 value = <%=caddr%> size=100> 
 
if you view the source you should see that all the data made it into the form tag, but the HTML recognizes only the entry to the first space. 
 
 
change it to: 
 
<INPUT type="text" id=text1 name=text1 value = "<%=cname%>"> 
 
<INPUT type="text" id=text2 name=text2 value = "<%=caddr%>" size=100> 
 
and all should be well. 
 
The reason for this is that HTML responds well to things outside of quotes as long as there are no spaces or special characters. This is really a HTML problem.and for your viewing pleasure, look at the following simplified code.... and view the page that is renered. Notice that without quotes, the HTML will only assign the value up to the space. 
 
 
<html> 
<head> 
<title>pop-up</title> 
</head> 
<body> 
<form> 
<INPUT type="text" id=text1 name=text1 value =myValue> 
 
<INPUT type="text" id=text2 name=text2 value =my value> 
 
<INPUT type="text" id=text2 name=text2 value ="my value"> 
</form> 
</body> 
</html>

html textbox

liunx

Guest