>
> It is EASY with cfhttp (if you've got well formed data), but I have
> never load tested it.
>
> or (not nearly as easy)
>
> If you've got createObject "power" you can use HSSQLDB, which seems
> pretty
> robust for CSV stuff- but CFHTTP is probably fastest from 0 to Query.
>
> The one advantage to rolling your own, is you can do it all in one
> statement (if
> it's really well formed, mind), with the old
>
> INSERT INTO table (col1,col2,col3)
> VALUES (
> ("row","one","values"),
> ("row","two","values"),
> ("row","three","values")
> )
>
> Or something like that. Instead of 2000 inserts, you can do one- but
> it'll
> be a monster.
Thank you so much--this worked like a charm (once I realized that there was a
tab at the end of the lines mucking things up, that is).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272627
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
