> i didnt know it loaded into a query, see i told ya i dont know jack
> (least im tryin)
> we havent seen the csv yet though, if i recall it looked like
>
> "name" "blaha" "lala"
>
> are u sure? doesnt seem right to me
Yep - sure...
<cfhttp
method="GET"
timeout="20"
url="" gets the file with a
timeout of 20 seconds
name="qGetData" <--- Sets the name for the query that the CSV will
be loaded into.
delimiter="," <--- says that each column will be seperated by a comma
textqualifier="""" /> <--- says that double quotes will be used to
delimit text columns
There is an attribute called "columns" which you can put a comma
delimited list of columns that will be used when the query is
generated. However, by default, cfhttp will take the first line of the
file and use this as the columns.
You could have used this method with the water data that you used in
your example, if they had put the data description seperate from the
data and they hadn't put a row of bad data below the column headings,
before starting the actual water data.
Regards
Stephen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
