I'm seeing a missing # sign after Form.Request
-Original Message-
From: Bruce Sorge [mailto:sor...@gmail.com]
Sent: Friday, August 10, 2012 2:28 PM
To: cf-talk
Subject: CFspreadsheet issue
Hello list,
Long time (years) no post.
I am trying to read from a spreadsheet that is loaded
Yeah I picked up on that and still the same issue.
On Aug 10, 2012, at 1:00 PM, Sandra Clark sclarkli...@gmail.com wrote:
I'm seeing a missing # sign after Form.Request
~|
Order the Adobe Coldfusion Anthology now!
Did you pick up the missing commas between the cfparams? They need commas,
just like the field list.
That would give a mismatched column count error.
-Cameron
On Fri, Aug 10, 2012 at 3:05 PM, Bruce Sorge sor...@gmail.com wrote:
Yeah I picked up on that and still the same issue.
You do know your query names don't match up..
Your reading the spreadsheet into a query object called DealsDSN and
looping over an object called MahDSN
On Fri, Aug 10, 2012 at 2:27 PM, Bruce Sorge sor...@gmail.com wrote:
Hello list,
Long time (years) no post.
I am trying to read from a
Thanks Cameron. I have been out of the game so long I am making noob mistakes,
LOL.
On Aug 10, 2012, at 1:33 PM, Cameron Childress camer...@gmail.com wrote:
Did you pick up the missing commas between the cfparams? They need commas,
just like the field list.
That would give a mismatched
The only thing I might add is that if you are on CF9, you might consider
using the new in-memory virtual file system (VFS) to write your new
spreadsheet and read it back in (might improve the performance if the
spreadsheet is large).
-Carl
On 2/8/2012 8:34 AM, Hong Chen wrote:
I used
it. Thanks.
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Tuesday, February 07, 2012 9:11 PM
To: cf-talk
Subject: Re: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
If I manually format the column, it still reads yy.
I am betting Excel is still
It was successful, but hope there is a simple way to do it.
Unfortunately, I think that is as simple as it gets. AFAIK, CF does not let you
specify the formatting of query values. It always uses the cell format
information.
-Lei
I was thinking there were extra read and write action... Anyway my problem
resolved now. Thanks for your help.
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Wednesday, February 08, 2012 11:56 AM
To: cf-talk
Subject: Re: [5] RE: cfspreadsheet issue when reads dates
If you are on CF9, you can try using SpreadsheetFormatColumns() to format it
like you want.
something like this (I think) after your cfsrpeeadsheet tag.
cfset spreadSheetFormatColumn(qryResult, {dataformat=mm/dd/yyy}, 1) /
Im assuming DOB is the first column. If that isnt the case, change the
something like this (I think) after your cfsrpeeadsheet tag.
cfset spreadSheetFormatColumn(qryResult, {dataformat=mm/dd/yyy}, 1) /
Yep, essentially. But it needs to be applied before reading the sheet into a
query.
-Leig
Not sure why I was thinking after.
.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Tuesday, February 07, 2012 5:42 PM
To: cf-talk
Subject: Re: cfspreadsheet issue when reads dates
Hartsfield [mailto:bo...@acoderslife.com]
Sent: Tuesday, February 07, 2012 5:59 PM
To: cf-talk
Subject: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
Not sure why I was thinking after.
.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original
: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
I also have a download function, in there I have formatted the column with
spreadSheetFormatColumn. If I use the downloaded file to upload, it reads 4
digits year. But if I create a new spreadsheet to upload. It only reads the
last 2
Yeah, the solution is the same. You have to apply a format.
I also have a download function, in there I have formatted the column with
spreadSheetFormatColumn. If I use the downloaded file to upload, it reads
4 digits year.
But if I create a new spreadsheet to upload.
It only reads the
If I manually format the column, it still reads yy. How can I
programmatically format it before it reads the spreadsheet?
Thanks,
Hong
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Tuesday, February 07, 2012 8:20 PM
To: cf-talk
Subject: Re: [5] RE: cfspreadsheet
If I manually format the column, it still reads yy.
I am betting Excel is still registering the cell format as m/d/yy. Try using
m/d/;@
How can I programmatically format it before it reads the spreadsheet?
I do not think you can convert a spreadsheet object into a query directly. If
It worked after I applied date format for the column manually, will try to
use SpreadSheetRead tomorrow. Thanks.
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Tuesday, February 07, 2012 9:11 PM
To: cf-talk
Subject: Re: [5] RE: cfspreadsheet issue when reads dates
18 matches
Mail list logo