Please check out my new site: http://ja.mesbrown.com/

QueryDeleteRows UDF in CFLib

Posted At : April 3, 2009 5:14 PM | Posted By : James Brown
Related Categories: Fusebox, ColdFusion

Oddly enough, ColdFusion doesn't have a QueryDeleteRows function. Luckily for us, Ray Camden has come up with a UDF to help us. If you view the UDF in CFLib you can plug that UDF into your code and then just issue a

view plain print about

1<cfset x = "1" />
2<cfset Query = QueryDeleteRows(Query,x) />

and it will remove your row. You can even list multiple rows (e.g. "1,3,5"). This function is especially helpful with Fusebox because I had pre-existing to create a drop-down menu and I didn't need a row.

Thanks Ray!

Comments (1) |

Print |

Send | 1303 Views |

TweetBacks

Comments

[Add Comment] [Subscribe to Comments]

You can also use the underlying Java to remove query rows and it will save you from looping through the query.

Query.removeRows(JavaCast("int",startRow-1),JavaCast( "int", Rows ));

You have to subtract 1 from the ColdFusion Query row index, because the Java row numbering starts at 0.

# Posted By Dominic O'Connor | 4/6/09 11:55 AM

[Add Comment]

Archives by Subject

Adobe (13) [RSS]
ColdBox (3) [RSS]
ColdFusion (66) [RSS]
Database (4) [RSS]
Facebook (1) [RSS]
Fusebox (2) [RSS]
Google (2) [RSS]
JavaScript (12) [RSS]
jQuery (7) [RSS]
Linux (1) [RSS]
ORM (5) [RSS]
Programming (6) [RSS]
SEO (2) [RSS]
SVN (1) [RSS]
Tips (4) [RSS]
Tour de ColdFusion (3) [RSS]
Twitter (2) [RSS]

Please check out my new site: http://ja.mesbrown.com/

QueryDeleteRows UDF in CFLib

TweetBacks

Comments

Archives by Subject

Recent Entries

Recent Comments

RSS

Tags

ibjhb.com

Recent Comments

Popular Posts

Connect with the Community

Contact Information