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