column sorting and next/back page

[jedrtd]

I'm tring to use this code on a page with column header sorting and page next/back. but I get an error

The value "" cannot be converted to a number


The Error Occurred in D:\

http://wwwroot\PrintStreamTest\Profit_By_Customer\NextNIncludeBackNext.cfm:

line 13

11 : <cfloop list="#CGI.Query_String#" index="namevaluepair" delimiters="&">
12 : <cfif ListFirst(namevaluepair, "=") NEQ "StartRow" >
13 : <cfset modifiedQueryString = modifiedQueryString + "&" + namevaluepair >
14 : </cfif>
15 : </cfloop>


HERE IS THE CODE


<cfset modifiedQueryString = "">
<cfloop list="#CGI.Query_String#" index="namevaluepair" delimiters="&">
<cfif ListFirst(namevaluepair, "=") NEQ "StartRow" >
<cfset modifiedQueryString = modifiedQueryString + "&" + namevaluepair >
</cfif>
</cfloop>


<CFOUTPUT>
<!--- Show link for Back, if appropriate --->
<CFIF StartRowBack GT 0>
<A HREF="#CGI.SCRIPT_NAME#?StartRow=#StartRowBack##modifiedQueryString#">
<IMG SRC="BrowseBack.gif" WIDTH="40" HEIGHT="16"
ALT="Back #RowsPerPage# Records" BORDER="0"></A>
</CFIF>
<!--- Show link for Next, if appropriate --->
<CFIF StartRowNext LTE TotalRows>
<A HREF="#CGI.SCRIPT_NAME#?StartRow=#StartRowNext##modifiedQueryString#">
<IMG SRC="BrowseNext.gif" WIDTH="40" HEIGHT="16"
ALT="Next #RowsPerPage# Records" BORDER="0"></A>
</CFIF>
</CFOUTPUT>

 

[ecobb]

Try this instead and see what it gives you:

<cfset modifiedQueryString = "#modifiedQueryString#&#namevaluepair#">

Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[jedrtd]

That was the ticket, thanks much