Samer, qc

Greenhorn

+ Follow

2 Posts 2 Threads 0 Cows

since Jan 16, 2001

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Total given

Likes

Total received

Received in last 30 days

Total given

Given in last 30 days

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Samer, qc

java.lang.NullPointerException

Hello,
Can anyone tell me why i'm getting this error:
java.lang.NullPointerException
here is the code:

<jsp:useBean id = "sBean" class = "common.sqlBean" scope ="session" />
function showInfo(){
barcode = document.chkin.textBarcode.value;
caseNumber = barcode.substr(0,1);
dataFormatCode = barcode.substr(1,3);
mediaTypeCode = barcode.substr(4,3);
mediaUnitNumber = barcode.substr(7,1);
/** if have a library, get results */
<%
String barcode = request.getParameter("textBarcode");
String dataFormatDesc = "";
String mediaTypeDesc = "";
String brcd = "";
String mtd = "";
String dfd = "";
%>
if (barcode != " "){
if (barcode.length == 8) {
/** build select statement */
<%
sql = "select media.case_number| |media.data_format_code| |media.media_type_code| |media.media_unit_number";
sql = sql + " from media";
sql = sql + " where media.case_number = '"+ barcode.substring(0,1) + "' and ";
sql = sql + " media.data_format_code = '"+ barcode.substring(1,4) + "' and ";
sql = sql + " media.media_type_code = '"+ barcode.substring(4,7) + "' and ";
sql = sql + " media.media_unit_number = '"+ barcode.substring(7,8) + "'";
dataFormatDesc = "select description from data_format where data_format_code = '"+ barcode.substring(1,4) + "'";
mediaTypeDesc = "select description from media_type where media_type_code = '"+ barcode.substring(4,7) + "'";
/** code goes here to make sure that the old_barcode checkbox is checked*/
/** get values results from sBean */
sBean.setSQLstatement(sql);
if (sBean.getRecords()) {
while (sBean.getNextRecord()) {
brcd = sBean.getColumn("media.case_number| |media.data_format_code| |media.media_type_code| |media.media_unit_number");
}
}else {
%>
alert("Barcode does not exist");
<%
}
/** get value for dataFormatDesc */
sBean.setSQLstatement(dataFormatDesc);
if (sBean.getRecords()) {
while (sBean.getNextRecord()) {
dfd = sBean.getColumn("data_format.description");
}
}
/** get value for mediaTypeDesc */
sBean.setSQLstatement(mediaTypeDesc);
if (sBean.getRecords()) {
while (sBean.getNextRecord()) {
mtd = sBean.getColumn("media_type.description");
}
}
%>
document.chkin.textBarcode.value = "<%= brcd%>";
var oRow, oCell;
var i, j, k;
// Insert rows and cells into the first body.
oRow = oTBody1.insertRow();
oCell1 = oRow.insertCell();
oCell2 = oRow.insertCell();
oCell3 = oRow.insertCell();
oCell4 = oRow.insertCell();
oCell5 = oRow.insertCell();
oCell6 = oRow.insertCell();
oCell7 = oRow.insertCell();
oCell1.innerHTML="<center><input type='checkbox' name='chkbx' value=''></center> ";
oCell2.innerHTML= "<%= brcd%>";
oCell3.innerHTML= "<%= dfd%>";
oCell4.innerHTML= "<%= mtd%>";
oCell5.innerHTML= getValue(document.chkin.Loc) ;
oCell6.innerHTML= dat;
oCell7.innerHTML="<img src='delete2.gif' border='0' alt='Delete' onclick='oTBody1.deleteRow(this)'>";
}
}
}
</script>
<FORM name=chkin>
<DIV>
<INPUT class=btn onclick= "showInfo();" type=button value=OK></TD></TR>
<TABLE class=tblBeige id=oTable cellSpacing=2 cellPadding=2 border=1>
<TBODY id=oTBody0 cellpadding="2" cellspacing="2" border="1">
<TR>
<TD class=general2>Print</TD>
<TD class=general2>Barcode</TD>
<TD class=general2>Data Format Description</TD>
<TD class=general2>Media Type Description</TD>
<TD class=general2>Location Code</TD>
<TD class=general2>Transaction Date</TD></TR></TBODY>
<TBODY id=oTBody1 cellpadding="2" cellspacing="2" border="1"></TBODY>
</TABLE></DIV>
</FORM>
</jsp:useBean>

Samer

23 years ago

Servlets

Jsp in Javascript || Javascript in Jsp

Hello,
I'm VERY new in JSP. I have a javascript function that dynamically creates new rows in a table already defined in the html. I want to put a variable defined in jsp into the javascript function, how do i do that? Here is the javascript function:

thanx,
Samer

23 years ago

Servlets