Ah! CFHTTP queries! A big item for my personal the wish list:
CFHTTP has the useful ability to take data from a URL and turn it into a query that
you can then manipulate as any query.
1) CFHTTP interprets the data as a comma separated list (CSV) to turn it into a query.
*BUT* it does NOT correctly interpret Microsoft Excel's "format" of CSV files, which
in my experience is the source of 100% of the CSV files I use. This makes CFHTTP
useless for reading Excel CSV files :-( .
Specifically, Excel does NOT put quotes around fields without commas, Excel DOES put
quotes around fields with embedded commas (to protect them from being interpreted as
field separators). CFHTTP will choke on this format. Either ALL of the fields must
have quotes or NONE of them (CF V4.5.1)
2) I often need to allow users to upload a file and interpret it as a query. Ie: my
users keep administrative data in spreadsheets and upload it to make bulk changes to
the database. I *rarely* need to make a query out of a URL on another site. However
this query functionality is built into CFHTTP only. So I have to upload the file to a
web-accessible place (being careful with naming so multiple users don't clobber each
other) and then in a second step retrieve it from my own web site with CFHTTP. These
two steps shouldn't be needed. I'd like CFFILE or some other function to be able to
make a query directly out of a file!
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
