Sorry, I realized that my original post had an ambiguous subject line. Has
anyone come across this before? Do I need to reinstall (which I do not want to
do) or is there something else that I should be looking for?
Thanks
I'm running CF9.01 on OSX Lion 64 bit. I've had problems displaying
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
Hello group,
I am working with an SEO person on making some refinements to our sites. We
get over 1.5 million pages views/mo. My SEO guy noticed that there were
several valid ways to access a detail or results listing page through similar
combinations of the URL. Some had upper case
cfheader statuscode=301 statustext=Moved permanently
cfheader name=Location
value=http://#subDomain#.#appdatasource#.com#thePage#;
cfexit
You could replace these three lines with a single CFLOCATION tag. I'm
not sure if that's what's causing your performance problems, but
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
I think all of those lcase() and LEFT() calls are unnecessary as well.
lists aren't known for their performance but in this case, I'd think this
would perform a little better. You would have to compare to see. In either
case, I think your use of lcase() is arbitrary.
cfif
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
Good point on that. Thanks for the suggestion.
Sent from my iPad
On Feb 7, 2012, at 4:41 PM, Bobby Hartsfield bo...@acoderslife.com wrote:
I think all of those lcase() and LEFT() calls are unnecessary as well.
lists aren't known for their performance but in this case, I'd think this
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
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 digits of year.
-Original Message-
From: Bobby
Sounds like the same solution in both cases unless I'm missing something.
.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Hong Chen [mailto:ho...@cbmiweb.com]
Sent: Tuesday, February 07, 2012 6:47 PM
To: cf-talk
Subject: RE:
Hoping somebody here has run into this or can shed some light on a issue I just
encountered with a upload tool that's been working without fail for the longest
time; that is until last week. It looks like CF is seeing the contentSubType on
a pdf form that gets uploaded as XM and it uploads but
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
it could be something to do with commons-fileupload-1.2.jar which was
updated in that hotfix.
you could try rolling this back to previous version and see if that helps.
On Wed, Feb 8, 2012 at 1:12 AM, Imperial, Bob bob_imper...@med.unc.eduwrote:
Hoping somebody here has run into this or can
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
17 matches
Mail list logo