How do I discard a row from a ColdFusion query?

coldfusion railo
Jordan Sitkin picture Jordan Sitkin · Apr 22, 2011 · Viewed 7.8k times · Source

Given a query (pseudo-code):

<cfquery name="myquery">SELECT * FROM stuff</cfquery>

How do I get rid of the first record? In this case, altering the SQL is not an option. I have tried: myquery.RemoveRows(0,1); but received an error:

No matching Method/Function for Query.REMOVEROWS(numeric, numeric) found

I'm on Railo 3 BTW

Answer

Jordan Sitkin picture Jordan Sitkin · Apr 22, 2011

Lo and behold:

myquery.RemoveRow(1);

Does exactly what I wanted. Leave it to Railo to do things a little differently!

Related questions

How to do a cfdump inside a cfscript tag?

In order to debug I would like to dump certain variables on to my web page. How can I do that from inside a cfscript tag? I tried the following but it isn't working: <cfscript> ... <cfif cgi.…

Read More
Tomcat possible memory leak

The university I work at uses a Tomcat/Railo server to render ColdFusion pages. For about 6 months (before I was hired) the servers have been randomly crashing at different times, usually runnign service railo_ctl restart has fixed hte issue, …

Read More
Trying to find a syntax highlighter for ColdFusion in Notepad++

I use CFEclipse for most of my projects and heavy lifting but sometimes I find the need to do a quick fix on pages outside the project scope that is easier to accomplish in a simple text editor. I have …

Read More