<%@page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*"%> <%@ include file="../../../Connections/cicero.jsp" %> <% Driver Driverac = (Driver)Class.forName(MM_cicero_DRIVER).newInstance(); Connection Connac = DriverManager.getConnection(MM_cicero_STRING,MM_cicero_USERNAME,MM_cicero_PASSWORD); PreparedStatement Statementac = Connac.prepareStatement("SELECT lexnr, titel FROM dbo.lexikon WHERE titel between 'D' and 'L' and sprache = 'Spanish' ORDER BY titel ASC"); ResultSet ac = Statementac.executeQuery(); boolean ac_isEmpty = !ac.next(); boolean ac_hasData = !ac_isEmpty; Object ac_data; int ac_numRows = 0; %> <% int Repeat1__numRows = -1; int Repeat1__index = 0; ac_numRows += Repeat1__numRows; %> <% String MM_paramName = ""; %> <% // *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters String MM_keepBoth,MM_keepURL="",MM_keepForm="",MM_keepNone=""; String[] MM_removeList = { "index", MM_paramName }; // create the MM_keepURL string if (request.getQueryString() != null) { MM_keepURL = '&' + request.getQueryString(); for (int i=0; i < MM_removeList.length && MM_removeList[i].length() != 0; i++) { int start = MM_keepURL.indexOf(MM_removeList[i]) - 1; if (start >= 0 && MM_keepURL.charAt(start) == '&' && MM_keepURL.charAt(start + MM_removeList[i].length() + 1) == '=') { int stop = MM_keepURL.indexOf('&', start + 1); if (stop == -1) stop = MM_keepURL.length(); MM_keepURL = MM_keepURL.substring(0,start) + MM_keepURL.substring(stop); } } } // add the Form variables to the MM_keepForm string if (request.getParameterNames().hasMoreElements()) { java.util.Enumeration items = request.getParameterNames(); while (items.hasMoreElements()) { String nextItem = (String)items.nextElement(); boolean found = false; for (int i=0; !found && i < MM_removeList.length; i++) { if (MM_removeList[i].equals(nextItem)) found = true; } if (!found && MM_keepURL.indexOf('&' + nextItem + '=') == -1) { MM_keepForm = MM_keepForm + '&' + nextItem + '=' + java.net.URLEncoder.encode(request.getParameter(nextItem)); } } } // create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL + MM_keepForm; if (MM_keepBoth.length() > 0) MM_keepBoth = MM_keepBoth.substring(1); if (MM_keepURL.length() > 0) MM_keepURL = MM_keepURL.substring(1); if (MM_keepForm.length() > 0) MM_keepForm = MM_keepForm.substring(1); %> <html> <!-- #BeginTemplate "/Templates/lexikonspan.dwt" --> <head> <!-- #BeginEditable "doctitle" --> <title>enciclopedia D-K</title> <meta name="Author" content="Christoph Fasse"> <meta name="copyright" content="© 2001 reformiert online"> <meta name="keywords" content="reformiert online, reformiert, Reformierte, Kirche, weltweit, Lexikon"> <meta name="description" content="Der Informationssytem für den reformierten Protestantismus"> <meta name="robots" content="index, follow"> <!-- #EndEditable --> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript"> <!-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> <link rel="stylesheet" href="../../css/text.css"> </head> <body bgcolor="#FFFFFF" background="../../gif-bilder/hg-font.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('../../gif-bilder/sprfs/fraB.gif','../../gif-bilder/sprfs/espB.gif','../../gif-bilder/sprfs/engB.gif','../../gif-bilder/sprfs/deuB.gif','../img-start/top/tostab.gif','../img-start/top/toadb.gif','../img-start/top/toinhb.gif','../img-start/top/todiab.gif','../img-start/top/tounsb.gif','../img-start/fuss/lexb.gif','../img-start/fuss/wwb.gif','../img-start/fuss/aktb.gif','../img-start/fuss/armb.gif','../img-start/fuss/bibb.gif','../img-start/fuss/bildb.gif','../../de/lexikon/images/e3leacPB.gif','../../de/lexikon/images/e3ledkB.gif','../../de/lexikon/images/e3lelqB.gif','../../de/lexikon/images/e3lerzB.gif')" link="#CC6600" vlink="#CC6600" alink="#CC6600" text="#666666"> <span class="unnamed1"></span> <table border="0" cellspacing="0" width="760"> <tr> <td width="11"><img src="../../gifaltst/transparent.gif" width="10" height="1"></td> <td width="230"><img src="../../gifaltst/transparent.gif" width="230" height="1"></td> <td width="11"><img src="../../gifaltst/transparent.gif" width="20" height="1"></td> <td><img src="../../gifaltst/transparent.gif" width="460" height="1"></td> </tr> <tr> <td width="11"> </td> <td width="230"><a name="top"></a></td> <td width="11"> </td> <td> <table border="0" cellspacing="0" cellpadding="0" align="right"> <tr> <td><a href="../index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image32','','../img-start/top/tostab.gif',1)"><img name="Image32" border="0" src="../img-start/top/tostaa.gif" width="91" height="15"></a></td> <td><a href="../adressen/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image26','','../img-start/top/toadb.gif',1)"><img name="Image26" border="0" src="../img-start/top/toada.gif" width="79" height="15"></a></td> <td><a href="../inhalt/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image27','','../img-start/top/toinhb.gif',1)"><img name="Image27" border="0" src="../img-start/top/toinha.gif" width="45" height="15"></a></td> <td><a href="../dialog/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image28','','../img-start/top/todiab.gif',1)"><img name="Image28" border="0" src="../img-start/top/todiaa.gif" width="57" height="15"></a></td> <td><a href="../imp/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image29','','../img-start/top/tounsb.gif',1)"><img name="Image29" border="0" src="../img-start/top/tounsa.gif" width="102" height="15"></a></td> </tr> </table> </td> </tr> <tr> <td width="11"> </td> <td width="230"> </td> <td width="11"> </td> <td> <div align="right"><img src="../../de/images/ROloS.gif" width="185" height="40"></div> </td> </tr> <tr> <td width="11"> </td> <td width="230" valign="top"><!-- #BeginEditable "frame" --> <p align="right"><img src="../../gif-bilder/225x70.gif" width="225" height="70"><br> <img src="../../gifaltst/transparent.gif" width="10" height="5"> <br> <a href="index.jsp"><img src="img/e1lex.gif" width="225" height="45" border="0"></a><br> <a href="index.jsp"><img src="img/e2lexsu.gif" width="225" height="17" border="0"></a><br> <img src="../../gifaltst/transparent.gif" width="8" height="70"> <br> <a href="lexac.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image41','','../../de/lexikon/images/e3leacPB.gif',1)"><img name="Image41" border="0" src="../../de/lexikon/images/e3leacA.gif" width="225" height="15"></a><br> <a href="lexdk.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image42','','../../de/lexikon/images/e3ledkB.gif',1)"><img name="Image42" border="0" src="../../de/lexikon/images/e3ledkPA.gif" width="225" height="15"></a><br> <a href="lexlq.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image43','','../../de/lexikon/images/e3lelqB.gif',1)"><img name="Image43" border="0" src="../../de/lexikon/images/e3lelqA.gif" width="225" height="15"></a><br> <a href="lexrz.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image44','','../../de/lexikon/images/e3lerzB.gif',1)"><img name="Image44" border="0" src="../../de/lexikon/images/e3lerzA.gif" width="225" height="15"></a><br> </p> <table width="220" border="0" cellspacing="0"> <tr> <td><a href="../../de/lexikon/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image40','','../../gif-bilder/sprfs/deuB.gif',1)"><img name="Image40" border="0" src="../../gif-bilder/sprfs/deuA.gif" width="55" height="14"></a></td> <td><a href="../../eng/lexikon/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image37','','../../gif-bilder/sprfs/engB.gif',1)"><img name="Image37" border="0" src="../../gif-bilder/sprfs/engA.gif" width="55" height="14"></a></td> <td><a href="index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image38','','../../gif-bilder/sprfs/espB.gif',1)"><img name="Image38" border="0" src="../../gif-bilder/sprfs/espC.gif" width="55" height="14"></a></td> <td><a href="../../fra/lexikon/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image39','','../../gif-bilder/sprfs/fraB.gif',1)"><img name="Image39" border="0" src="../../gif-bilder/sprfs/fraA.gif" width="55" height="14"></a></td> </tr> </table> <!-- #EndEditable --> </td> <td width="11"> </td> <td valign="top"><!-- #BeginEditable "haupttext" --> <p class="hlfett14">Artículos D - K</p> <ul class="norm12lk"> <% while ((ac_hasData)&&(Repeat1__numRows-- != 0)) { %> <li><A HREF="lexartik.jsp?<%= MM_keepNone + ((MM_keepNone!="")?"&":"") + "lexnr=" + (((ac_data = ac.getObject("lexnr"))==null || ac.wasNull())?"":ac_data) %>"><%=(((ac_data = ac.getObject("titel"))==null || ac.wasNull())?"":ac_data)%></A><br> </li> <% Repeat1__index++; ac_hasData = ac.next(); } %> </ul> <% if (ac_isEmpty ) { %> <p class="hlfett12">¡Dentro de poco tiempo Ud. dispondrá de artículos enciclopédicos en español! </p> <% } /* end ac_isEmpty */ %> <!-- #EndEditable --> </td> </tr> <tr> <td width="11"> </td> <td width="230" valign="top"> </td> <td width="11"> </td> <td valign="top"> <table border="0" cellspacing="0" width="376" align="center"> <tr> <td><a href="../aktuell/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image301','','../img-start/fuss/aktb.gif',1)"><img name="Image301" border="0" src="../img-start/fuss/akta.gif" width="79" height="15"></a></td> <td><a href="../weltweit/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image311','','../img-start/fuss/wwb.gif',1)"><img name="Image311" border="0" src="../img-start/fuss/wwa.gif" width="126" height="15"></a></td> <td><a href="../rwb/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image331','','../img-start/fuss/armb.gif',1)"><img name="Image331" border="0" src="../img-start/fuss/arma.gif" width="34" height="15"></a></td> <td><a href="../bibliothek/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image341','','../img-start/fuss/bibb.gif',1)"><img name="Image341" border="0" src="../img-start/fuss/biba.gif" width="77" height="15"></a></td> <td><a href="../bildung/index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image351','','../img-start/fuss/bildb.gif',1)"><img name="Image351" border="0" src="../img-start/fuss/bilda.gif" width="95" height="15"></a></td> <td><a href="index.jsp" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image361','','../img-start/fuss/lexb.gif',1)"><img name="Image361" border="0" src="../img-start/fuss/lexc.gif" width="93" height="15"></a></td> </tr> </table> </td> </tr> <tr> <td width="11"> </td> <td width="230" valign="top"> </td> <td width="11"> </td> <td valign="top"> <script language="JavaScript"> <!-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> <script language="JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } //--> </script> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td valign="bottom" width="37"> <div align="center"><a href="#top" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('top1','','../../gif-bilder/topb.gif','top','','../../gif-bilder/topb.gif',0)"><img name="top1" border="0" src="../../gif-bilder/topa.gif" width="30" height="30" alt="to the top"></a></div> </td> <td width="100%"> <div align="right"><font size="1" face="Arial, Helvetica, sans-serif" color="#666666"><br> Last changes: <!-- #BeginDate format:IS1 -->2001-10-29<!-- #EndDate --> /fas<br> © <a href="mailto:fasse@reformed-online.com">reformed online</a> 2001</font></div> </td> <td width="25" valign="bottom"> <div align="center"><a href="#top" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('top1','','../../gif-bilder/topb.gif','top','','../../gif-bilder/topb.gif',0)"><img name="top" border="0" src="../../gif-bilder/topa.gif" width="30" height="30" alt="to the top"></a></div> </td> </tr> </table> </td> </tr> </table> <p> </p> </body> <!-- #EndTemplate --> </html> <% ac.close(); Connac.close(); %>