<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2658.24">
<TITLE>Accessing a table from a JSP</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi there</FONT>
<BR><FONT SIZE=2>I have added a table called membership_applications to the database.</FONT>
</P>
<P><FONT SIZE=2>How do I set up a JDBC connection to that table ?</FONT>
<BR><FONT SIZE=2>I cant figure out the Connection Name to do this.</FONT>
</P>
<P><FONT SIZE=2>I want to write :</FONT>
<BR><FONT SIZE=2>a JSP with a Insert (SQL) Query </FONT>
<BR><FONT SIZE=2>and </FONT>
<BR><FONT SIZE=2>a JSP with a Select (SQL) Query</FONT>
</P>
<P><FONT SIZE=2>Can I use the OpenCms API to make calls to the database to access my table?</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>With kind regards</FONT>
<BR><FONT SIZE=2>Nick Michael</FONT>
<BR><FONT SIZE=2>tel 2-9032</FONT>
<BR><FONT SIZE=2>cell 082-508-1950</FONT>
</P>
<DIV>__________________________________________________________________________________________________________________________________</DIV>
<DIV><SPAN class=236492506-24112004><FONT size=2><SPAN lang=EN-ZA
style="FONT-SIZE: 9pt; LAYOUT-GRID-MODE: line; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-ZA; mso-fareast-language: EN-US; mso-bidi-language: AR-SA"><STRONG><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Standard
Bank Disclaimer and Confidentiality Note<O:P></O:P></SPAN></STRONG>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN
style="FONT-SIZE: 9pt; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">This
e-mail, its attachments and any rights attaching hereto are, unless the context
clearly indicates otherwise, the property of Standard Bank Group Limited
</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">and/or
its subsidiaries ("the Group"). It is confidential, private and intended for the
addressee only.</SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Should
you not be the addressee and receive this e-mail by </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">mistake,
kindly notify the sender, and delete this e-mail, immediately and do not
disclose or use same in any manner whatsoever. </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Views and
opinions expressed </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">in this
e-mail are those of the sender unless clearly stated as those of the Group. The
Group </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">accepts
no liability whatsoever for any loss or damages </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">whatsoever
and howsoever incurred, or suffered, resulting, or arising, from the use of this
email or its attachments.</SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'"></SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">The
Group does not warrant the integrity of this </SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">e-mail
nor that it is free of errors, viruses, interception or interference.
</SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-ansi-language: EN-GB">Licensed
divisions of the Standard Bank Group are authorised financial services providers
in terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002
(FAIS).</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText
style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal; TEXT-ALIGN: justify"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><O:P></O:P></SPAN></P>
<P class=MsoBodyText style="MARGIN: 0cm 0cm 0pt; LINE-HEIGHT: normal"><SPAN
lang=EN-US
style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Arial Unicode MS'">For
information about the Standard Bank Group Limited visit our website <A
href="http://www.standardbank.co.za"><FONT
color=#0000ff>http://www.standardbank.co.za</FONT></A></SPAN></P></SPAN></FONT></SPAN><FONT
color=#0000ff><FONT
color=#000000>__________________________________________________________________________________________________________________________________<BR></FONT></DIV></FONT>
</BODY>
</HTML>