PDA

Click to See Complete Forum and Search --> : Storing SQL Server value into Input Text Value???


Salvatore
Dec 21st, 2004, 01:04 PM
Can someone please take a look at the code below and explain why the value that shows within the Input Textbox is only a partial of the complete value....

Here is what happens....the SQL Server value shows as an example: Brandon Arnold...so when I retrieve this value to place within an Input Textbox...I get just Brandon...

Here is the code that I am working with:
<%
String lid = (String)request.getSession(true).getAttribute("lid");

ddpe.sqltools.SQLTool q1= new ddpe.sqltools.SQLTool("sun.jdbc.odbc.JdbcOdbcDriver","SAMSWeb2",true);
q1.doSelectQuery("Select SalesRep from tblLogin where ID='"+lid+"'");
String repRow[];

repRow=q1.s_next();

for (int r=0; r<q1.getNumCols(); r++) {
out.println("<input type=text name=repName value="+repRow[r]+"></input>");
}

q1.close();
%> As I stated the code works without errors, but it is not providing exactly what is shown in SQL Server.

Thank you...