Here it is. I tried cutting most non-related html.
Thank you so much.
<cfinclude template="Connections/Record_Search.cfm">
<cfparam name="Recordset1__rqSearch" default="#Form.Select#">
<cfquery name="Recordset1" datasource=#MM_Record_Search_DSN#
username=#MM_Record_Search_USERNAME# password=#MM_Record_Search_PASSWORD#>
SELECT * FROM Members WHERE BusinessType ='#Recordset1__rqSearch#' ORDER
BY BusinessType
ASC
</cfquery>
<cfoutput>#Recordset1__rqSearch#</cfoutput>
<cfset Recordset1_NumRows = 0>
<cfset Recordset1_Index = 1>
<cfscript>
Repeat1_NumRows = 20;
Recordset1_NumRows = Recordset1_NumRows + Repeat1_NumRows;
<cfparam name = "MaxRows" default = "2">
<cfparam name = "StartRow" default = "1">
</cfscript>
<cfscript>
// *** Recordset Stats, Move To Record, and Go To Record: set stats
variables
// set the record count
Recordset1_total = Recordset1.RecordCount;
// set the number of rows displayed on this page
If (Recordset1_NumRows GT 0 OR Recordset1_total IS NOT 0) {
Recordset1_NumRows = Recordset1_total;
} Else If (Recordset1_NumRows EQ 0) {
Recordset1_NumRows = 1;
}
// set the first and last displayed record
Recordset1_first = Min(1, Recordset1_total);
Recordset1_last = Min(Recordset1_NumRows, Recordset1_total);
</cfscript>
<cfscript> MM_paramName = "";
</cfscript>
<cfscript>
// *** Move To Record and Go To Record: declare variables
MM_rs = Recordset1;
MM_rsCount = Recordset1_total;
MM_size = Recordset1_NumRows;
MM_uniqueCol = "";
MM_paramName = "";
MM_offset = 1;
MM_atTotal = false;
MM_paramIsDefined = false;
If (MM_paramName NEQ "") MM_paramIsDefined = IsDefined(MM_paramName);
</cfscript>
<cfscript>
// *** Move To Record: handle 'index' or 'offset' parameter
If (NOT MM_paramIsDefined AND MM_rsCount NEQ 0) {
// use index parameter if defined, otherwise use offset parameter
If (IsDefined("index")) {
MM_offset = index;
} Else If (IsDefined("offset")) {
MM_offset = offset;
}
// check if we are past the end of the recordset
If (MM_offset GT MM_rsCount OR MM_offset EQ 0) { // past end or
move last
If ((MM_rsCount MOD MM_size) NEQ 0) { // last page not a full
repeat region
MM_offset = MM_rsCount - (MM_rsCount MOD MM_size) + 1;
} Else {
MM_offset = MM_rsCount - MM_size + 1;
}
}
}
</cfscript>
<cfscript>
// *** Move To Record: replace the current query, for navigation on a
detail page
If (MM_size EQ 1) { // if no repeated regions are defined
// create a new query with one row
MM_newQuery = QueryNew(MM_rs.ColumnList);
QueryAddRow(MM_newQuery, 1);
// copy the data in the row pointed to by MM_offset to the new query
MM_columns = ListToArray(MM_rs.ColumnList,",");
For (i=1; i LTE ArrayLen(MM_columns); i=i+1) {
QuerySetCell(MM_newQuery, MM_columns[i],
MM_rs[MM_columns[i]][MM_offset], 1);
}
// change the recordset to be only this one row
Recordset1 = MM_newQuery;
}
</cfscript>
<cfscript>
// *** Move To Record: update recordset stats
// set the first and last displayed record
Recordset1_first = Min(MM_offset, MM_rsCount);
Recordset1_last = Min(MM_offset + MM_size - 1, MM_rsCount);
// set the starting index for repeated regions on this recordset
Recordset1_Index = MM_offset;
// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_offset + MM_size - 1 GTE MM_rsCount);
</cfscript>
<cfscript>
// *** Go To Record and Move To Record: create strings for maintaining
URL and Form parameters
// create the list of parameters which should not be maintained
MM_removeList = "&index=";
If (MM_paramName NEQ "") MM_removeList = MM_removeList & "&" &
MM_paramName & "=";
MM_keepURL=""; MM_keepForm=""; MM_keepBoth=""; MM_keepNone="";
// add the existing URL parameters to the MM_keepURL string
MM_params=ListToArray(CGI.QUERY_STRING,"&");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & GetToken(MM_params[i],1,"=") & "=",MM_removeList)
Is 0)
MM_keepURL = MM_keepURL & "&" & MM_params[i];
}
// add the existing Form variables to the MM_keepForm string
If (IsDefined("FORM.FieldNames")) {
MM_params=ListToArray(FORM.FieldNames,",");
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (FindNoCase("&" & MM_params[i] & "=",MM_removeList) Is 0)
MM_keepForm = MM_keepForm & "&" & LCase(MM_params[i]) & "=" &
URLEncodedFormat(Evaluate("FORM." & MM_params[i]));
}
}
// create the Form + URL string and remove the intial '&' from each of
the strings
MM_keepBoth = MM_keepURL & MM_keepForm;
If (MM_keepURL NEQ "") MM_keepURL = RemoveChars(MM_keepURL,1,1);
If (MM_keepForm NEQ "") MM_keepForm = RemoveChars(MM_keepForm,1,1);
If (MM_keepBoth NEQ "") MM_keepBoth = RemoveChars(MM_keepBoth,1,1);
</cfscript>
<cfscript>
// *** Move To Record: set the strings for the first, last, next, and
previous links
MM_keepMove = MM_keepBoth;
MM_moveParam = "index";
// if the page has a repeated region, remove 'offset' from the
maintained parameters
if (MM_size GT 1) {
MM_moveParam = "offset";
MM_params = ListToArray(MM_keepMove,"&");
MM_keepMove = "";
For (i=1; i LTE ArrayLen(MM_params); i=i+1) {
If (CompareNoCase(GetToken(MM_params[i],1,"="),MM_moveParam) IS NOT 0) {
MM_keepMove = MM_keepMove & "&" & MM_params[i];
}
}
If (MM_keepMove NEQ "") {
MM_keepMove = RemoveChars(MM_keepMove,1,1);
}
}
// set the strings for the move to links
if (MM_keepMove NEQ "") MM_keepMove = MM_keepMove & "&";
urlStr = CGI.SCRIPT_NAME & "?" & MM_keepMove & MM_moveParam & "=";
MM_moveFirst = urlStr & "1";
MM_moveLast = urlStr & "0";
MM_moveNext = urlStr & (MM_offset + MM_size);
MM_movePrev = urlStr & Max(MM_offset-MM_size,1);
</cfscript>
<html>
<head>
</head>
<body>
<div id="main">
<div class="center">
<h2 class="style8"> </h2>
<div class="center">
<h1 class="style11">Directory of Members </h1>
<h2 class="style16"> Search or browse through our members. </h2>
<hr />
<table width="108%" border="0" cellspacing="2" cellpadding="5">
<tr bgcolor="tan">
<td colspan="9" bgcolor="#F1F6F9" class="style31"><cfoutput><span
class="style33">#Recordset1.BusinessType#<font face="Arial, Helvetica,
sans-serif"></font></span></cfoutput></td>
</tr>
<hr />
<cfscript>
Repeat1_StartRow = Recordset1_Index;
Recordset1_Index = Min(Recordset1_Index + Repeat1_NumRows,
Recordset1.RecordCount);
</cfscript>
<cfoutput query="Recordset1" startrow=#Repeat1_StartRow#
maxrows=2Repeat1_NumRows#>
<tr>
<td width="8%" class="style31"><img
src="images/#Recordset1.RecordID#.jpg"> </td>
<td width="20%" class="style31"><div align="left" class="style31">
<p class="style8"><strong>#Recordset1.Name#</strong></p>
<p class="style8"> </p>
</div></td>
<td colspan="2" class="style31"><div align="left" class="style31">
<p>#Recordset1.Address1#</p>
<p> </p>
</div></td>
<td width="38%" class="style31"><div align="left" class="style31">
<p>#Recordset1.City#</p>
<p> </p>
</div></td>
</tr>
</cfoutput> <cfoutput> </cfoutput>
<cfif FileExists("D:\wwwroot\members\images\#Recordset1.RecordID#.jpg")>
<tr>
<td class="style31"> </td>
<td class="style31"><cfoutput>Phone: #Recordset1.Phone#<font
face="Arial, Helvetica, sans-serif"></font></cfoutput></td>
<td width="18%" class="style31"><cfoutput>Fax: #Recordset1.Fax#<font
face="Arial, Helvetica, sans-serif"></font></cfoutput></td>
<td colspan="2" class="style31"><cfoutput><a
href="#ListLast(Recordset1.Web,
"##")#" target="_blank">#ListFirst(Recordset1.Web, "##")#</a><font
face="Arial, Helvetica, sans-serif"></font></cfoutput></td>
</tr>
<cfelse>
</cfif>
<cfscript>
Repeat1_StartRow = Recordset1_Index;
Recordset1_Index = Min(Recordset1_Index + Repeat1_NumRows,
Recordset1.RecordCount);
</cfscript>
<cfif Recordset1.RecordCount is not 0>
<cfoutput query="Recordset1" startrow=#Repeat1_StartRow#
maxrows=2Repeat1_NumRows#> </cfoutput> <cfoutput> </cfoutput>
</cfif>
<cfif FileExists("D:\wwwroot\members\images\#Recordset1.RecordID#.jpg")>
<cfelse>
</cfif>
</table>
<p align="center" class="style31 style24"><a href="directory.cfm">Begin
another search. </a>
<hr>
<p>
</p>
</div>
Dave Phillips wrote:
> Jen,
>
> Can you post your code? This isn't enough information.
>
> Dave
>
> -----Original Message-----
> From: Jen Thomas [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 22, 2008 3:39 PM
> To: cf-newbie
> Subject: # of lines Tag?
>
> What tag controls the number of lines that are displayed?
>
> Instead of:
> Line 1
> Line 2
>
> I get:
> Line 1
>
> Were do I look?
>
> Thank you,
> Jen
>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4073
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
