Yeah I reformatted the lines. However, as I have not seen this before. It is very likely that I haven't.
<cfhttp url="csvfile.txt" name="csvQry"></cfhttp> <cfdump var="#csvFile#" /> Returns blank page on my standard cfusion, and EE Coldfusion. So if I look at the above, it should dump something! Yes? And yes I am Coldfusion 8, openBD, Railo V3.0 and ColdFusion XX all refuse to run that code for me:-( So is that weird or what! -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 10 September 2008 5:22 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Did you make sure you fixed the lines up ? The email wrapped some of the lines of code :) Also that was done quickly on CF8 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, 10 September 2008 5:15 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Ok that doesn't work for me. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 10 September 2008 4:41 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question You didn't know that.... <cfhttp url="csvfile.txt" name="csvQry"></cfhttp> ...will return to you a query object based on the csv data in the file? Try this for an example. Just save it to a file and run it. <cfsetting enablecfoutputonly="Yes" showdebugoutput="No" /> <cfif structKeyExists(URL, "docsv")> <cfset csvdata = "List Item ##1, List Item ##2, ""inner List Item ##1, inner List Item ##2"", List Item ##4" /> <cfoutput>#csvdata#</cfoutput> <cfelse> <cfhttp url="http://#server_name#/#script_name#?docsv=true"; name="myCSV" firstrowasheaders="No"></cfhttp> <cfdump var="#myCSV#"> </cfif> It outputs a query object with 1 row in it with the csv data in tact. From there you can just loop over the query and do what you want to do with the data. Easy enough for you? Steve -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, 10 September 2008 4:27 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Steve, How do you get it to a query, when the list function is broken? Can you explain that more? However, I personally am not interested in a solution. It has been completed, it is something that I feel should work differently. I would prefer to look elsewhere when ColdFusion is like this, a java object in CF works wonders too you know!!! And you have all the list append etc, so why is ColdFusion different is the real question I am asking:-) -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 10 September 2008 4:23 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Do a CFHTTP, get it into a query recordset and loop over the query to rebuild your CSV. At least this way you have the data in a format that is going to be easier to work with than trying to loop over a file. >From what I can see you are making something that can be done pretty easy into a nightmare for yourself. Steve -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Wednesday, 10 September 2008 4:18 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Ok first of all this is a one of conversion for an excel spreadsheet (CSV saved), secondly who said anything about recordsets? All I need to do is open the csv, read it line by line and recreate the csv taking the quotes from around a list item and expand that into another csv. It is 100% file based, a cfhttp is not going to work (At least I don't see how) and secondly as it is a once of the problem has already been done in Java. The question I have is why could I not do it ColdFusion? Without &^%$#@'ing around, and still not get it to work? Java/Groovy/.Net no problem, ColdFusion massive problem. I have flagged it for discussion in the relevant area, so we'll see what the development team now say. It has been version 5 since I last needed to do something, I am just annoyed that it is still an issue 3 versions +1 later. -- Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Steve Onnis Sent: Wednesday, 10 September 2008 4:04 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Why don't you put the file somewhere and do a CFHTTP on it and create the recordset like that? -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Barry Beattie Sent: Wednesday, 10 September 2008 3:58 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Quick List question Andrew, I'm curious is it just the ListGetAt(position) function that's the grief? it might be "broken" itself I wonder if all list functions are similarly broken: if you convert your list to an array with ListToArray(list) first would you get the correct 4 items or incorrect 6 items? On Wed, Sep 10, 2008 at 3:45 PM, Brett Payne-Rhodes <[EMAIL PROTECTED]> wrote: > > I don't think list processing is clever enough to say "Ignore delimiters that are inside double quotes" so it treats the comma inside your 'third' element as a valid delimiter. > > You might have to run a clever bit of regex to replace said commas before the list processing and once you have the element then simply restore the commas. > > Someone cleverer than me will need to provide the regex though... :) > > > B) > > > Andrew Scott wrote: >> Scott, >> >> Cheers but I don't see how that helps, I am aware of how empty lists >> are handled. The problem lies in this example >> >> List Item #1, List Item #2, "inner List Item #1, inner List Item #2", >> List Item #4 >> >> This is for all intent and purposes only 4 items. Yet ColdFusion sees >> this as 6!! >> >> I know that this has popped up many times, and when you need it do >> you think google is helping? >> >> So ListGetAt(myList,4) >> >> Returns >> >> Inner List Item #2 when it clearly should be List Item #4 >> >> >> > > -- > Brett Payne-Rhodes > Eaglehawk Computing > t: +61 (0)8 9371-0471 > m: +61 (0)414 371 047 > e: [EMAIL PROTECTED] > w: http://www.yoursite.net.au > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
