Will this code open a table named OWNER? <HTML> <HEAD> <META HTTP-EQUIV=”Content
ID: 3771132 • Letter: W
Question
Will this code open a table named OWNER?
<HTML>
<HEAD>
<META HTTP-EQUIV=”Content-Type”CONTENT=:”text/html;charset=windows-“>
<TITLE>Owner</TITLE>
<HEAD>
<BODY>
<%
Dim ObjConn, ObhRecordSet, varSql
If IsObject(Session(“_conn”)) Then’if alredy have a connection, use it
Set objConn= Session(“_conn”)
Else
Set objConn = Server.CreateObject(“ADODB.connection”)’ get connection
Objconn.open “ViewRidgeSS” ‘open VRG database using oepraitn gsystem authentication
objConn.IsolationLevel = adXactReadCommitted ‘avoid dirty reads
Set Session (“_conn’) = objConn
End If
Set ObjRecordSet = Server.creatObect (“ADODB.Recordset”)’create the record set object
varSql = “Select * FROM Owner” ‘ set up SQL cpmmand
bojRecordSet.Open varSql, ovjConn, adOpenStatic, adLockReadOnly’ static with no need to update
%>
<TABLE BORDER = BGCOLOR = #ffffff CELLSPACING =5><FONTFACE = “Arial” COLOR=#000000>
<CAPTION><B><varTableName%>(inoracle database)</B></CAPTION></FONT>
<Thead><TR>
<%
varNumCols = objRecordSet.Fields.Count
For varl - 0 to varNumCols - 1
SetobjField = objRecordSetField(var1)
if objFieldName<>varKeyName The'omit surrogate key%>
<TH BGCOLOR=#c0c0c0 BORDERCOLOR=#000000><FONT SIZE =2 FACE="ARIAL" COLOR=#000000><%objFieldName%>
</FONT> </TH>
<%
End If
Next%>
</TR></THEAD>
<TBODY>
<%
On Error Resume Next
objRecordSet.MoveFirst
do while Not objRecrodSet.eof
%>
<TR VALIGN=TOP>
<%
varNumCols=objRecordSet.Field.Count
For var1= 0 to varNumCols-1
Set objField = objRecordSet.Fields(var1)
If objFieldName<> varKeyName Then 'omit surrogate key%>
<TD BORDERCOLOR=#c0c0c0><FONT SIZE =2 FACE="Arial" COLOR=#000000><%=Server HTMLEnclode
(objField Value)%><BR></FONT></TD>
<%
End If
Next%>
</TR>
<%
</FONT></TD>
<%
End If
Next%>
</TR>
<%
objRecordSet.MoveNext
loop%>
</TBODY>
</TABLE>
</BODY>
</HTML>
Explanation / Answer
No, its not opening.
Save in notepad using .html and try to open in browser. Its not showing table names owner
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.