Update of /cvsroot/mydatabasepilot/MyDatabasePilot/Query
In directory sc8-pr-cvs1:/tmp/cvs-serv21925/Query
Modified Files:
SELECT.cfm
Log Message:
Functionality Added:
[ 735008 ] Add Limit Rows to ShowRecords dbProcess
Index: SELECT.cfm
===================================================================
RCS file: /cvsroot/mydatabasepilot/MyDatabasePilot/Query/SELECT.cfm,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** SELECT.cfm 18 Apr 2003 04:01:41 -0000 1.1
--- SELECT.cfm 9 May 2003 04:08:02 -0000 1.2
***************
*** 56,59 ****
--- 56,69 ----
<!---||| Limit Clause String |||--->
<cfparam name="limitString" default="">
+ <!--- Check to see if numberOfRecords value exists, scope is not specified because it could be a Local, URL, or FORM variable --->
+ <cfif IsDefined("numberOfRecords")>
+ <!--- Check to see if starting record is specified, scope is not declared because it could be a Local, URL, or FORM variable --->
+ <cfif IsDefined("initialRecord")>
+ <!--- Add start record to limitString --->
+ <cfset limitString = "#initialRecord#, ">
+ </cfif>
+ <!--- Add number of records to return to limitString --->
+ <cfset limitString = "#limitString##numberOfRecords#">
+ </cfif>
<!---||| Procedure Clause String |||--->
|
