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:
Nope all list functions.
I have opened the discussion in an area that can't be named, so I will wait
for what responses I get from there. I am curious why it has never been
fixed?
And to confirm it, yes all list functions do not work as expected. So that
means they are all broken.
--
Senior
Its not broken
You define a character as a delimiter and it breaks the list up into items
separated by that character. CF doesn't know it's a CSV formatted string,
and why would it care? Its doing what you tell it and as far as I know it
has always worked like that.
-Original Message-
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
On Wed, Sep 10, 2008 at 01:45:46PM +0800, Brett Payne-Rhodes 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
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
Not an option... Looked at it will not work for this scenario.
But like I said the issue is complete, I wrote it in Java and done what I
needed to do. But Java inside of Coldfusion, do someting ColdFusion could do
is a bad, bad and very bad hack in my eyes.
Just would have been quicker for me
Steve,
Actually it is not doing as you tell it, because
Item1,item2,item3,item4
IS and always will be one item, even if I use comma as a delimeter. This is
the way CSV's have worked in .Net and ASP (none .net) 10 years ago. I don't
think the argument that it is behaving normally is right, it
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
What it is doing is correct.
It has always worked like that, list functions have never treated quoted
fields as one. I think your confusing list functions with CSV handling.
Regards
Dale Fraser
http://learncf.com
http://flexcf.com
-Original Message-
From: cfaussie@googlegroups.com
Not broken,
Working perfectly, just not what you want.
Regards
Dale Fraser
http://learncf.com
http://flexcf.com
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Wednesday, 10 September 2008 4:03 PM
To:
Hi Andrew,
Not sure if this works for your application but we've used this
ColdFusion UDF before in a project for CSV parsing:
http://www.bennadel.com/index.cfm?dax=blog:991.view
It converts your file data into an array not a list, but at least it
takes care of commas within quotes, and
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
Thanks Steve,
I'll admit that I didn't know that. Could be very useful...
Cheers,
Brett
B)
Steve Onnis wrote:
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
Steve, when I get a chance to I'll try it as this is a once off I am not
going to spend time on something that has been completed and passed back to
management :-(
And no I did not know that.
As for a discussion on whether it is broken or not.
CSV has had a compliance standard back to the
I have set custom properties into a PDFHello=World
and when I dump the results from CFPDF action=getInfo
I get this
Properties[[Ljava.lang.String;@1aabfab]
Does anyone have any clues how I can get this back to a string?
--
AJ Mercer
Web Log: http://webonix.net
Once you come to
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
why not just grab an existing java lib which supports CSV?
like http://supercsv.sourceforge.net/ or something?
On Wed, Sep 10, 2008 at 5:15 PM, Andrew Scott [EMAIL PROTECTED]wrote:
Ok that doesn't work for me.
--
Senior Coldfusion Developer
Aegeon Pty. Ltd.
www.aegeon.com.au
Phone:
Zac,
Did you read my posts?
--
Senior Coldfusion Developer
Aegeon Pty. Ltd.
http://www.aegeon.com.au/ www.aegeon.com.au
Phone: +613 9015 8628
Mobile: 0404 998 273
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Zac Spitzer
Sent: Wednesday, 10
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:
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?
That's an example of the tag
The CODE is below that
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Andrew Scott
Sent: Wednesday, 10 September 2008 5:28 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Quick List question
Yeah I
Sorry,
I tried that too, same result. Now that I am at home, I'll try it here as
well.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Wednesday, 10 September 2008 5:31 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re:
Same problem..
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging
purposes.
Error Occurred While Processing Request
Incorrect number of columns in row.
The code is this
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
CyberAngel wrote:
Sorry,
I tried that too, same result. Now that I am at home, I'll try it here as
well.
I tried this variation and it worked fine:
cfif structKeyExists(URL, docsv)
cfset csvdata = Col_1,Col_2,Col_3,Col_4chr(13)chr(10) /
cfset csvdata = csvdata 'List Item ##1, List
This is the file
http://www.novahost.com.au/csv.cfm
This is on CF8.0.1. I also checked it on CF6.1 and worked fine.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Kym Kovan
Sent: Wednesday, 10 September 2008 6:35 PM
To:
Stupid setting up on another port and forgetting to add it:-(
Sorry Steve that does work a treat...
Still I would prefer to see CF adopt the support of single/double quotes
when using lists to begin with, and that is all I wanted to say in the first
place :-(
But damn handy to know that
Ok,
See my previous post on it working, but switch firstrowasheaders to true, on
a csv file and I get the following error. So it's sort of a workaround,
still damn handy to know.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
If anyone is interested.
CSV files with column names in the first row... MUST NOT contain spaces, I
assume without quotes around them at least.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Wednesday, 10 September 2008
What's the best charset to use?
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Steve Onnis
Sent: Wednesday, 10 September 2008 6:40 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Quick List question
This is the file
Ryan,
Sorry I didn't see your post, that would have done the trick as well.
-Original Message-
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of [EMAIL PROTECTED]
Sent: Wednesday, 10 September 2008 4:36 PM
To: cfaussie
Subject: [cfaussie] Re: Quick List question
Hi Guys,
ACTAPUG user group meeting tonight, Andrew Muller presenting Flex/AIR demos.
Next user group meeting is going to focus on Flash/Flex accessibility,
recommendations for a guru please?
R
--~--~-~--~~~---~--~~
You received this message because you are
Gosh Rae, when I saw the title and preview of this email I thought
that I'd added another string to my bow ;-)
2008/9/11 Rae Buerckner [EMAIL PROTECTED]:
Hi Guys,
ACTAPUG user group meeting tonight, Andrew Muller presenting Flex/AIR demos.
Next user group meeting is going to focus on
Lol... understandable, It may be that I'll have to do the presentation
myself as I know the sorts of questions they will most likely ask :(
On Thu, Sep 11, 2008 at 9:10 AM, Andrew Muller [EMAIL PROTECTED]wrote:
Gosh Rae, when I saw the title and preview of this email I thought
that I'd added
Because of the huge response to the offer, Ben may be ending this
offer soon. So if you're still deciding, be aware, you may miss out.
Chris
On Tue, Sep 9, 2008 at 3:49 PM, Chris Velevitch
[EMAIL PROTECTED] wrote:
If you planning to go to MAX US or MAX Europe you can get a $US400 discount.
36 matches
Mail list logo