Title:
Bug 84018:(Watson Migration Closure)Create a function for converting CSV data to a query and vice versaActually this functionality already exists, but just inside the <cfhttp> tag
| View in TrackerStatus/Resolution/Reason: Closed/Deferred/
Reporter/Name(from Bugbase): Sebastian Zartner / Sebastian Zartner (Sebastian Zartner)
Created: 09/02/2010
Components: Language, Functions
Versions: 9.0.1
Failure Type: Unspecified
Found In Build/Fixed In Build: 0000 /
Priority/Frequency: Minor / Unknown
Locale/System: English / Platforms All
Vote Count: 0
Problem:
Create a function for converting CSV data to a query and vice versaActually this functionality already exists, but just inside the <cfhttp> tag. I wonder why this feature was just implemented in <cfhttp>, but not also in <cffile action="read"> (resp. FileRead()) or (as this enhancement request is for) as seperate function.According to the possible attributes for the <cfhttp> tag this function could then look like so (maybe with different parameter order):CSVToQuery(CSV [, columns, delimiter, firstrowasheaders, textQualifier])Also there should be a function, that is doing the opposite (converting a query to CSV data), which could look like:QueryToCSV(query [, delimiter, textQualifier, includeHeaders])The parameter 'includeHeaders' should thereby be a boolean value specifying, if the column names should be used as header (if not specified, no header row will be added).
Method:
Result:
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3042121
External Customer Info:
External Company:
External Customer Name: Sebastian Zartner
External Customer Email: 4E7365D64550DB12992015D5
External Test Config: 09/02/2010Attachments:
Comments: