RE: Sorting a Query of a Query

Have you confirmed that storeid is a column name in the query? You can do that by doing: cfoutput #qGetOrders.columnlist# /cfoutput It's unrelated,but you also need a comma between the two sort fields i.e. ORDER BY #orderby# , #updn# If all else fails (I know this works for Oracle, I

RE: Sorting a Query of a Query

: Thursday, October 18, 2001 8:15 AM To: CF-Talk Subject: Re: Sorting a Query of a Query You need a comma between #orderby# and #updn# for one thing. Dave - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 17, 2001 9:47 AM

Re: Sorting a Query of a Query

You need a comma between #orderby# and #updn# for one thing. Dave - Original Message - From: Joshua Miller [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, October 17, 2001 9:47 AM Subject: Sorting a Query of a Query When attempting to ORDER BY on a Query of a