why i can't get the whole string when rs.getString() called ?

[Alvin chew]

hi, i using rs.getString("pro_desc") to get the data from field , the data let say suppose to be "this is just testing" in the "pro_desc" field(varchar(100)) but after i run rs.getString() ...it only show me "this" word but other have lost ..

i get data from DB and pass it to html textfield as following code

<input name="pro_desc" type="text" value=<%=rs.getString("pro_desc")%>></td>

can i know what is the problem ? thank you

[Jeremy Wilson]

can you include information on what type of database and a sample of what your code looks like, that would help. Basically wondering if you are using the jdbc to odbc bridge.

[Jeanne Boyarsky]

Alvin,
You need quotes around the value attribute:

<input name="pro_desc" type="text" value="<%=rs.getString("pro_desc")%>"></td>

Otherwise, the browser only uses the attribute value up to the space. The rest would be interpretted as another attribute that the browser doesn't understand.

I'm moving this to the JSP forum because it is more about JSP formatting than JDBC.

[Alvin chew]

i using mysql and using jdbc driver

[Alvin chew]

thanks, Jeanne Boyarsky ...yes, is the problem of quote

[nareshkumar kumar]

u can place that one in the " "