RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
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 from spreadsheet > 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 not, use SpreadSheetRead to load the spreadsheet into memory. Format the column. Then write it back to disk. -Lei ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
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 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 not, use SpreadSheetRead to load the spreadsheet into memory. Format the column. Then write it back to disk. -Lei ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: contentsubtype issue
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 wrote: > > 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 > errors out. I'm guessing this should be seeing it as XML and not XM? I > don't exactly when the last time was that this worked but the hotfix here > http://kb2.adobe.com/cps/918/cpsid_91836.html was applied a short time > ago. I suspect this might be related but honestly I'm just guessing. Has > anyone out there run into this before or can somebody shed some light here > for me please? > > TIA > > > Bob Imperial043 Macnider Hall, CB > 7005 > Application SpecialistUNC Chapel Hill, NC 27599 > > Department of Medicine (919) > 843-6151 > DOM-IS Helpline: 919.843.2331 > Support: http://medicine.med.unc.edu/dom-is-support > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349817 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
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 issue when reads dates from spreadsheet 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 last 2 digits of year. >From what I have read on the POI lists, if you do not *explicitly* set a format for the cells (either manually or programatically with CF), Excel assigns its default. For dates it is "m/d/yy". That pattern, is what CF uses to format the query values. So with your downloaded file, it uses whatever format you applied. Whereas with your brand new worksheet, there is no format, so it is falls back on the default "m/d/yy". -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349816 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
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 last 2 digits of year. >From what I have read on the POI lists, if you do not *explicitly* set a >format for the cells (either manually or programatically with CF), Excel >assigns its default. For dates it is "m/d/yy". That pattern, is what CF uses >to format the query values. So with your downloaded file, it uses whatever >format you applied. Whereas with your brand new worksheet, there is no format, >so it is falls back on the default "m/d/yy". -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
contentsubtype issue
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 errors out. I'm guessing this should be seeing it as XML and not XM? I don't exactly when the last time was that this worked but the hotfix here http://kb2.adobe.com/cps/918/cpsid_91836.html was applied a short time ago. I suspect this might be related but honestly I'm just guessing. Has anyone out there run into this before or can somebody shed some light here for me please? TIA Bob Imperial043 Macnider Hall, CB 7005 Application SpecialistUNC Chapel Hill, NC 27599 Department of Medicine (919) 843-6151 DOM-IS Helpline: 919.843.2331 Support: http://medicine.med.unc.edu/dom-is-support ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [5] RE: cfspreadsheet issue when reads dates from spreadsheet
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: [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 digits of year. -Original Message- From: Bobby 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 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 from spreadsheet > something like this (I think) after your cfsrpeeadsheet tag. > Yep, essentially. But it needs to be applied before reading the sheet into a query. -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: [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 digits of year. -Original Message- From: Bobby 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 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 from spreadsheet > something like this (I think) after your cfsrpeeadsheet tag. > Yep, essentially. But it needs to be applied before reading the sheet into a query. -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfspreadsheet issue when reads dates from spreadsheet
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 from spreadsheet > something like this (I think) after your cfsrpeeadsheet tag. > Yep, essentially. But it needs to be applied before reading the sheet into a query. -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349811 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SEO Redirection
Good point on that. Thanks for the suggestion. Sent from my iPad On Feb 7, 2012, at 4:41 PM, "Bobby Hartsfield" 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 > would perform a little better. You would have to compare to see. In either > case, I think your use of lcase() is arbitrary. > > listfirst(cgi.server_name), '.')> > > > .:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > > -Original Message- > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: Tuesday, February 07, 2012 5:26 PM > To: cf-talk > Subject: Re: SEO Redirection > > >> >> value="http://#subDomain#.#appdatasource#.com#thePage#";> >> > > 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 > there's really no reason to do this the way you're doing it. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfspreadsheet issue when reads dates from spreadsheet
> something like this (I think) after your cfsrpeeadsheet tag. > Yep, essentially. But it needs to be applied before reading the sheet into a query. -Leig ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SEO Redirection
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. .:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Tuesday, February 07, 2012 5:26 PM To: cf-talk Subject: Re: SEO Redirection > > http://#subDomain#.#appdatasource#.com#thePage#";> > 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 there's really no reason to do this the way you're doing it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349808 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfspreadsheet issue when reads dates from spreadsheet
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. Im assuming DOB is the first column. If that isnt the case, change 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 spreadsheet We use to upload Excel spreadsheet into database, but having an issue with reading dates. only reads last 2 digits of the year, e.g. the date in the Excel file is 2/2/1999, the reads it as 2/2/99. Below is my code: The query dumped out like this: query DOB NAME 1 2/2/99 John Anyone can help? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SEO Redirection
> > value="http://#subDomain#.#appdatasource#.com#thePage#";> > 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 there's really no reason to do this the way you're doing it. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SEO Redirection
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 instances, some were all lower case, and others had a trailing bit on the end to make it look like a static page. This created up to 4 combinations of URL that all displayed the exact same set of data, not to mention the fact of the "www" vs. non "www" issue. I implemented a canonical redirect to make sure all pages went to the properly formatted (all lower case with static page append at the end) URL using a permanently moved redirection header in CF. This all seems to be working correctly, but I have noticed that the site performance is suffering, and some of the requests that should be redirected take longer than the should to actually redirect. I am using FR to monitor the requests, and this is why I know that some of them seem to be taking to long. In theory, they should only take a few milliseconds to redirect, unless I am missing something. Each cf based redirect is followed by a cfexit tag, so the request should end right there with the message to the browser. All of the redirect logic is in a single page. I have included a sample code snippet below. http://#subDomain#.#appdatasource#.com#thePage#";> Any ideas on how to better optimize this solution for global implementation, or whta may be causing the performance lag. Thanks, Brian Cain ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfspreadsheet issue when reads dates from spreadsheet
We use to upload Excel spreadsheet into database, but having an issue with reading dates. only reads last 2 digits of the year, e.g. the date in the Excel file is 2/2/1999, the reads it as 2/2/99. Below is my code: The query dumped out like this: query DOB NAME 1 2/2/99 John Anyone can help? Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Document Service Error (was deanlaw)
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 > the info page in the admin and with cfdocument. I came across a blog > post at http://blog.maestropublishing. > com/adobe-coldfusion-9-on-mac-lion-fix-for-hangin which fixed my > problem with the info page, but I am still having a problem with > cfdocument. In looking at the server logs, I am getting a ""Unable to > initialize Document service: java.lang.NoSuchFieldError: java3DTested" > error on startup. Does anyone know how to correct this or even where I > should be looking? > > Thanks, > > Dean ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm