Qing Xia wrote:> then simply do: > <cfif LEN((TRIM(form["sortORD_#myIDX#"]))> > link_sort = <cfqueryparam value="#Form["sortORD_#myIDX#"]#" > cfsqltype="CF_SQL_VARCHAR"> > </cfif>
Yea, was hoping to avoid all those extra cfif statements and keep it a little neater. Oh well!! The reason for the default "99" (or whatever) was to give the sorting column a high number value so record with an actual sort number (1,2,3,4,5...) would come up first. This leads me to my *other* option - go ahead an insert the NULL and then use coalesce on the output query to keep those pesky records with no sort number at the bottom of the pile. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
