how to use next/previous record browsing

edP123 · May 29, 2002

HI,
I've a problem to brows the next/previous link using option value format for the date.In my action page I'm using this function as follow:
<cfset startdate=#CreateDate('#form.startyear#','#form.startmonth#','#form.startday#')#>
<cfset enddate=#CreateDate('#form.endyear#','#form.endmonth#','#form.endday#')#>
<cfquery........>
select...where recdate >= #startdate#
and recdate <= #enddate#
</cfquery>

It can brows at the first page, but when I click on the next button it shows the error as follow:
An error occured while evaluating the expression
<cfset startdate=#CreateDate('#form.startyear#','#form.startmonth#','#form.startday#')#>

ANY SOLUTION....THANK YOU

Silvano · May 29, 2002

the SQL syntax for that usually looks somewhat like this (depending on the database you are using):

WHERE recdate BETWEEN '#startdate#' AND '#enddate#' Sylvano
dsylvano@hotmail.com

edP123 · May 29, 2002

hi,WWebspider

It doesn't works....Any solution?????

SimonA · May 30, 2002

What error are you getting?

What database are you using?

Help us out here!

CFDude · May 30, 2002

The syntax to set the startdate is correct -- most likely it is the value of the form.startyear, form.startmonth or form.startday that is not getting passed correctly. Make sure that is correct.

For example, if they select a month that only has 30 days like April, but select 31 for the day, then it will give you that error.

edP123 · May 30, 2002

Hi, SimonA
Here's the error message:
An error occured while evaluating the expression
<cfset startdate=#CreateDate('#form.startyear#','#form.startmonth#','#form.startday#')#>

and I'm using Access 2000. Thank you

edP123 · May 30, 2002

Hi, CFDude
I've a valid check for the Start and End Date for year, month and day at the form page using JAVA Script. Thank you.

CFDude · May 30, 2002

Right before the cfset, do a cfoutput of the form.startyear, form.startmonth and form.startday and do a <cfabort> What values are getting passed?

edP123 · May 30, 2002

Hi, CFDude
The value is:
Start Date('2001','6','1')

what I understand is that once I click on the NEXT link it don't have the value to pass on to the,

<cfset startdate=#CreateDate('#form.startyear#','#form.startmonth#','#form.startday#')#>

Thank you.

CFDude · May 31, 2002

You have to pass on the startyear, startmonth, and startday to the page that uses the cfset every time. Form variables do not persist page to page, unless you post to each page every time, and put the values as hidden values. You could set the variables as a session variable and reference those.

Does the error you are getting say it has trouble evaluting the expression FORM.STARTYEAR or something like that?

That would be the problem -- it is not getting the variables it needs. How are you linking the start/next pages together? You can pass the variables on the url line, but you have to reference it by that scope:

e.g
<a href="searchresults.cfm?startyear=2001&startmonth=6&startday=1">Next Page</a>

Then modify your cfset somewhat:
<cfset startdate=#CreateDate('#url.startyear#','#url.startmonth#','#url.startday#')#>

edP123 · Jun 2, 2002

Hi, CFDude

In my "form page", I'm using:
<form action="A18.cfm" method="post" onsubmit="return checkform()">

can form page submit as URL.

And the value will pass in the action page is
<cfset startdate=#creadate('#form.statyear#','#form.startmonth#','#form.start.day#')#>

But the value of the date is optional, is not fixed value.
pls advise... thank you.

CFDude · Jun 3, 2002

What do you mean by the date is optional? If the user doesn't put in a date, what is passed to the page?

I must be missing something here -- can you post your code? The cfset statement is correct (providing that there is a valid form value) so it has to be in the way the form values are getting passed (or not passed).

Tim P.

123edp · Jun 3, 2002

Hi, CFDude
here's the source code of my program(form page and action page):

My form page and program name:A18Recdate.cfm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<cfinclude template="../template/header1.cfm">
<style>
.bu{ background-color: #ffcccc ; color=#003399}
</style>

<html>
<head>
<title>NEW PART NO MONTHLY</title>
</head>

<body bgcolor="#FFFFFF" text="#009900">
<center>
<h1><font color="#7373B9">*** INQUIRY BY RECEIVED DATE ***</font></h1>
<H2> (MONTHLY REPORT) </H2>
</center>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">


<script Language = "javascript">




function checkform(){
if(StartMonthRange()){
if(EndMonthRange()){
if(ValidCheck()){
if(FilledBoxes()){
return true;
}
}
}
}
return false;
}



function ValidCheck()
{
var month = document.forms[0].StartMonth.value
var day = document.forms[0].StartDay.value

if (month < 10){
nmonth = int("0" + month)
window.alert("Month is now"+nmonth)
}
else{
nmonth = month
}

if (day < 10){
nday = int("0" + day)
window.alert("Month is now"+day)
}
else{
nday = day
}

if (document.forms[0].StartYear.value > document.forms[0].EndYear.value){
window.alert("Invalid Choice -=Year=- Start Date Earlier Than End Date&quot

return false;
}
else if (document.forms[0].StartMonth.value > document.forms[0].EndMonth.value && document.forms[0].StartYear.value >= document.forms[0].EndYear.value){
window.alert("Invalid Choice -=Month=- Start Date Earlier Than End Date&quot

return false;
}
else if(document.forms[0].StartDay.value > document.forms[0].EndDay.value && document.forms[0].StartMonth.value >= document.forms[0].EndMonth.value){
window.alert("Invalid Choice -=Day=- Start Date Earlier Than End Date&quot

return false;
}else{
return true;
}
}


function FilledBoxes()
{
if(document.forms[0].StartYear.value == "Year" && document.forms[0].EndYear.value == "Year" || document.forms[0].StartYear.value == "Year" && document.forms[0].EndYear.value != "Year" || document.forms[0].StartYear.value != "Year" && document.forms[0].EndYear.value == "Year" || document.forms[0].StartYear.value != "Year" && document.forms[0].EndYear.value != "Year&quot

{
if(document.forms[0].StartMonth.value == "Month" && document.forms[0].EndMonth.value == "Month" || document.forms[0].StartMonth.value != "Month" && document.forms[0].EndMonth.value == "Month" || document.forms[0].StartMonth.value == "Month" && document.forms[0].EndMonth.value != "Month" || document.forms[0].StartMonth.value != "Month" && document.forms[0].EndMonth.value != "Month&quot

{
if(document.forms[0].StartDay.value == "Day" && document.forms[0].EndDay.value == "Day" || document.forms[0].StartDay.value != "Day" && document.forms[0].EndDay.value == "Day" || document.forms[0].StartDay.value == "Day" && document.forms[0].EndDay.value != "Day&quot

{
window.alert("Please fill in all date boxes&quot

return false;
}
}
}
return true;
}


function MonthCheck()
{
if (document.forms[0].StartMonth.value > document.forms[0].EndMonth.value ){
window.alert("Invalid Choice -=Month=- Start Date Earlier Than End Date&quot

return false;
}
return true;
}


function DayCheck()
{
if (document.forms[0].StartDay.value > document.forms[0].EndDay.value ){
window.alert("Invalid Choice -=Day=- Start Date Earlier Than End Date&quot

return false;
}
return true;
}

function EndMonthRange()
{
if(document.forms[0].EndDay.value == 31 && (document.forms[0].EndMonth.value == 2 || document.forms[0].EndMonth.value == 4 || document.forms[0].EndMonth.value == 6 || document.forms[0].EndMonth.value == 9 || document.forms[0].EndMonth.value == 11)){
window.alert("I'm Sorry, EndDay value exceeds months natrual range&quot

return false;
}
else if(document.forms[0].EndDay.value == 30 && (document.forms[0].EndMonth.value == 2 )){
window.alert("Febuary doesnt have 30 days&quot

return false;
}
return true;
}

function StartMonthRange()
{
if(document.forms[0].StartDay.value == 31 && (document.forms[0].StartMonth.value == 2 || document.forms[0].StartMonth.value == 4 || document.forms[0].StartMonth.value == 6 || document.forms[0].StartMonth.value == 9 || document.forms[0].StartMonth.value == 11)){
window.alert("I'm Sorry, StartDay value exceeds months natrual range&quot

return false;
}
else if(document.forms[0].StartDay.value == 30 && (document.forms[0].StartMonth.value == 2 )){
window.alert("Febuary doesnt have 30 days&quot

return false;
}
return true;
}

</script>

</head>
<body bgcolor="#FFFFFF" text="#000000">


<cfquery name="getDay" datasource="JESEng">
SELECT Day
FROM DateRef_Day
</CFQUERY>


<cfquery name="getMonth" datasource="JESEng">
SELECT Month
FROM DateRef_Month
</CFQUERY>


<cfquery name="getYear" datasource="JESEng">
SELECT Year
FROM DateRef_Year
</CFQUERY>

<form action="A18RecdateInquiry.cfm? method="post" onsubmit="return checkform()">



<DIV ALIGN="CENTER">
<table width="72%" border="0">
<tr>
<td width="17%"><b></b></td>
<td width="20%"><b><font face="Times New Roman, Times, serif" size="3" color="#FF6CB6">Start
Date:</font></b> </td>
<td width="18%"> <font face ="Tahoma" size="2">
<select name="StartDay">
<option value ="Day"><font face="Tahoma" size="2">Day</font></option>
<cfoutput query="getDay">
<option value ="#getDay.Day#"><font face="Tahoma" size="2">#getDay.Day#</font></option>
</cfoutput>
</select>
</font> </td>
<td width="21%"> <font face ="Tahoma" size="2">
<select name="StartMonth">
<option value ="Month"><font face="Tahoma" size="2">Month</font></option>
<cfoutput query="getMonth">
<option value ="#getMonth.Month#"><font face="Tahoma" size="2">#getMonth.Month#</font></option>
</cfoutput>
</select>
</font> </td>
<td width="24%"><font face ="Tahoma" size="2">
<select name="StartYear">
<option value ="Year">Year</option>
<cfoutput query="getYear">
<option value ="#getYear.Year#">#getYear.Year#</option>
</cfoutput>
</select>
</font></td>
</tr>
<tr>
<td width="17%"><b></b></td>
<td width="20%" > <font face ="Tahoma" size="2"><b><font face="Times New Roman, Times, serif" size="3" color="#FF6CB6">End
Date:</font></b> </font></td>
<td width="18%" > <font face ="Tahoma" size="2">
<select name="EndDay">
<option value ="Day"><font face="Tahoma" size="2">Day</font></option>
<cfoutput query="getDay">
<option value ="#getDay.Day#"><font face="Tahoma" size="2">#getDay.Day#</font></option>
</cfoutput>
</select>
</font></td>
<td width="21%" ><font face ="Tahoma" size="2">
<select name="EndMonth">
<option value ="Month"><font face="Tahoma" size="2">Month</font></option>
<cfoutput query="getMonth">
<option value ="#getMonth.Month#"><font face="Tahoma" size="2">#getMonth.Month#</font></option>
</cfoutput>
</select>
</font> </td>
<td width="24%" > <font face ="Tahoma" size="2">
<select name="EndYear">
<option value ="Year"> Year </option>
<cfoutput query="getYear">
<option value ="#getYear.Year#">#getYear.Year# </option>

</cfoutput>
</select>
</font> </td>
<tr>
<td colspan="5">
<div align="center">

</div>
</td>
</tr>
</table>
<p> </p>
<input type="submit" value="Submit" class="bu">
<p> </p>
</div>
</form>
</body>
</html>
<cfinclude template="../template/footer.cfm">

And here's my action page and program name:A18RecdateInquiry.cfm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<cfinclude template="../template/header1.cfm">
<style>
.bu{ background-color: #ffcccc ; color=#003399}
</style>


<CFSET MaxRows = 20>


<CFPARAM NAME="start" DEFAULT="1">
<CFPARAM NAME="A18model" DEFAULT="">
<CFPARAM NAME="DwgNo" DEFAULT="">
<CFPARAM NAME="DwgNm" DEFAULT="">
<CFPARAM NAME="A18suppcode" DEFAULT="">
<CFPARAM NAME="A18sub" DEFAULT="">
<CFPARAM NAME="A18recdate" DEFAULT="">
<CFPARAM NAME="A18issdept" DEFAULT="">
<CFPARAM NAME="A18issdate" DEFAULT="">
<CFPARAM NAME="A18rmk" DEFAULT="">
<CFPARAM NAME="A18jud" DEFAULT="">
<CFPARAM NAME="A18appdate" DEFAULT="">
<CFPARAM NAME="A18duedate" DEFAULT="">



<cfset startDate = #CreateDate('#FORM.StartYear#','#FORM.StartMonth#','#FORM.StartDay#')#>
<cfset endDate = #CreateDate('#FORM.EndYear#','#FORM.EndMonth#','#FORM.EndDay#')#>

<cfoutput>
<font face= "Times New Roman, Times, serif" size="2">
<b> You have selected the date range of <i>#DateFormat(startDate,"dd/mm/yyyy&quot

#</i>
to <i>#DateFormat(endDate,"dd/mm/yyyy&quot

#</i> </b></font>
</cfoutput>


<cfquery name="ViewA18Recdate" datasource="JESEng" dbtype="ODBC">
SELECT Drawing.DwgNo,Drawing.DwgNm,A18NewPart.A18model,A18NewPart.A18suppcode,
A18NewPart.A18sub,A18NewPart.A18recdate,A18NewPart.A18issdept,A18NewPart.A18issdate,
A18NewPart.A18rmk,A18NewPart.A18jud,A18NewPart.A18appdate,A18NewPart.A18duedate
FROM qryA18
WHERE A18NewPart.A18recdate >= #startDate#
AND A18NewPart.A18recdate <= #endDate#
ORDER BY Drawing.DwgNo
</cfquery>


<cfif #ViewA18Recdate.A18recdate# eq "">
ERROR!!! Received Date Was Not Specified!!!
<meta http-equiv=refresh content="2;url=..\A18\A18Recdate.cfm">
</cfif>

<cfset ToRow = start + (MaxRows -1)>
<cfif ToRow GT ViewA18Recdate.RecordCount>
<cfset ToRow = ViewA18Recdate.RecordCount>
</cfif>

<html>
<head>
<title>IQC NEW PART MASTER</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#3333cc">
<h1><div align="center"><font color="##7355B9">LIST OF NEW PARTS (RECEIVED DATE)</h1></div></font>
<cfoutput>
<h2><font color="##6473B9">Total Records To View Are: <font color="##DF00DF">#ViewA18Recdate.RecordCount#</font></font></h2>
</cfoutput>

<TABLE BORDER="2" cellpadding=0 cellspacing=1 bordercolor="#993399">

<TR>
<TH><font color="#cc6666">Model</font></TH>
<TH><font color="#cc6666">Part No</font></TH>
<TH><font color="#cc6666">Part Name</font></TH>
<TH><font color="#cc6666">SuppCode</font></TH>
<TH><font color="#cc6666">Sub</font></TH>
<TH><font color="#cc6666">Rec.Date</font></TH>
<TH><font color="#cc6666">Iss.Dept</font></TH>
<TH><font color="#cc6666">Iss.Date</font></TH>
<TH><font color="#cc6666">Remark</font></TH>
<TH><font color="#cc6666">Jud</font></TH>
<TH><font color="#cc6666">App.Date</font></TH>
<TH><font color="#cc6666">Due Date</font></TH>
</TR>


<CFOUTPUT QUERY="ViewA18Recdate" STARTROW="#start#" MAXROWS="#Maxrows#">
<TR>
<TD>#Trim(A18model)#</TD>
<TD>#Trim(DwgNo)#</TD>
<TD>#Trim(DwgNm)#</TD>
<TD ALIGN="CENTER">#Trim(A18suppcode)#</TD>
<TD ALIGN="CENTER">#Trim(A18sub)#</TD>
<TD>#Trim(A18recdate)#</TD>
<TD ALIGN="CENTER">#Trim(A18issdept)#</TD>
<TD>#Trim(A18issdate)#</TD>
<TD ALIGN="CENTER">#Trim(A18rmk)#</TD>
<TD ALIGN="CENTER">#Trim(A18jud)#</TD>
<TD>#Trim(A18appdate)#</TD>
<TD>#Trim(A18duedate)#</TD>
</TR>
</CFOUTPUT>
</TABLE>
<TR>

<CFSET PrevStart = start - MaxRows>
<CFSET NextStart = start + MaxRows>


<TD COLSPAN ="3" ALIGN="Center">
<CFIF PrevStart GTE 1>
<CFOUTPUT>
<FORM ACTION="A18RecdateInquiry.cfm" METHOD="POST">
<INPUT TYPE="hidden" NAME="start" VALUE="#PrevStart#">
<INPUT TYPE="hidden" NAME="A18model" VALUE="#A18model#">
<INPUT TYPE="hidden" NAME="DwgNo" VALUE="#DwgNo#">
<INPUT TYPE="hidden" NAME="DwgNm" VALUE="#DwgNm#">
<INPUT TYPE="hidden" NAME="A18suppcode" VALUE="#A18suppcode#">
<INPUT TYPE="hidden" NAME="A18sub" VALUE="#A18sub#">
<INPUT TYPE="hidden" NAME="A18recdate" VALUE="#A18recdate#">
<INPUT TYPE="hidden" NAME="A18issdept" VALUE="#A18issdept#">
<INPUT TYPE="hidden" NAME="A18issdate" VALUE="#A18issdate#">
<INPUT TYPE="hidden" NAME="A18rmk" VALUE="#A18rmk#">
<INPUT TYPE="hidden" NAME="A18jud" VALUE="#A18jud#">
<INPUT TYPE="hidden" NAME="A18appdate" VALUE="#A18appdate#">
<INPUT TYPE="hidden" NAME="A18duedate" VALUE="#A18duedate#">
<BR>
<A HREF="../A18/A18RecdateInquiry.cfm?start=#PrevStart#"><font size="+1">Previous #MaxRows#</font>
<B><strong> | </strong></B>
<A HREF="../A18/A18Recdate.cfm"><font size="+1">BACK</font></A>
</FORM>
</CFOUTPUT>
</CFIF>
</TD>

<TD COLSPAN ="3" ALIGN="Center">
<CFIF NextStart LTE ViewA18Recdate.RecordCount>
<CFOUTPUT>
<FORM ACTION="A18RecdateInquiry.cfm" METHOD="POST">
<INPUT TYPE="hidden" NAME="start" VALUE="#NextStart#">
<INPUT TYPE="hidden" NAME="A18model" VALUE="#A18model#">
<INPUT TYPE="hidden" NAME="DwgNo" VALUE="#DwgNo#">
<INPUT TYPE="hidden" NAME="DwgNm" VALUE="#DwgNm#">
<INPUT TYPE="hidden" NAME="A18suppcode" VALUE="#A18suppcode#">
<INPUT TYPE="hidden" NAME="A18sub" VALUE="#A18sub#">
<INPUT TYPE="hidden" NAME="A18recdate" VALUE="#A18recdate#">
<INPUT TYPE="hidden" NAME="A18issdept" VALUE="#A18issdept#">
<INPUT TYPE="hidden" NAME="A18issdate" VALUE="#A18issdate#">
<INPUT TYPE="hidden" NAME="A18rmk" VALUE="#A18rmk#">
<INPUT TYPE="hidden" NAME="A18jud" VALUE="#A18jud#">
<INPUT TYPE="hidden" NAME="A18appdate" VALUE="#A18appdate#">
<INPUT TYPE="hidden" NAME="A18duedate" VALUE="#A18duedate#">
<BR>
<A HREF="../A18/A18RecdateInquiry.cfm?start=#NextStart#"><font size="+1">Next #MaxRows#</font>
<B><strong> | </strong></B>
<A HREF="../A18/A18Recdate.cfm"><font size="+1">BACK</font></A>
</FORM>
</CFOUTPUT>
</CFIF>
</TD>
</TR>
</body>
</html>
<cfinclude template="../template/footer.cfm">

THANK YOU....

CFDude · Jun 3, 2002

You are not posting the data to the A18RecdateInquiry.cfm page with your link. An href link is not the same thing as a form post. It is not seeing your form.year, etc because those variables do not exist.

Change this:
<A HREF="../A18/A18RecdateInquiry.cfm?start=#NextStart#"><font size="+1">Next #MaxRows#</font>

to

<input type = hidden name="start" value = "#NextStart#">
<input type = submit value="Next #MaxRows#">

The other way to do it would be to put all the variables on the href line, and change the way you reference them.

e.g
<A HREF="../A18/A18RecdateInquiry.cfm?start=#NextStart#&A18model=#A18model#&DwgNo=#DwgNo#&DwgNm=#DwgNm#"><font size="+1">Next #MaxRows#</font>

(I only put the first 3, but you have to put all of the on the url for the next page to "see" them.

Then on the A18RecDateInquiry.cfm, you have to change the scope to url:

<cfset startDate = #CreateDate('#URL.StartYear#','#URL.StartMonth#','#URL.StartDay#')#>
<cfset endDate = #CreateDate('#URL.EndYear#','#URL.EndMonth#','#URL.EndDay#')#>

If you change it to use the URL instead of form, then the first form will not work since you are posting that data. Change the method="post" to method="get" and it will do the same thing.

edP123 · Jun 3, 2002

it still can't works.....

Is there any way to keep the value to return to the <cfset startdate=#creadate('#form.satartyear#'.....)>, after click on the next button....
eg:
total record to view are 137

maximum view per screen is 20 records, so the balance records should view very screen is 20 records.

Thank you.

CFDude · Jun 4, 2002

This is getting difficult to diagnose here. When you say it doesn't work -- what is the error or problem?

I still think the problem lies in the way you are going from one page to another. If you want to use form variables, you must use a form method of post and use a submit button to do it.

edP123 · Jun 4, 2002

Hi, CFDude

Thanks for your help, finally I get it. Thank you.

Guest_imported · Jul 1, 2002

Pass data of javascript to cold fusion.
For example:
<cfquery name="hola" "bd">
SELECT hola FROM jasdkj
WHERE si = ¿¿¿(form0.capo.value)???
How can I access to this value with cold fusion???
thanks a lot

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

how to use next/previous record browsing

Technical User

Programmer

Technical User

Programmer

Programmer

Technical User

Technical User

Programmer

Technical User

Programmer

Technical User

Programmer

Programmer

Programmer

Technical User

Programmer

Technical User

New member

Similar threads

Log in

Part and Inventory Search

Sponsor