Incidentally -- House of Fusion is not letting me change my primary email address -- My actual email is [EMAIL PROTECTED] if anyone was writing me back.
Also, I solved the problem, but in a workaround way-- Since I'm only trying to ORDER BY the columns in question I am using column ordinals instead of names, such as: SELECT * FROM thetable ORDER BY 3 The only trick there is to know the order of the columns in the result set from which you're querying -- this can not be derived from the COLUMNLIST property of the query object since it is always returned alphanumerically sorted-- fortunately I was able to view the original Oracle Function and saw the select statement-- then I just mapped the values and my sortable columnheaders form now works. What a pain though! --Brendan Baldwin :: [EMAIL PROTECTED] On 8/25/05, Brendan Baldwin <[EMAIL PROTECTED]> wrote: > > Hi everyone -- > > I'm working for a client who has given me some Oracle stored procedures > which return some fields that have SPACES in the columns returned. > > I want to apply sorting to the results, so I was going to use a CFQUERY > DBTYPE="query" and just ORDER BY selectively-- > > The problem is that I can't seem to reference column names that have > spaces in them when doing a QoQ ! > > Anyone know how to reference column names with spaces in a QoQ? > > I've tried: > SELECT * FROM thetable ORDER BY 'my column' > SELECT * FROM thetable ORDER BY "my column" > SELECT * FROM thetable ORDER BY [my column] > SELECT * FROM thetable ORDER BY ['my column'] > > Any other Ideas? > > --Brendan > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
