Matt. I like the idea of using a java-based CFX tag, but my problem is
that I am using hosting service and they won't allow it.
As for cf_csv2query, I found it. After testing it, I found that it is
putting 0.00 in all my numeric fields, even if there is a value in the
csv.
See attached custom tag
I am using this:
<CF_CSV2DATA
datasource="JRS"
file="#expandPath('.')#/7-15-2005-InventoryItems.csv"
table="inventory2"
columnhead="yes"
append="no"
column="Name,OnlineDescr,DetailDescr,PrefVendor,BasePrice,F2Price,OnHand,InternalID"
datatype="CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_DECIMAL,CF_SQL_DECIMAL,CF_SQL_BIGINT,CF_SQL_BIGINT"
>
On 7/19/05, Matt Robertson <[EMAIL PROTECTED]> wrote:
> On 7/19/05, Ken <[EMAIL PROTECTED]> wrote:
> > Matt: Please see if you can send me the file, or tell me where to get
> > it from. Thanks.
>
> I *think* the file is cf_csv2query 1.0 in the Devex. I'm not sure and
> the author now wants US$50 for it (!) so I can't check to be sure if
> his v1.0 $50 tag is the one I originally downloaded for free.
>
> Ryan Emerle has some really great stuff out there for folks.
>
> http://www.emerle.net/programming/
>
> His cfx_text2query is a "java-based CFX tag for parsing delimited text
> files and converting them to ColdFusion queries."
>
> I had forgotten about this when I posted earlier. I have another
> client processing multiple megabytes of uploaded csv files per day and
> IIRC I used Ryan's CFX, along with Paul Vernon's CFPOP replacement --
> to turn mountains of processing time into blips on the processor
> graph.
>
> Ryan gives his stuff away but asks for a small donation, which I would
> encourage. That tag saved me from a server upgrade.
>
> --
> --mattRobertson--
> Janitor, MSB Web Systems
> mysecretbase.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212259
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
