Link to home
Start Free TrialLog in
Avatar of alexanderax
alexanderaxFlag for Singapore

asked on

Drop down list

How to code for different datasource by using drop down list? Let's say i got one datasource and i'm searching for an drawing number..

I want the drop down list to show the database name and enable user to choose it(i.e. Database: Lardon2, dbl_IWS, etc..), after that key in the drawing number so that the particular drawing number will be shown in the results page.

Base on my code shown:
<cfparam name="url.pageno" default="1">
<cfparam name="url.pageSize" default="30">
<cfset pageSize = max(val(url.pageSize),10)> 
<cfset pageNo = max(val(url.pageNo),1)> 
<CFset index="1">
<cfparam name="form.txtBoxValue" default="">
 
 
<cfset variables.data = arrayNew(1)> 
 
<cfif isDefined("form.txtBoxValue") and len(form.txtBoxValue)>
 
  <cfset allTableNames = "335K,335L,335M,335N, 310A,310B,310C,310D">  
 
 
  <cfset allLardonTableNames = "LAA, LCA, LCB, LCC, LCD, LCJ. LCT">  
 
<!---IWS TABLE--->
  <cfloop index="IWSTable" list="#allTableNames#"> 
    <cfquery name="get_ALL" DATASOURCE="DSN_dbl_IWS">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #IWStable#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
  
    <cfloop query="get_ALL"> <!--- loop through the results, adding the results to the results array ----->
       <cfset pos = arrayLen(ALL.data) + 1>
       <cfset ALL.data[pos] = structNew()>
       <cfset ALL.data[pos].doc_no = get_ALL.doc_no>    
       <cfset ALL.data[pos].Remarks =get_ALL.Remarks>    
       <cfset ALL.data[pos].Status = get_ALL.Status>    
       <cfset ALL.data[pos].Describe = get_ALL.Describe>    
       <cfset ALL.data[pos].tableName = IWStable>
    </cfloop>
 </cfloop>
 
 
<!---LARDON 2 TABLE--->
    <cfloop index="LardonTable" list="#allLardonTableNames#"> 
    <cfquery name="get_ALL" DATASOURCE="Lardon2">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #Lardontable#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
  
    <cfloop query="get_ALL"> <!--- loop through the results, adding the results to the results array ----->
       <cfset pos = arrayLen(ALL.data) + 1>
       <cfset ALL.data[pos] = structNew()>
       <cfset ALL.data[pos].doc_no = get_ALL.doc_no>    
       <cfset ALL.data[pos].Remarks =get_ALL.Remarks>    
       <cfset ALL.data[pos].Status = get_ALL.Status>    
       <cfset ALL.data[pos].Describe = get_ALL.Describe>    
       <cfset ALL.data[pos].tableName = Lardontable>
    </cfloop>
 </cfloop>
</CFIF>
 
 
 
 
<meta http-equiv="Contecnt-Type" content="text/html; charset=iso-8859-1">
<style type="text/css"> body {background-color=#A7EF9228bdee; }  .style2{color:#b51111} </style></body> 
 
<table>
 <tr> 
  <td>
  Number of files Generated:</br>
  <cfoutput><b>#arrayLen(All.data)#</cfoutput> 
  </td>
</tr>
</table>
<br> 
 
<cfset numberOfPages = ceiling(arrayLen(All.data) / pageSize)> <!--- numb records divided by page Size = how many pages, round up --->
<cfif pageNo gt numberOfPages> <!--- make sure page is not beyond the number of pages ---->
  <cfset
 pageNo = numberOfPages>
</cfif>
 
<!---- calculate the first record to show ---->
<cfset firstRecord = (pageNo - 1) * pageSize) + 1> 
<cfset lastRecord = min(firstRecord + pageSize - 1, arrayLen(All.data)> 
 
<!--- figure out the prev and next pages ---->
<cfset prevPage = max(1, pageNo - 1)>
<cfset nextPage = min(numberOfPages, pageNo + 1)>
 
<br><br>
 
<table width...> <tr> <th width.....><font...>Search Results:</font></th> <tr> 
<td>S/N</td> 
<td>DOC_NO></td> 
<td>DESCRIPTION</td> 
<td>STATUS</td>
<td>REMARKS</td> </tr> 
 
 
 
<cfloop index="pos" from="#firstRecord#" to="#lastRecord#">
<cfoutput>
<tr> 
 <td>#pos#</td>
 <td>#All.data[pos].Doc_No#</td>
 <td>#All.data[pos].Remarks#</td>
 <td>#All.data[pos].Status#</td>
 <td>#All.data[pos].Describe#</td>
</tr>
</cfoutput>
</cfloop>
</table>
 
<cfif #All.data.Doc_No# is 0>
<font size="4"> There is no records found!</font>
<cfabort>
</cfif><br>
 
</body></html>
 
<cfif val(prevPage)>
<a href="thisPageName.cfm?page=#prevPage#">Previous Page</a>
</cfif>
<cfif val(nextPage)>
<a href="thisPageName.cfm?page=#nextPage#">Next Page</a>
</cfif>

Open in new window

Avatar of azadisaryev
azadisaryev
Flag of Hong Kong image

create a drop-down select and populate it with <option> tags with value = dsnname (one <option> tag for each dsn). then on your form;s action page use that select's value in the datasource attribute of your <cfquery> tag(s).

i.e. if your select list had name="datasources", then your query on the action page would have datasource="#form.datasources#"

for the 2 dsns listed in your code you would then have:

<select name="datasources" size="1">
<option value="DSN_dbl_IWS">DSN_dbl_IWS</option>
<option value="Lardon2">Lardon2</option>
</select>

you can even go further with that and give your table lists variables names to correspond to the dsn names, and then you will just need one loop instead of 2, e.g., based on your dsn names:

<cfset DSN_dbl_IWS_TableNames = "335K,335L,335M,335N, 310A,310B,310C,310D">
<cfset Lardon2_TableNames = "LAA, LCA, LCB, LCC, LCD, LCJ. LCT">

<cfloop index="tblName" list="#variables[form.datasources & '_TableNames']#">
    <cfquery name="get_ALL" DATASOURCE="DSN_dbl_IWS">      
     SELECT Doc_No, Remarks, Status, Describe
     FROM #tblName#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
    ....
</cfloop>

Azadi
Avatar of alexanderax

ASKER

ok i will try it now. Can you look at my other questions? The error part when creating numbering pages..
it looks like your other 2 open question are about the same error... and in one of them gdemaria already gave you an answer.

Azadi
gdemaria give the answer but i still got error...

Anyway i got error for the drop down list too..
Element #DSN_dbl_IWS# _TableNames is undefined in a java object of type class coldfusion.runtime.Variables referenced as

Can you edit from my code below?

As for the search page, you just can write the drop down list coding. Below is my form action page(Results page).
<cfparam name="url.pageno" default="1">
<cfparam name="url.pageSize" default="30">
<cfset pageSize = max(val(url.pageSize),10)> 
<cfset pageNo = max(val(url.pageNo),1)> 
<CFset index="1">
<cfparam name="form.txtBoxValue" default="">
 
 
<cfset variables.data = arrayNew(1)> 
 
<cfif isDefined("form.txtBoxValue") and len(form.txtBoxValue)>
 
  <cfset allTableNames = "335K,335L,335M,335N, 310A,310B,310C,310D">  
 
 
  <cfset allLardonTableNames = "LAA, LCA, LCB, LCC, LCD, LCJ. LCT">  
 
<!---IWS TABLE--->
  <cfloop index="IWSTable" list="#allTableNames#"> 
    <cfquery name="get_ALL" DATASOURCE="DSN_dbl_IWS">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #IWStable#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
  
    <cfloop query="get_ALL"> <!--- loop through the results, adding the results to the results array ----->
       <cfset pos = arrayLen(ALL.data) + 1>
       <cfset ALL.data[pos] = structNew()>
       <cfset ALL.data[pos].doc_no = get_ALL.doc_no>    
       <cfset ALL.data[pos].Remarks =get_ALL.Remarks>    
       <cfset ALL.data[pos].Status = get_ALL.Status>    
       <cfset ALL.data[pos].Describe = get_ALL.Describe>    
       <cfset ALL.data[pos].tableName = IWStable>
    </cfloop>
 </cfloop>
 
 
<!---LARDON 2 TABLE--->
    <cfloop index="LardonTable" list="#allLardonTableNames#"> 
    <cfquery name="get_ALL" DATASOURCE="Lardon2">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #Lardontable#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
  
    <cfloop query="get_ALL"> <!--- loop through the results, adding the results to the results array ----->
       <cfset pos = arrayLen(ALL.data) + 1>
       <cfset ALL.data[pos] = structNew()>
       <cfset ALL.data[pos].doc_no = get_ALL.doc_no>    
       <cfset ALL.data[pos].Remarks =get_ALL.Remarks>    
       <cfset ALL.data[pos].Status = get_ALL.Status>    
       <cfset ALL.data[pos].Describe = get_ALL.Describe>    
       <cfset ALL.data[pos].tableName = Lardontable>
    </cfloop>
 </cfloop>
</CFIF>
 
 
 
 
<meta http-equiv="Contecnt-Type" content="text/html; charset=iso-8859-1">
<style type="text/css"> body {background-color=#A7EF9228bdee; }  .style2{color:#b51111} </style></body> 
 
<table>
 <tr> 
  <td>
  Number of files Generated:</br>
  <cfoutput><b>#arrayLen(All.data)#</cfoutput> 
  </td>
</tr>
</table>
<br> 
 
<cfset numberOfPages = ceiling(arrayLen(All.data) / pageSize)> <!--- numb records divided by page Size = how many pages, round up --->
<cfif pageNo gt numberOfPages> <!--- make sure page is not beyond the number of pages ---->
  <cfset
 pageNo = numberOfPages>
</cfif>
 
<!---- calculate the first record to show ---->
<cfset firstRecord = (pageNo - 1) * pageSize) + 1> 
<cfset lastRecord = min(firstRecord + pageSize - 1, arrayLen(All.data)> 
 
<!--- figure out the prev and next pages ---->
<cfset prevPage = max(1, pageNo - 1)>
<cfset nextPage = min(numberOfPages, pageNo + 1)>
 
<br><br>
 
<table width...> <tr> <th width.....><font...>Search Results:</font></th> <tr> 
<td>S/N</td> 
<td>DOC_NO></td> 
<td>DESCRIPTION</td> 
<td>STATUS</td>
<td>REMARKS</td> </tr> 
 
 
 
<cfloop index="pos" from="#firstRecord#" to="#lastRecord#">
<cfoutput>
<tr> 
 <td>#pos#</td>
 <td>#All.data[pos].Doc_No#</td>
 <td>#All.data[pos].Remarks#</td>
 <td>#All.data[pos].Status#</td>
 <td>#All.data[pos].Describe#</td>
</tr>
</cfoutput>
</cfloop>
</table>
 
<cfif #All.data.Doc_No# is 0>
<font size="4"> There is no records found!</font>
<cfabort>
</cfif><br>
 
</body></html>
 
<cfif val(prevPage)>
<a href="thisPageName.cfm?page=#prevPage#">Previous Page</a>
</cfif>
<cfif val(nextPage)>
<a href="thisPageName.cfm?page=#nextPage#">Next Page</a>
</cfif>

Open in new window

Sorry as you see my desk do not have internet access and only i have to come to computer room then can be able to use internet access..

So for now is very difficult for me to get the search page unless i get printed it out and upload the picture..

Some more this web search engine is done on intranet.. Internet cannot get through it and my desk also cannot use floppy disk or thumbdrive.. I will try to find an thumbdrive by saving the coding for easy access to you. Down here i cannot bring in thumbdrive unless is authorized..
goodness! what kind of development environment is that?! no internet access?! no unauthorized thumbdrives?! you must be working for some super-secret-super-spies....

anyway, i have already posted the code for your drop-down select before... and i have posted the code for you to use on your form's action page, too!

what else do you want me to do? i could probably come over there and type it for you on your desktop, but i guess i won't be allowed in without proper authorization and a full cavities search... :)

i will just point out one other thing about your code:
the way your prev/next pagination links are coded, you are going to lose any and all previously submitted form values. you need to pass those values (i.e. the selected datasource to search in and the value of form.txtBoxValue) along in those links, so that each page refresh can generate the same queires and same array or search results...

i may also add that the way you are going about it is extremely inefficient (generating same data on every next/previous link click). you may want to consider using some persistent scope variable to save the search results (your generated array) in to lessen the burden on your db and server... alternatively, and if javascript is 'authorized' by your some super-secret-super-spy organization, consider using something like jqGrid or TableSorter (both jQuery plug-ins) to display search results and pagination...

Azadi
Oh yes... I think that's the results why my page always get to the first of all pages whenever i click previous or next.. The code you gievn me also got an error..
And yes... i can use javascript.. How to do that saving data using javascript?
hi azadisaryev:

>you need to pass those values (i.e. the selected datasource to search in and the value of form.txtBoxValue) along in those links, so that each page refresh can generate the same queires and same array or search results...

Can you tell me how to passed those values(the selected datasource to search i and the value of form.txtBoxValue)
ASKER CERTIFIED SOLUTION
Avatar of azadisaryev
azadisaryev
Flag of Hong Kong image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
sorry i paste my coding here and can you show edit it from there? I used your drop down list but it says cannot find the table "310A".. Is like the code cannot query for the table.
<cfparam name="url.pageno" default="1">
<cfparam name="url.pageSize" default="30">
<cfset pageSize = max(val(url.pageSize),10)> 
<cfset pageNo = max(val(url.pageNo),1)> 
<CFset index="1">
<cfparam name="form.txtBoxValue" default="">
<cfset variables.data = arrayNew(1)> 
 
<cfif isDefined("form.txtBoxValue") and len(form.txtBoxValue)>
 
<cfset DSN_dbl_IWS_TableNames = "335K,335L,335M,335N, 310A,310B,310C,310D">  
<cfset Lardon2_TableNames = "LAA, LCA, LCB, LCC, LCD, LCJ. LCT">  
 
  <cfloop index="tblName" list="#variables[form.datasources & '_TableNames']#">
 
    <cfquery name="get_All" DATASOURCE="#form.tableNames#">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #tblName#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
 
    <cfquery name="get_All" DATASOURCE="#form.tableNames#">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #tblName#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
 
    <cfloop query="get_All"> <!--- loop through the results, adding the results to the results array ----->
       <cfset pos = arrayLen(Variables.data) + 1>
       <cfset Variables.data[pos] = structNew()>
       <cfset Variables.data[pos].doc_no = get_All.doc_no>    
       <cfset Variables.data[pos].Remarks =get_All.Remarks>    
       <cfset Variables.data[pos].Status = get_All.Status>    
       <cfset Variables.data[pos].Describe = get_All.Describe>    
       <cfset Variables.data[pos].tableName =tblName>
  </cfloop>
 </cfloop>
<cfset session.allData = variables.data>
<cfelseif isDefined("session.allData")>
<cfset variables.data = session.allData>
</CFIF>
 
<meta http-equiv="Contecnt-Type" content="text/html; charset=iso-8859-1">
<style type="text/css"> body {background-color=#A7EF9228bdee; }  .style2{color:#b51111} </style></body> 
 
<table>
 <tr> 
  <td>
  Number of files Generated:</br>
  <cfoutput><b>#arrayLen(Variables.data)#</cfoutput> 
  </td>
</tr>
</table>
<br> 
 
<cfset numberOfPages = ceiling(arrayLen(Variables.data) / pageSize)> <!--- numb records divided by page Size = how many pages, round up --->
<cfif pageNo gt numberOfPages> <!--- make sure page is not beyond the number of pages ---->
  <cfset
 pageNo = numberOfPages>
</cfif>
 
<!---- calculate the first record to show ---->
<cfset firstRecord = (pageNo - 1) * pageSize) + 1> 
<cfset lastRecord = min(firstRecord + pageSize - 1, arrayLen(Variables.data)> 
 
<!--- figure out the prev and next pages ---->
<cfset prevPage = max(1, pageNo - 1)>
<cfset nextPage = min(numberOfPages, pageNo + 1)>
 
<br><br>
 
<table width...> <tr> <th width.....><font...>Search Results:</font></th> <tr> 
<td>S/N</td> 
<td>DOC_NO></td> 
<td>DESCRIPTION</td> 
<td>STATUS</td>
<td>REMARKS</td> </tr> 
 
 
<cfoutput>
<cfloop index="pos" from="#firstRecord#" to="#lastRecord#">
<tr> 
 <td>#pos#</td>
 <td>#Variables.data[pos].Doc_No#</td>
 <td>#Variables.data[pos].Remarks#</td>
 <td>#Variables.data[pos].Status#</td>
 <td>#Variables.data[pos].Describe#</td>
</tr>
</cfloop>
</cfoutput>
</table>
 
<cfif arrayLen(Variables.data) eq 0>
<font size="4"> There is no records found!</font>
<input type="button" name="BackToMain" value="Back to Main Page" onClick="location.href='../drawing search/searchEngineMain.cfm'">
<br>
<cfelse>
<input type="button" name="BackToMain" value="Back to Main Page" onClick="location.href='../drawing search/searchEngineMain.cfm'">
<br>
<cfif val(prevPage)>
<a href="Search_resultsTesting.cfm?page=#prevPage#">Previous Page</a>
</cfif>
<cfif val(nextPage)>
<a href="tSearch_resultsTesting.cfm?page=#nextPage#">Next Page</a>
</cfif> 
 
<cfabort>
</cfif>
</body></html>

Open in new window

LATEST CODE


This is the latest version of my numbering codes. It can show 100 results for every pages. On the first page, it shows 1-100 but when i click on the second page, it shows 301-400 which is suppose to be the last page of the results. Same goes to the 3rd and 4th pages.

How to solve this problem? Show me exactly the code  if i'm missing something or do i need to create an application.cfm?

<cfset structAppend(form, url, false)>
<cfparam name="url.pageno" default="0">
<cfparam name="url.pageSize" default="100">
<cfset pageSize = max(val(url.pageSize),10)> 
<cfset pageNo = max(val(url.pageNo),1)> 
<CFset index="1">
<cfparam name="form.txtBoxValue" default="">
 
<cfset variables.data = arrayNew(1)> 
<cfif isDefined("form.txtBoxValue") and len(form.txtBoxValue)>
 
  <cfset DSN_dbl_IWS_TableNames = "335K,335L,335M,335N, 310A,310B,310C,310D">  
  <cfset Lardon2_TableNames = "LAA, LCA, LCB, LCC, LCD, LCJ. LCT">  
 
  <cfloop index="tblName" list="#variables[form.TableNames & '_TableNames']#"> 
    <cfquery name="get_All" DATASOURCE="DSN_dbl_IWS">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #tblName#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
 
   <cfquery name="get_All" DATASOURCE="Lardon2">       
     SELECT Doc_No, Remarks, Status, Describe
     FROM #tblName#
     WHERE Doc_No LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#form.txtBoxValue#%">
    </cfquery>
 
    <cfloop query="get_All"> <!--- loop through the results, adding the results to the results array ----->
       <cfset pos = arrayLen(variables.data) + 1>
       <cfset variables.data[pos] = structNew()>
       <cfset variables.data[pos].doc_no = get_All.doc_no>    
       <cfset variables.data[pos].Remarks =get_All.Remarks>    
       <cfset variables.data[pos].Status = get_All.Status>    
       <cfset variables.data[pos].Describe = get_All.Describe>    
       <cfset variables.data[pos].tableName = tblName>
    </cfloop>
  </cfloop>
 
 <cfset session.allData = variables.data>
<cfelseif isDefined("session.allData")>
  <!--- this is not a search, so load the data back from the session variable --->
  <cfset variables.data = session.allData>
</CFIF>
 
<p align="center">
<cfset Result_Per_Page="100">
<cfset Total_Records="#arrayLen(Variables.data)#">
<cfparam name="url.pageno" default="0">
<cfset limit=URL.pageno + Result_Per_Page>
<cfset start_result=URL.pageNo + 1>
<cfoutput>Showing results #start_result#-
<cfif limit GT Total_Records>
#Total_Records#
<cfelse>
#limit#
</cfif>
	of #Total_Records#</cfoutput>
</p>
 
<p align="center">
<cfset URL.pageNo=URL.pageNo + 1>
 
<cfif Total_Results GT Result_Per_Page>
<cfif prevPage = URL.pageNo - Result_Per_Page - 1>
	<cfoutput>
	<a href="Search_Resultstesting.cfm?pageNo=#prevPage#&TableNames=#urlencodedformat(form.TableNames)#&txtBoxValue=#urlencodedformat(form.txtBoxValue)#">Previous</a>
	</cfoutput>
</cfif>
 
	<cfset Total_Pages=ceiling(Total_Records/Result_Per_Page)>
<cfloop index="i" from="1" to="#Total_pages#">
	<cfset j=i-1>
 
	<cfset pageNo_value=j*Result_Per_Page>
<cfif pageNo_value EQ URL.pageNo - 1>
	<cfoutput>#i#</cfoutput>
<cfelse>
 
<cfoutput>
<a href="search_Resultstesting.cfm?pageNo=#pageNo_value#&TableNames=#urlencodedformat(form.TableNames)#&txtBoxValue=#urlencodedformat(form.txtBoxValue)#">#i#</a>
</cfoutput>
</cfif>
</cfloop>
 
<cfif limit LT Total_Records>
<cfset nextPage = URL>pageNo + Result_Per_Page -1>
<cfoutput>
<a href="search_Resultstesting.cfm?pageNo=#nextPage#&TableNames=#urlencodedformat(form.TableNames)#&txtBoxValue=#urlencodedformat(form.txtBoxValue)#">Next
</a>
</cfoutput>
</cfif>
</cfif>
</p>
 
 
<meta http-equiv="Contecnt-Type" content="text/html; charset=iso-8859-1">
<style type="text/css"> body {background-color=#A7EF9228bdee; }  .style2{color:#b51111} </style></body> 
 
<table>
 <tr> 
  <td>
  Number of files Generated:</br>
  <cfoutput><b>#arrayLen(variables.data)#</cfoutput> 
  </td>
</tr>
</table>
<br> 
 
<cfset numberOfPages = ceiling(arrayLen(variables.data) / pageSize)> <!--- numb records divided by page Size = how many pages, round up --->
<cfif pageNo gt numberOfPages> <!--- make sure page is not beyond the number of pages ---->
  <cfset pageNo = numberOfPages>
</cfif>
 
<!---- calculate the first record to show ---->
<cfset firstRecord = (pageNo - 1) * pageSize) + 1> 
<cfset lastRecord = min(firstRecord + pageSize - 1, arrayLen(variables.data)> 
 
<!--- figure out the prev and next pages ---->
<cfset prevPage = max(1, pageNo - 1)>
<cfset nextPage = min(numberOfPages, pageNo + 1)>
 
<br><br>
 
<table width...> <tr> <th width.....><font...>Search Results:</font></th> <tr> 
<td>S/N</td> 
<td>DOC_NO></td> 
<td>DESCRIPTION</td> 
<td>STATUS</td>
<td>REMARKS</td> </tr> 
 
 
<cfoutput>
<cfloop index="pos" from="#firstRecord#" to="#lastRecord#">
<tr> 
 <td>#pos#</td>
 <td>#variables.data[pos].Doc_No#</td>
 <td>#variables.data[pos].Remarks#</td>
 <td>#variables.data[pos].Status#</td>
 <td>#variables.data[pos].Describe#</td>
</tr>
</cfloop>
</cfoutput>
</table>
 
<cfif arrayLen(variables.data) eq 0>
<font size="4"> There is no records found!</font>
<input type="button" name="BackToMain" value="Back to Main Page" onClick="location.href='../drawing search/searchEngineMain.cfm'">
<br>
<cfelse>
<input type="button" name="BackToMain" value="Back to Main Page" onClick="location.href='../drawing search/searchEngineMain.cfm'">
<br>
<cfif val(prevPage)>
<a href="search_Resultstesting.cfm?pageNo=#prevPage#&TableNames=#urlencodedformat(form.TableNames)#&txtBoxValue=#urlencodedformat(form.txtBoxValue)#">Previous Page</a>
</cfif>
<cfif val(nextPage)>
<a href="search_Resultstesting.cfm?pageNo=#nextPage#&TableNames=#urlencodedformat(form.TableNames)#&txtBoxValue=#urlencodedformat(form.txtBoxValue)#">Next Page</a>
</cfif> 
<cfexit>
</cfif>
</body></html>

Open in new window