I am adding search functionality to the application that I am building. The wrinkle is that I wrote a function that determines if the "inbound" search string is a complex (Verity) search or a simple (SQL) search; if it's Verity, I include one file, if SQL, I include the other. The main reason for this is to allow users to perform simple searches against new data rather than having to constantly refresh the Verity collection.
So, I have 2 possible "queries" and one set of display code (for simplicity and consistency). Because I want to allow users to sort some of the result columns, I am doing a Query of a Query against the query object that CFSEARCH returns. The problem is this. As you may know, the developer has no real control over the column names that Verity returns, i.e. it returns key, rank, custom1, custom2, etc. rather than meaningful column names. Since I am doing a QoQ against the cfsearch query object, I just figured that I would alias the query object "column names" to those names that I am using from the SQL query. Well, the custom1, custom2, etc. column names have no problems with having aliases assigned, but when I try to even select "key" in my statement (without aliasing it), the query bombs with this error: "Query Of Queries syntax error. Encountered "key. Incorrect Select List, Incorrect select column, " This is really weird, since when I do a cfdump of the returned query object, I see the "key" column. Is this a bug? Other than assigning the value I need to one of the custom fields (which I can't, I've used all 4), is there a solution to my problem? Thanks, Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210137 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
