Josh, you're missing the point entirely. Converting from CSV->Query makes sense and wasn't being questioned.
Using the cfhttp tag to do the conversion is what's crazy. There is no sensible reason for requiring CSV conversion to go via HTTP - since the vast majority of the time this isn't necessary/desired - having a dedicated cfcsv tag and/or CsvParse function would have made sense. As I said, we'd need to ask the relevant developers why the decision to tangle the CSV functionality with cfhttp was made. (Rick, I used "Adobe" as shorthand; not to exclude Macromedia or Allaire.) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm