[cfaussie] Re: Finally a CF conference for Melbourne

2009-02-17 Thread Zac Spitzer
wow that is great news! On Tue, Feb 17, 2009 at 2:33 PM, Mark Mandel mark.man...@gmail.com wrote: I just got in trouble with Toby for not posting his blog post! http://www.tobytremayne.com/2009/02/cfobjectiveanz/ We're all very excited to bring this conference down to Australia, and we

[cfaussie] Re: Upgrading to CF8 advice?

2009-02-17 Thread Zac Spitzer
in my experience, cf8 was more like a feature packed service pack than a new version :) easy z On Tue, Feb 17, 2009 at 2:31 PM, Matthew matthewbchamb...@gmail.com wrote: Hi everyone We are finally upgrading to CF8 from CF7 (Standard). I'm looking forward to playing around with all the

[cfaussie] Re: RegEx replace text, but not within a tags

2009-02-17 Thread Joris de Beer
Also take a look at Regex Back References: http://livedocs.adobe.com/coldfusion/7/htmldocs/0989.htm cfhttp url=http://google.com.au; / cfset NewFileContent = REReplaceNoCase(cfhttp.filecontent, (a[^]*)*(/a), \1 ClickFind \2, all) cfdump var=#cfhttp# cfoutput #NewFileContent# /cfoutput

[cfaussie] Re: Finally a CF conference for Melbourne

2009-02-17 Thread CyberAngel
Agreed, Kudos to all involved in negotiating this. The biggest thing that I see for us here in Australia, and not just Melbourne is that it can bring more awareness to the language itself. Again kudos to all involved. -Original Message- From: cfaussie@googlegroups.com

[cfaussie] Re: Upgrading to CF8 advice?

2009-02-17 Thread CyberAngel
Mathew, This is more an FYI than anything else, Coldfusion 8.0 / 8.01 has a small part of its underlying Ajax UI as using the YUI framework. The majority of this extra functionality is actually extJS and there is a big difference between the 2 frameworks. -Original Message- From:

[cfaussie] Re: Upgrading to CF8 advice?

2009-02-17 Thread Dale Fraser
Had no issues 7 - 8 Regards Dale Fraser http://dale.fraser.id.au http://learncf.com http://flexcf.com -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Zac Spitzer Sent: Tuesday, 17 February 2009 3:56 AM To: cfaussie@googlegroups.com

[cfaussie] Problems Uploading CSV data into SQL table

2009-02-17 Thread SAMARIS Software
The following is an extract from a txt / csv file I import into my sql database 095,2 Bdrm S,Clean House,,WRIGHT x2 095A,Hotel,Svc Daily,18/02/2009,ANGELL x1 096,2 Bdrm S,Dirty Departs,,EVANS x4 096A,Hotel,Svc Daily,18/02/2009,SOUCE x2 097,2 Bdrm S,Dirty Departs,,WENCESLAUS x2 097,2 Bdrm S,Dirty

[cfaussie] Re: Remove from cfhttp.fileContent

2009-02-17 Thread karan
Thanks Steve. I got another one: I have defined the encoding in the html header of a page using code : meta http-equiv=content-type content=text/html; charset=utf-8 If I check Page Info in Firefox, it shows the encoding as utf-16LE. How come inspite of setting the encoding manually in the page

[cfaussie] Re: Remove from cfhttp.fileContent

2009-02-17 Thread karan
Thanks Steve. I got another one: I have defined the encoding in the html header of a page using code : meta http-equiv=content-type content=text/html; charset=utf-8 If I check Page Info in Firefox, it shows the encoding as utf-16LE. How come inspite of setting the encoding manually in the page

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread Kevin Pepperman
It may be from the consecutive delimiters (,,) CF treats consecutive delimiters as a single character. On Tue, Feb 17, 2009 at 6:51 PM, SAMARIS Software rai...@ozemail.com.auwrote: The following is an extract from a txt / csv file I import into my sql database 095,2 Bdrm S,Clean

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread ryanhoppitt
Are you 1. importing the CSV to SQL Server via ColdFusion? or 2. generating the CSV with ColdFusion then using DTS tools to import the CSV to SQL Server? If 2, then perhaps the problem is with the DTS tools. Apparently when importing excel or csv, it uses the first 8 rows of your file to

[cfaussie] Re: CF8 bug with CFDOCUMENT

2009-02-17 Thread Matthew
Someone must be running CF8 and can try the code? Anyone? --~--~-~--~~~---~--~~ 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,

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread SAMARIS Software
Hi, No I am simply taking a csv file that has been created by an external application and uploading the data file via a cold fusion page which uploads the file to the server space and then I read the file and import data into the sql server table via traditional cfquery insert. Regards Claude

[cfaussie] Re: CF8 bug with CFDOCUMENT

2009-02-17 Thread ryanhoppitt
I get the same error as you. I noticed that outputting #structKeyList(arguments)# within cfdocumentitem reveals a single key called attributes which appears to be a blank struct. Seems whatever code is behind cfdocumentitem is operating in a whole other scope. Seems fine for output in the

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread Ross Phillips
Hey Claude, Can't say I've come across your problem before but do you know where is the bad casting is occurring? Is it the SQL statement or before? If it is at the SQL are you using cfqueryparam? Cheers, Ross On 18/02/2009, at 1:47 PM, SAMARIS Software wrote: Hi, No I am simply

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread Chris Velevitch
On Wed, Feb 18, 2009 at 11:47, SAMARIS Software rai...@ozemail.com.au wrote: the file to the server space and then I read the file and import data into the sql server table via traditional cfquery insert. Can you show us some code? Chris -- Chris Velevitch Manager - Adobe Platform Users

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread SAMARIS Software
CFQUERY datasource=#ds# username=#un# password=#pw# NAME=daily_housekeeping_report select * from hsk_rpt.csv /CFQUERY cfset unit_number=#ToString(daily_housekeeping_report.unit)# CFQUERY datasource=#ds# username=#un# password=#pw# NAME=insert_daily_hsk_report insert into

[cfaussie] Re: CF8 bug with CFDOCUMENT

2009-02-17 Thread Raymond Camden
Interesting. I know that there is a cfdocument scope inside cfdocumentitem tag. I wonder if that is part of the conflict? Worse comes to worse, you can generate your headers in DDX. On Tue, Feb 17, 2009 at 7:04 PM, ryanhoppitt ryanhopp...@gmail.com wrote: I get the same error as you. I

[cfaussie] Re: CF8 bug with CFDOCUMENT

2009-02-17 Thread Matthew
Thanks Ryan and Ray for the responses. The code worked perfectly fine in CF7. I've just logged the bug with Adobe. By the way: the simple fix is just to create a new local variable in the function and assign the argument variable to the local variable (it's a waste but at least it gets my code

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread Chris Velevitch
It looks your odbc driver is the issue. What does cfdump on daily_housekeeping_report show you? Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au Adobe Platform Users Group, Sydney Feb '09 meeting: Hands On Cairngorm Basics Date: Mon 23rd

[cfaussie] Re: Problems Uploading CSV data into SQL table

2009-02-17 Thread Scott.thornton
Try looping over the .csv !--- Read the file into a variable --- cffile action=READ file=#FORM.CSV_FILENAME# variable=CSV_DATA_FILE cfset CRLF = Chr(13)Chr(10) cfloop index=CSV_DATA_LINE list=#CSV_DATA_FILE#