	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

6.9

Help altering code for front page database

Asked by elliottbenzle in FrontPage-Expressions

I'm helping a friend to update his site. The person who originally built the site used front page and asp and I'm having some trouble figuring out how front page accesses a particular database.

Here is the code where the page accesses the DB:


<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM q_articles"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="subed"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=50
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="date_year"
fp_sMenuValue="date_year"
fp_sColTypes="&date_year=202&date_day=202&month_text=202&bulletin_id=202&title=202&link=203&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td style="padding-left: 0; padding-right: 5px; padding-bottom:5px" align="center">
<p align="left"><span style="font-size: 8pt">■</span></td>
<td style="padding-bottom: 5px"><span style="font-size: 11pt">
<a href="<%=FP_FieldLink(fp_rs,"link")%>">
<%=FP_FieldVal(fp_rs,"title")%></a></span><span style="font-size: 8pt"> 
</span><font style="font-size: 8pt">
<%=FP_FieldVal(fp_rs,"month_text")%> <%=FP_FieldVal(fp_rs,"date_day")%> <%=FP_FieldVal(fp_rs,"bulletin_id")%></font></td>
</tr>



My question is, where is the connection string? I can't find it anywhere. I thought it might be in the include file  although that file doesn't exist. Strangely enough though, when I remove that include code the page no longer works. Also why is everything commented? It appears that many of these comments are still being processed as code, why is this? Thanks for any help. Below is the entire page code.

View the Solution FREE for 30 Days

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:
185:
186:
187:
188:
189:
190:
191:
192:
193:
194:
195:
196:
197:
198:
199:
200:
201:
202:
203:
204:
205:
206:
207:
208:
209:
210:
211:
212:
213:
214:
215:
216:
217:
218:
219:
220:
221:
222:
223:
224:
225:
226:
227:
228:
229:
230:
231:
232:
233:
234:
235:
236:
237:
238:
239:
240:
241:
242:
243:
244:
245:
246:
247:
248:
249:
250:
251:
252:
253:
254:
255:
256:
257:
258:
259:
260:
261:
262:
263:
264:
265:
266:
267:
268:
269:
270:
271:
272:
273:
274:
275:
276:
277:
278:
279:
280:
281:
282:
283:
284:
285:
286:
287:
288:
289:
290:
291:
292:
293:
294:
295:
296:
297:
298:
299:
300:
301:
302:
303:
304:
305:
306:
307:
308:
309:
310:
311:
312:
313:
314:
315:
316:
317:
318:
319:
320:
321:
322:
323:
324:
325:
326:
327:
328:
329:
330:
331:
332:
333:
334:
335:
336:
337:
338:
339:
340:
341:
342:
343:
344:
345:
346:
347:
348:
349:
350:
351:
352:
353:
354:
355:
356:
357:
358:
359:
360:
361:
362:
363:
364:

           
           
             <%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/con_str.asp" -->
<%
Dim rsbreaking
Dim rsbreaking_cmd
Dim rsbreaking_numRows
 
Set rsbreaking_cmd = Server.CreateObject ("ADODB.Command")
rsbreaking_cmd.ActiveConnection = MM_con_str_STRING
rsbreaking_cmd.CommandText = "SELECT * FROM news ORDER BY sortid ASC" 
rsbreaking_cmd.Prepared = true
 
Set rsbreaking = rsbreaking_cmd.Execute
rsbreaking_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
 
Repeat1__numRows = -1
Repeat1__index = 0
rsbreaking_numRows = rsbreaking_numRows + Repeat1__numRows
%>
<html>
<!-- Site created by Kukau.com aka Olekoi Palau -->
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="keywords" content="Palau, Belau, Republic of Palau, Palau Government, Palau OEK,  Palau Executive, Palau Official Web Site, Legislative, Palau News, Palau Links, Palau Investing,  Palau Regulations, Senate, House of Delegates, Boards, Joint Resolutions, Resolutions, Senate Bill,  Commissions, Palau Senate, Olbiil Era Kelulau">
<meta name="description" content="The official website of the Government of the Republic of Palau, Olbiil Era Kelulau, Senate">
<title>ROP Olbiil Era Kelulau Senate | News, Press Releases &amp; Bulletins</title>
<SCRIPT language=JavaScript>
<!--
function click() {
if (event.button==2) {
alert('Please contact the Site Administrator regarding website content.  Sulang!');
}
}
document.onmousedown=click
// --> 
</SCRIPT>
<style fprolloverstyle>
A:hover {color: #000099}
.style1 {
	color: #666666;
	font-size: 12px;
}
.style2 {color: #cc0000}
</style>
</head>
 
<body style="font-family: Arial; font-size: 10pt; " topmargin="0" link="#000000" vlink="#000000" alink="#000000" bgcolor="#666666" bgproperties="fixed" background="images/oekbackground.jpg" bottommargin="0">
 
<div align="center">
  <table border="0" width="800" style="border-width:0px; font-family:Arial; font-size:10pt; " cellspacing="0" cellpadding="0" bordercolor="#C0C0C0" bgcolor="#FFFFFF">
    <tr>
      <td style="border-style:none; border-width:medium; " height="21" bordercolor="#FFFFFF" bgcolor="#000040" background="images/headers/headeroekborder2.jpg">
      <p align="left">&nbsp;</td>
    </tr>
    <tr>
      <td bordercolor="#FFFFFF" valign="top" style="border-style:none; border-width:medium; padding:0; ">
      <p align="center">
      <object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="800" height="125">
        <param name="movie" value="images/headersub.swf">
        <param name="quality" value="High">
        <embed src="images/headersub.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="800" height="125" quality="High"></object>
      </td>
    </tr>
    <tr>
      <td bgcolor="#000040" bordercolor="#FFFFFF" background="images/headers/headeroekborder2.jpg" height="20" style="border-top-style: none; border-top-width: medium">&nbsp;
      </td>
    </tr>
    <tr>
      <td bgcolor="#DCDCBA" bordercolor="#FFFFFF" height="20" nowrap>
<!--webbot bot="Include" U-Include="MainMenu.htm" TAG="BODY" startspan -->
<script language="JavaScript" type="text/javascript" src="menu2_scr.js">
</script>
  <div align="center">
  <table  id="m1mainSXMenu2" cellspacing="0" cellpadding="4" border="0" style="font-family: Arial; font-size: 8pt" >
    <tr align="center">
      <td onMouseOver="chgBg(m1,'m1tlm0',3);exM(m1,'m1mn1','m1tlm0',event)" onMouseOut="chgBg(m1,'m1tlm0',0);coM(m1,'m1mn1')" id="m1tlm0" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm0a" class="m1CL0">
      <span style="font-size: 8pt">WELCOME</span></a></font><span style="font-size: 8pt"></td>
      <td onMouseOver="chgBg(m1,'m1tlm1',3);exM(m1,'m1mn2','m1tlm1',event)" onMouseOut="chgBg(m1,'m1tlm1',0);coM(m1,'m1mn2')" id="m1tlm1" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm1a" class="m1CL0">
      SENATORS</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm2',3);exM(m1,'none','',event)" onMouseOut="chgBg(m1,'m1tlm2',0,1)" id="m1tlm2" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm2a" class="m1CL0" href="http://senate.palauoek.net/committees.asp" >
      COMMITTEES</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm3',3);exM(m1,'m1mn3','m1tlm3',event)" onMouseOut="chgBg(m1,'m1tlm3',0);coM(m1,'m1mn3')" id="m1tlm3" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm3a" class="m1CL0">
      LEGISLATION</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm4',3);exM(m1,'none','',event)" onMouseOut="chgBg(m1,'m1tlm4',0,1)" id="m1tlm4" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm4a" class="m1CL0" href="http://senate.palauoek.net/news.asp" >
      NEWS</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm5',3);exM(m1,'m1mn4','m1tlm5',event)" onMouseOut="chgBg(m1,'m1tlm5',0);coM(m1,'m1mn4')" id="m1tlm5" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm5a" class="m1CL0">
      ABOUT US</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm6',3);exM(m1,'none','',event)" onMouseOut="chgBg(m1,'m1tlm6',0,1)" id="m1tlm6" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm6a" class="m1CL0" href="http://www.palauoek.net/forum/photos/">PHOTOS</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm7',3);exM(m1,'none','',event)" onMouseOut="chgBg(m1,'m1tlm7',0,1)" id="m1tlm7" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm7a" class="m1CL0" href="http://senate.palauoek.net/links.asp" >
      LINKS</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm8',3);exM(m1,'none','',event)" onMouseOut="chgBg(m1,'m1tlm8',0,1)" id="m1tlm8" class="m1mit" bgcolor="#DCDCBA" nowrap>
      <font face="Verdana">
      <a id="m1tlm8a" class="m1CL0" href="http://senate.palauoek.net/contactus.asp" >
      CONTACT US</a></font></td>
      <td onMouseOver="chgBg(m1,'m1tlm9',3);exM(m1,'none','',event)" onMouseOut="chgBg(m1,'m1tlm9',0,1)" id="m1tlm9" class="m1mit" bgcolor="#DCDCBA" nowrap>
      </span>
      <font face="Verdana">
      <a id="m1tlm9a" class="m1CL0" href="http://senate.palauoek.net/sitemap.asp" >
      <span style="font-size: 8pt">SITE MAP</span></a></font></td>
    </tr>
  </table>
</div>
<!--webbot bot="Include" i-checksum="31208" endspan --></tr>
    <tr>
      <td bgcolor="#FFFFFF" bordercolor="#FFFFFF" style="padding-top: 0; padding-bottom: 0">
      <p align="center"><span style="font-size: 4pt">&nbsp;</span></td>
    </tr>
    <tr>
      <td style="font-family:Arial; font-size:11pt; border-top-width:medium; padding-left:60px; padding-right:60px; padding-top:60px; padding-bottom:80px" bordercolor="#FFFFFF" align="left" valign="top" height="600">
 
<p align="center" style="margin-bottom: 40px">
      <img border="0" src="images/headers/news.gif" alt="News. Press Releases &amp; Bulletins"></p>
  <span style="text-decoration: none; "> 
      <table border="0" cellspacing="0" cellpadding="0" style="border:10px solid #FFFFFF; float: right">
        <tr>
          <td>
<!-- Start Bravenet.com Service Code -->
<script type="text/javascript">
function validate_elist_911020020()
{
    e = document.getElementById('elist_err911020020');
    e.innerHTML="";
    if (!document.getElementById('elistaddress911020020').value.match(/^[-!#$%&'*+./0-9=?A-Z^_`a-z{|}]+@[-!#$%&'*+/0-9=?A-Z^_`a-z{|}~.]+?.+[a-zA-Z]{2,4}$/i)) 
    {
        e.innerHTML += 'Invalid email address';
    }
    if (e.innerHTML != "") return false;
    return true;
}
</script>
<div align="center">
<div style="border:1px solid #999999; width:235px; margin: 0px; background-color:#F2F4FA;">
<form action="http://pub38.bravenet.com/elist/add.php" method="post" style="margin:0px;" onSubmit="return validate_elist_911020020()">
<div style="background-color:#DBE0F5; padding:3px; font:12px arial; color:black;"><b>Join the 
  Palau Senate Mailing List</b></div>
<div style="margin:10px; font: 11px arial; color: black; text-align:right;">
<div style="margin-bottom:5px;">Enter your name and email address below:</div>
Name: <input type="text" id="elistname" name="ename" size="25" maxlength="60" style="width: 170px"><br>
Email: <input type="text" name="emailaddress" id="elistaddress911020020" size="25" maxlength="100" style="width: 170px"><br>
<input type="radio" name="action" value="join" checked style="border: 0px;">Subscribe&nbsp;
<input type="radio" name="action" value="leave" style="border: 0px;">Unsubscribe&nbsp;
<input type="hidden" name="usernum" style="border: 0px solid black; height: 0px; width: 0px;" value="3178771688"><input type="hidden" name="cpv"  style="border: 0px solid black; height: 0px; width: 0px;"  value="1">
<input type="submit" name="submit" value="GO" style="font-family: Verdana; font-size: 8pt"></div>
<div style="color: red" id="elist_err911020020"></div>
</form>
</div></div>
<!-- End Bravenet.com Service Code -->
          </td>
        </tr>
</table>
  <span style="text-decoration: none; "> 
  <p> 
  <font color="#CC0000" style="font-weight: 700">Sign up today to receive the latest Senate 
news!</font></p>
<p style="margin-bottom: 30px">In order to subscribe to or unsubscribe from the Palau Senate Mailing List 
  you must do the following:&nbsp; (1) Fill in your name; (2) Fill in a valid email address; (3) Click on the 
subscribe or unsubscribe button; and (4) Click on the 'GO' button.&nbsp; Once this 
is done, an email containing a confirmation link will be sent to the address you 
provided.&nbsp; Click on the link in the email to confirm your acceptance. This 
must be done before you are officially added to or removed from the Palau Senate 
Mailing List. </p>
      <hr color="#C0C0C0" noshade size="1">
</span></span>
<p align="center" style="margin-bottom: 30px; margin-top:30px"><b><font size="4" color="#3366FF">&nbsp;* 
* * Breaking News from the Senate
* * *</font></b></p>
 
<% 
While ((Repeat1__numRows <> 0) AND (NOT rsbreaking.EOF)) 
%>
  <p align="center"><font color="#cc0000"><b><%=(rsbreaking.Fields.Item("ntitle").Value)%></b></font><br>
    <span class="style1"><%=(rsbreaking.Fields.Item("ndate").Value)%></span></p>
  <p style="margin-bottom: 30px" align="center"><%=(rsbreaking.Fields.Item("narticle").Value)%></p>
  <p align="center">* * * * * * * * 
    *<br>
  </p>
  <% 
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  rsbreaking.MoveNext()
Wend
%>
<hr color="#C0C0C0" noshade size="1">
<p align="center" style="margin-bottom: 30px; margin-top:30px"><b><font size="4" color="#3366FF">* * 
* 2007 Bulletins * * *</font></b></p>
<font size="4">
<p style="text-align: center; margin-bottom: 30px" align="center"><strong>
<span class="style2" style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">The Seventh Olbiil Era Kelulau 
attends the</span></strong><span class="style2"><font size="4"><b><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br clear="all">
<strong><span style="FONT-FAMILY: Arial">Association of Pacific 
Island Legislatures (APIL)</span></strong></span></b></font></span><font color="#3366ff" size="4"><b><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br clear="all">
</span></b></font><font size="4">
<span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">26th General Assembly&nbsp;
<br clear="all">
June 21 - 23,&nbsp;2007 - <i>Pago Pago, American Samoa</i></span></font></p>
<p align="center">* * * * * * * * 
*</p>
<font size="4">
<p style="text-align: center; margin-bottom: 30px" align="center"><strong>
<span class="style2" style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">The Senate Convenes</span></strong><span class="style2"><font size="4"><b><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br clear="all">
<strong><span style="FONT-FAMILY: Arial">The Eleventh Regular 
Session of the Seventh Olbiil Era Kelulau</span></strong></span></b></font></span><font color="#3366ff" size="4"><b><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br clear="all">
</span></b></font><font size="4">
<span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">10:00a.m. on Tuesday, July 10, 
2007 <br clear="all">
<i>Senate Chambers at the Palau National Capitol</i></span></font></p>
<p align="center"><a name="appu"></a>* * * * * * * * 
*</p>
<font size="4">
<p style="text-align: center; margin-bottom: 30px" align="center"><b>
<span class="style2" style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">The Seventh Olbiil Era Kelulau 
hosts the</span></b><span class="style2" style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">
<br clear="all">
<b>Asian-Pacific Parliamentarians' Union (APPU)</b></span><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><font color="#3366ff"><br clear="all">
</font>38th General Assembly <br clear="all">
September 2007 - <i>Koror, Republic of Palau</i></span><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><font color="#3366ff"><br clear="all">
<br clear="all">
</font>
<a target="_blank" href="http://www.palauoek.net/senate/docs/1appu.ltrInvitation.website.pdf">Invitation to the 38th General Assembly</a>
<font color="#3366ff"><br clear="all">
</font>
<a target="_blank" href="http://www.palauoek.net/senate/docs/2appu.program-agenda.pdf">Program and Agenda</a>
<font color="#3366ff"><br clear="all">
</font>
<a target="_blank" href="http://www.palauoek.net/senate/docs/3appu.registration-form.pdf">Registration Form</a>
<font color="#3366ff"><br clear="all">
</font>
<a target="_blank" href="http://www.palauoek.net/senate/docs/4appu.logistics-info.pdf">Logistical Information</a>
<font color="#3366ff"><br clear="all">
</font>
<a target="_blank" href="http://www.palauoek.net/senate/docs/5appu.detailed-program.pdf">Detailed Program and Activities</a> </span></p>
<p align="center">* * * * * * * * 
*</p>
<font size="4">
<p style="text-align: center; margin-bottom: 30px" align="center"><strong>
<span class="style2" style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">The Republic of Palau 
celebrates</span></strong><span class="style2"><b><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">
<br clear="all">
<strong><span style="FONT-FAMILY: Arial">13th&nbsp;Independence Day</span></strong></span></b></span><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><font color="#3366ff"><br clear="all">
</font>October 1,&nbsp;2007 -&nbsp;<i>Republic of Palau</i></span></p>
<p align="center">* * * * * * * * 
*</p>
<font size="4">
<p style="text-align: center; margin-bottom: 30px" align="center"><strong>
<span class="style2" style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">The Senate Convenes</span></strong><span class="style2"><font size="4"><b><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br clear="all">
<strong><span style="FONT-FAMILY: Arial">The Twelfth Regular 
Session of the Seventh Olbiil Era Kelulau</span></strong></span></b></font></span><font color="#3366ff" size="4"><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial"><br clear="all">
</span></font><span style="FONT-SIZE: 11pt; FONT-FAMILY: Arial">10:00a.m. on 
Tuesday, October 9, 2007 <br clear="all">
<i>Senate Chambers at the Palau National Capitol</i></span><font size="4"></p>
<hr noshade color="#C0C0C0" size="1">
<p align="center" style="margin-bottom: 30px; margin-top:30px"><font size="4" color="#3366FF">* * 
* 2007 Press Releases * * *</font></p>
<table width="100%">
  <!-- MSTableType="nolayout" -->
  <thead>
  </thead>
  <tbody>
    <!--webbot bot="DatabaseRegionStart" s-columnnames="date_year,date_day,month_text,bulletin_id,title,link" s-columntypes="202,202,202,202,202,203" s-dataconnection="subed" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="date_year" s-menuvalue="date_year" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="q_articles" s-displaycolumns="date_year,month_text,date_day,title,bulletin_id,link" s-criteria s-order="" s-sql="SELECT * FROM q_articles" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="50" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" b-ReplaceDatabaseRegion="FALSE" --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM q_articles"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="subed"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=50
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="date_year"
fp_sMenuValue="date_year"
fp_sColTypes="&date_year=202&date_day=202&month_text=202&bulletin_id=202&title=202&link=203&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan --><tr>
      <td style="padding-left: 0; padding-right: 5px; padding-bottom:5px" align="center">
      <p align="left"><span style="font-size: 8pt">&#9632;</span></td>
      <td style="padding-bottom: 5px"><span style="font-size: 11pt">
      <a href="<%=FP_FieldLink(fp_rs,"link")%>">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="date_year,date_day,month_text,bulletin_id,title,link" s-column="title" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;title&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"title")%><!--webbot bot="DatabaseResultColumn" endspan --></a></span><span style="font-size: 8pt">&nbsp;
      </span><font style="font-size: 8pt">
      <!--webbot bot="DatabaseResultColumn" s-columnnames="date_year,date_day,month_text,bulletin_id,title,link" s-column="month_text" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;month_text&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"month_text")%><!--webbot bot="DatabaseResultColumn" endspan -->&nbsp;<!--webbot bot="DatabaseResultColumn" s-columnnames="date_year,date_day,month_text,bulletin_id,title,link" s-column="date_day" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;date_day&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"date_day")%><!--webbot bot="DatabaseResultColumn" endspan -->&nbsp;<!--webbot bot="DatabaseResultColumn" s-columnnames="date_year,date_day,month_text,bulletin_id,title,link" s-column="bulletin_id" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;bulletin_id&lt;font size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan --><%=FP_FieldVal(fp_rs,"bulletin_id")%><!--webbot bot="DatabaseResultColumn" endspan --></font></td>
    </tr>
    <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="50" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot;  |&lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;   &lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;   &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;|  &quot;&gt;  [1/50]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan --></tbody>
</table>
<p align="left" style="margin-top: 10px; margin-bottom: 10px">&nbsp;</p>
      </td>
    </tr>
    <tr>
      <td style="border-left-width:medium; border-right-width:medium; border-bottom-width:medium">
      <p align="right"><span style="font-size: 4pt">&nbsp;</span></td>
    </tr>
    <tr>
      <td style="border-left-style:none; border-left-width:medium; border-right-style:none; border-right-width:medium; border-top-style:solid; border-top-width:1px; border-bottom-style:none; border-bottom-width:medium" bgcolor="#373737" height="25">
      <p align="center">
      <font face="Trebuchet MS" color="#FFFFFF" style="font-size: 7.5pt; text-transform:uppercase">© 
  THE GOVERNMENT OF THE REPUBLIC OF PALAU COPYRIGHT 2005-2007.&nbsp; ALL 
      RIGHTS RESERVED.&nbsp; <a href="Disclaimer.asp"><font color="#FFFFFF">DISCLAIMER NOTICE</font></a>.</font></td>
    </tr>
    <tr>
      <td style="border-style:none; border-width:medium; " bgcolor="#666666" height="25">
      <p align="center">
      <font face="Trebuchet MS" color="#FFFFFF" style="font-size: 7.5pt; text-transform:uppercase">LAST UPDATE
      <!--webbot bot="Timestamp" S-Type="REGENERATED" S-Format="%B %Y" startspan -->April 2009<!--webbot bot="Timestamp" i-checksum="13843" endspan -->.&nbsp;
      SITE 
      CREATED AND MAINTAINED BY <a href="http://www.olekoi.com">
      <font color="#FFFFFF">OLEKOI PALAU</font></a>.</font></td>
    </tr>
    </table>
  </div>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-8267900-3");
pageTracker._trackPageview();
} catch(err) {}</script>
</body>
 
</html>
<%
rsbreaking.Close()
Set rsbreaking = Nothing
%>

           
         

Help altering code for front page database

Asked by elliottbenzle in FrontPage-Expressions

About this solution