I am starting to build a lot of data-aware movies that will connect to coldfusion mx. Instead of jumping back and forth between the CFC and the FLA, I was thinking of building a generic CFC which would accept a string (which would be a well formed SQL statement) and return the query result. This way, I would use flash to create the SQL query string, always send it to the same CFC and then handle the result (by storing it in a global var or something like that).
Does this approach have any pitfalls that I am not considering (yes, I know the sql will have to be optimized each time and will not be quite as fast as a stored proc).
Thanks