At this point I'm just trying to display it, but I will eventually be storing both the SKU and the description in two separate db fields. The file format sucks, but I can't do too much to change it...thousands of records, some has html other records don't....
----- Original Message ----- From: "Andy Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, October 05, 2005 12:43 PM Subject: RE: CFHTTP > Are you trying to write to the text file or just read the whole thing in? > > <!----------------//------ > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: Matthew Blatchley [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 05, 2005 12:29 PM > To: CF-Talk > Subject: CFHTTP > > > I'm trying to break down a txt file using cfhttp and running into a road > block. It's txt file that contains regular and HTML tags. I keep getting > an error when it gets to the HTML code in the file. > > example: > <cfhttp url="description.txt" method="GET" name="Inventory_Stats" > columns="SKU,PRODUCT_DESCRIPT" textqualifier="" delimiter="|"> > The text file format looks like this: > 12345354 | <p>html here</p> > I continue to not be able to get the HTML to be put in a column properly > and > get an error. > > "Illegal operation in Cold Fusion Extension (CFX) You have attempted to > refer to an invalid row/column combination of a query." > > I've tried a few different attempts and have read a few different > posting, > but most aren't doing exactly this. What to I need to do, use > #cfhttp.FileContent# instead and then loop through the records? > > Matt > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220147 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
