Hello, I have a question about CFspreadsheet
I'm reading a spreadsheet and inserting the data into a SQL server
DBeverything works fine unless 1 of my columns in the spreadsheet is blank.
I'm getting the following error:
Element PHONE is undefined in EXCELQUERYBYNAME.
I tried the
Hello list,
Long time (years) no post.
I am trying to read from a spreadsheet that is loaded up onto the server and
then insert the information into the database. I have three column headers
called Code, Barcode and ResortID. Code and Barcode have values and ResortID is
empty. The reason
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
We use cfspreadsheet to upload Excel spreadsheet into database, but having
an issue with reading dates. cfspreadsheet only reads last 2 digits of the
year, e.g. the date in the Excel file is 2/2/1999, the cfspreadsheet reads it
as 2/2/99. Below is my code:
cfset
the last
attribute to the right column number.
.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Hong Chen [mailto:ho...@cbmiweb.com]
Sent: Tuesday, February 07, 2012 2:42 PM
To: cf-talk
Subject: cfspreadsheet issue when reads dates from
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
21 matches
Mail list logo