Re: Comma delimited list
A simple option for you is to load all of your feature codes into a structure then loop through your feature codes list and just pull the feature code descriptions from the struct. On 29/05/2010 12:37 PM, "Bill Hartley" wrote: I am trying to display feature codes from a comma delimited list inside a database. Here is my setup: Table: Listings has a column called FEATURE_CODES and example of the data in this column is "B01,E09,E20,G12,J07" Then I have another table inside the same database called FeatureCodes the data inside this table is arranged FEATURE_CODE FEATURE_DESCRIPTION B01 Sold As Is E09 Frame and Stucco and so on I need to display the feature description from the FeatureCodes table on the display page by reading the feature_codes from the listing table Any Suggestions?? Please!! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334107 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
optimal payments code
Any one have an optimal payments implementation with the current api? I've been using their older one and would like to move to the new version. They don't offer example code for cf. Using cfcs, so bonus for that. Thanks! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334106 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Comma delimited list
On Fri, May 28, 2010 at 7:37 PM, Bill Hartley wrote:
>
> I am trying to display feature codes from a comma delimited list inside a
> database. Here is my setup:
>
> Table: Listings has a column called FEATURE_CODES and example of the data
> in this column is "B01,E09,E20,G12,J07"
>
> Then I have another table inside the same database called FeatureCodes the
> data inside this table is arranged
> FEATURE_CODE FEATURE_DESCRIPTION
> B01 Sold As Is
> E09 Frame and Stucco
> and so on
> I need to display the feature description from the FeatureCodes table on
> the display page by reading the feature_codes from the listing table
Agreed with the previous responses. If it's at all an option, I'd normalize
the table and get rid of the comma-delimited lists.
If you can't do that, another route could be using a query or sub-query with
IN:
assuming variable "codes" is 'B01,E09,E20,G12,J07'...
first you'll want to qualify the list elements with single quotes:
// note that's a single quote
enclosed in double-quotes
SELECT
{ columns }
FROM
{ tablename }
WHERE
feature_code IN ( )
That, of course, assumes you can make two distinct queries (the first would
actually get the value assigned to the variable "codes"). You may be able
to massage it into a subquery and do it all in one swell foop. Something
like:
SELECT
{ columns }
FROM
{ tablename }
WHERE
feature_code IN ( SELECT feature_codes FROM listings WHERE { where
condition here } )
--
Charlie Griefer
http://charlie.griefer.com/
I have failed as much as I have succeeded. But I love my life. I love my
wife. And I wish you my kind of success.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334105
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Comma delimited list
Can you show me a code example? On Fri, May 28, 2010 at 10:37 PM, Bill Hartley wrote: > > I am trying to display feature codes from a comma delimited list inside a > database. Here is my setup: > > Table: Listings has a column called FEATURE_CODES and example of the data > in this column is "B01,E09,E20,G12,J07" > > Then I have another table inside the same database called FeatureCodes the > data inside this table is arranged > FEATURE_CODE FEATURE_DESCRIPTION > B01 Sold As Is > E09 Frame and Stucco > and so on > I need to display the feature description from the FeatureCodes table on > the display page by reading the feature_codes from the listing table > > Any Suggestions?? Please!! > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334104 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Comma delimited list
In the long run - your best option is to create third table that will link listsings to multiple feature codes. This is true for many many reasons. If your looking for a quick solution that doesnt involve changing tables - you could use a sql split function (good ex. http://geekswithblogs.net/AngelEyes/archive/2007/04/12/111504.aspx), this will serve as a psuedo table for what i described above. On Fri, May 28, 2010 at 10:37 PM, Bill Hartley wrote: > > I am trying to display feature codes from a comma delimited list inside a > database. Here is my setup: > > Table: Listings has a column called FEATURE_CODES and example of the data > in this column is "B01,E09,E20,G12,J07" > > Then I have another table inside the same database called FeatureCodes the > data inside this table is arranged > FEATURE_CODE FEATURE_DESCRIPTION > B01 Sold As Is > E09 Frame and Stucco > and so on > I need to display the feature description from the FeatureCodes table on > the display page by reading the feature_codes from the listing table > > Any Suggestions?? Please!! > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Comma delimited list
Break out the comma dilimited list into a cross ref table then you query the tables with an inner join to get the features. -Original Message- From: Bill Hartley Sent: Friday, May 28, 2010 7:37 PM To: cf-talk Subject: Comma delimited list I am trying to display feature codes from a comma delimited list inside a database. Here is my setup: Table: Listings has a column called FEATURE_CODES and example of the data in this column is "B01,E09,E20,G12,J07" Then I have another table inside the same database called FeatureCodes the data inside this table is arranged FEATURE_CODE FEATURE_DESCRIPTION B01 Sold As Is E09 Frame and Stucco and so on I need to display the feature description from the FeatureCodes table on the display page by reading the feature_codes from the listing table Any Suggestions?? Please!! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334102 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Comma delimited list
I am trying to display feature codes from a comma delimited list inside a database. Here is my setup: Table: Listings has a column called FEATURE_CODES and example of the data in this column is "B01,E09,E20,G12,J07" Then I have another table inside the same database called FeatureCodes the data inside this table is arranged FEATURE_CODE FEATURE_DESCRIPTION B01 Sold As Is E09 Frame and Stucco and so on I need to display the feature description from the FeatureCodes table on the display page by reading the feature_codes from the listing table Any Suggestions?? Please!! ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CGI.SERVER_NAME
I just did some tests, and CGI.SERVER_NAME displays whatever URL was used to access the page. So if the IP address is 1.1.1.1, and these three hosts point to 1.1.1.1: x.com, b.com, xb.org, and they all point to the same webpage with this code: it'll output the following: url: http://1.1.1.1 outputs: 1.1.1.1 url: x.com outputs: x.com url: b.com outputs: b.com url: xb.com outputs: xb.com Since you are using curl and you are specifying the IP in the URL, CGI.SERVER_NAME will be 1.1.1.1. Since this is a private IP address, under certain circumstances, this should never leak. For example, it could leak if you have a device (proxy server or load balancer) between the internet and the server, and all requests are being proxied from this device, and the device talks to your server via IP, and not via a hostname, then the internet would see the IP address as CGI.SERVER_NAME Chad Gray wrote: > While going through PCI compliance it appears that CGI.SERVER_NAME can leak > the internal private IP address. > > Does CGI.SERVER_NAME default to the internal IP setup in IIS? > > I have a re-direct in Application.cfm that if the user is on HTTPS to > cflocation them to http://#CGI.SERVER_NAME#/ and this leaks the private IP > 10.1.0.0 when using CURL > > curl -0 -k --head -v -H "Host: "https://1.1.1.1 > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CGI.SERVER_NAME
While going through PCI compliance it appears that CGI.SERVER_NAME can leak the internal private IP address. Does CGI.SERVER_NAME default to the internal IP setup in IIS? I have a re-direct in Application.cfm that if the user is on HTTPS to cflocation them to http://#CGI.SERVER_NAME#/ and this leaks the private IP 10.1.0.0 when using CURL curl -0 -k --head -v -H "Host: "https://1.1.1.1 Could this be DNS setup? Thanks, Chad ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334099 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF regex question [SOT]
>Seems to work beautifully! Thanks! > As long as you don't have any variables/values with "cf" in them. hehehe.. doesn't match. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: RE: CF regex question [SOT]
Seems to work beautifully! Thanks! On May 28, 2010 3:05 PM, "Andy Matthews" wrote: Per the good Jason Dean at www.12robots.com: Tested against these: And the first three match. andy -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Friday, May 28,... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF regex question [SOT]
Per the good Jason Dean at www.12robots.com: Tested against these: And the first three match. andy -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Friday, May 28, 2010 1:39 PM To: cf-talk Subject: CF regex question [SOT] I just ran into a problem with some old code one of team mates did. He used no cfsqltype and according to the docs it's default is CF_SQL_CHAR. So I need to go through the 1321 http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Jrun.exe Memory Usage Keeps Growing
Hi everyone, Thank you for reading this post... In my server's windows task manager, I'm noticing that the jrun.exe process is the biggest and growing. It does not appear to be releasing.. What's the best way to reset this? What is the best way to prevent this from happening and/or why is this happening? This is Coldfusion version 6. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF regex question [SOT]
I just ran into a problem with some old code one of team mates did. He used no cfsqltype and according to the docs it's default is CF_SQL_CHAR. So I need to go through the 1321 http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334094 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing ColdFusion 9 search services, after the fact.
On 5/28/2010 10:53 AM, Dave Watts wrote: > There are all kinds of reasons why services won't run. I would check > the logs in > /jrun4/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/solr/logs. > Thank you! I was looking for those log files. I hadn't dug that deep into the cffusion server yet, I didn't expect the solr service to be part of any of the CF servers actually. Unfortunately, two of the files are empty. Only the stderr file has content. But all that content is labeled "INFO" and when I again tried to restart the Solr service, it again immediately stopped and nothing was added to the stderr file. I got a message from Windows that I don't recall getting before saying "The service was started and immediately stopped. Some services stop if they do not have work to do." or something to that affect. I don't see any useful information in the Windows Event logs either. Just notes that I request the service to start, that the service start and that it ends. all within the same second. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing ColdFusion 9 search services, after the fact.
> That was also my thought when I did not install it. But on that machine > the Solr service will not run. If I start it in the Windows Services > panel, it just immediately stops itself again. On my developer machine, > where I just took the default everything when I installed CF9, Solr > works just fine. When trying to understand this behavior I saw this > description for the ColdFusion 9 Search Server service "Provides support > for the ColdFusion search tags. *You cannot use the ColdFusion search > tags if this process is not running*." Bolding mine. I would test this on your dev machine by turning off the Verity service and rerunning your Solr code. I'll bet it'll still work (and would be interested to learn if it doesn't). > If anybody can give me some other idea why a Solr service will not run, > I would be interested in hearing them. There are all kinds of reasons why services won't run. I would check the logs in /jrun4/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/solr/logs. > I have the Installation DVD, so if they are not on the machine, they > should be there should they not? I would think they'd be on there somewhere, although they might be packed into a larger installer. I don't have the installation DVD - in fact, I haven't had actual installation media for CF in a long time. 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, or on ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing ColdFusion 9 search services, after the fact.
On 5/28/2010 10:21 AM, Dave Watts wrote: > I don't think that's true. Verity and Solr are completely different > services, and the Verity service just runs the normal K2 process - it > doesn't run anything for Solr. > That was also my thought when I did not install it. But on that machine the Solr service will not run. If I start it in the Windows Services panel, it just immediately stops itself again. On my developer machine, where I just took the default everything when I installed CF9, Solr works just fine. When trying to understand this behavior I saw this description for the ColdFusion 9 Search Server service "Provides support for the ColdFusion search tags. *You cannot use the ColdFusion search tags if this process is not running*." Bolding mine. Putting those two pieces together I have come to the tenative conclusion that the Solr Service requires some piece of the Search Server service. If anybody can give me some other idea why a Solr service will not run, I would be interested in hearing them. > I don't know if this will be on your machine or not if you didn't > initially choose it during the install, but on my machine there's a > /jrun4/verity directory, and it contains batch files to install and > uninstall Verity. > I have the Installation DVD, so if they are not on the machine, they should be there should they not? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spreadsheet manipulation - clearing/deleting cell contents
> So it seems the culprit is creating a spreasheet from a > query with SpreadsheetAddRows(). > Rows created by QueryAddRow() although empty, are not > 'blank' in Excel's opinion. Yep. It seems to set the cell values to "", rather than the special BLANK cell type (unfortunately). ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Installing ColdFusion 9 search services, after the fact.
> When I first installed CF9 on our Windows 2003, I only chose the Solr > search services, thinking that the "ColdFusion 9 search services" was > only for Verity, which we did not want. Turns out, as best as I can > tell. ColdFusion 9 Solr Services will not work without the ColdFusin 9 > Search Services. I don't think that's true. Verity and Solr are completely different services, and the Verity service just runs the normal K2 process - it doesn't run anything for Solr. > Can anybody quickly point me to documentation on how I can just install > this ColdFusion 9 Search Service? I'm hoping I do not have to do a full > CF9 install again. I don't know if this will be on your machine or not if you didn't initially choose it during the install, but on my machine there's a /jrun4/verity directory, and it contains batch files to install and uninstall Verity. 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, or onsi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Installing ColdFusion 9 search services, after the fact.
When I first installed CF9 on our Windows 2003, I only chose the Solr search services, thinking that the "ColdFusion 9 search services" was only for Verity, which we did not want. Turns out, as best as I can tell. ColdFusion 9 Solr Services will not work without the ColdFusin 9 Search Services. Can anybody quickly point me to documentation on how I can just install this ColdFusion 9 Search Service? I'm hoping I do not have to do a full CF9 install again. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334088 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spreadsheet manipulation - clearing/deleting cell contents
So it seems the culprit is creating a spreasheet from a query with
SpreadsheetAddRows().
Rows created by QueryAddRow() although empty, are not 'blank' in Excel's
opinion.
In this case, I needed some blank spreadsheet rows to inject long overflowing
strings, inbetween the rows of source query data.
I would have used SpreadsheetAddRows() to loop through the whole thing, except
that some fields need to contain comma-delimited strings - adding unwanted
columns in the process. Another workaround in this case would be to find a way
to escape the commas.
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Friday, May 28, 2010 10:03 AM
To: cf-talk
Subject: RE: Spreadsheet manipulation - clearing/deleting cell contents
If you want A1 to overflow into B1, then do not set anything for B1. For
example, notice how this code sets a value for A1 and C1, but skips B1? As long
as you do not touch the adjacent cell (B1), it will be considered blank. So any
text to the left of it will overflow into that cell.
cfSheet = SpreadsheetNew("foo");
SpreadsheetSetCellValue(cfSheet, 'this text should overflow', 1, 1);
SpreadsheetSetCellValue(cfSheet, 'short text', 1, 3);
saveToFile = ExpandPath("test-blank-cell.xls");
SpreadsheetWrite(cfsheet, saveToFile, true);
WriteOutput("Saved file: "& saveToFile &"");
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334087
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: pdf metadata
> No, pdfutils uses DDX via cfpdf. Of course, in CF9 you > don't need that. Yes, you are right. I skimmed and was looking at the xmp metadata. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334086 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spreadsheet manipulation - clearing/deleting cell contents
If you want A1 to overflow into B1, then do not set anything for B1. For
example, notice how this code sets a value for A1 and C1, but skips B1? As long
as you do not touch the adjacent cell (B1), it will be considered blank. So any
text to the left of it will overflow into that cell.
cfSheet = SpreadsheetNew("foo");
SpreadsheetSetCellValue(cfSheet, 'this text should overflow', 1, 1);
SpreadsheetSetCellValue(cfSheet, 'short text', 1, 3);
saveToFile = ExpandPath("test-blank-cell.xls");
SpreadsheetWrite(cfsheet, saveToFile, true);
WriteOutput("Saved file: "& saveToFile &"");
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334085
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: pdf metadata
No, pdfutils uses DDX via cfpdf. Of course, in CF9 you don't need that. On Fri, May 28, 2010 at 1:13 PM, Leigh wrote: > > The FAQ's say OpenBD comes with pdfbox (as well as iText 2.x). Between the > two of them you should be able to work with the metadata. > > http://www.pdfbox.org/userguide/metadata.html > http://www.docjar.com/docs/api/com/lowagie/text/Document.html > > You might also see if the pdfutils.cfc works with OpenBD. I believe it has a > function for extracting metadata using iText > http://pdfutils.riaforge.org/ > > > > > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spreadsheet manipulation - clearing/deleting cell contents
I may not be following you on this Leigh; if I put a long string in A1 using SpreadsheetSetCellValue and nothing in B1, A1 is still clipped...? -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, May 28, 2010 2:32 AM To: cf-talk Subject: RE: Spreadsheet manipulation - clearing/deleting cell contents Just a follow up. Azadi pointed out you can get around the problem by setting the _non-blank_ cell values individually, with SpreadsheetSetCellValue(). That has the benefit of being documented at least. Still giving serious thought to the bug/enhancement request though .. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334083 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: pdf metadata
The FAQ's say OpenBD comes with pdfbox (as well as iText 2.x). Between the two of them you should be able to work with the metadata. http://www.pdfbox.org/userguide/metadata.html http://www.docjar.com/docs/api/com/lowagie/text/Document.html You might also see if the pdfutils.cfc works with OpenBD. I believe it has a function for extracting metadata using iText http://pdfutils.riaforge.org/ ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
pdf metadata
Hi, Is there some easy way to read (and possibly manipulate) metadata in a pdf-file from ColdFusion. The file was not created through cf_document, but rather Adobe Illustrator. I am on OpenBD, so engine-agnostic methods are of highest interest! Thanks, Hugo -- Hugo Ahlenius - Hugo AhleniusE-Mail: hugo.ahlenius(at)nordpil.com Phone:+46 75 7575284 Nordpil Fax: +46 8 6747020 http://nordpil.com Mobile: +46 733 467111 Skype: callto:hugo.ahlenius vCard:http://nordpil.com/hugoahlenius.vcf - ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Spreadsheet manipulation - clearing/deleting cell contents
Just a follow up. Azadi pointed out you can get around the problem by setting the _non-blank_ cell values individually, with SpreadsheetSetCellValue(). That has the benefit of being documented at least. Still giving serious thought to the bug/enhancement request though .. -Leigh ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Capturing a Flash Site Screen Shot
> Have you tested via the commandline first and made sure that that > works? > Maybe try the .dll version and use cfobject? > > Also note the implementation tips: > http://www.websitescreenshots.com/Usage.aspx#cltips > > I remember having problems with cfexecute myself in the past and I > seem to remember that I overcame them by using a substitute tag, I > think it was this one: > http://www.cftagstore.com/tags/cfxexec.cfm > > Stefan > > > > > On 12 Nov 2009, at 04:46, Richard Steele wrote: > > > > > Thanks. I've installed it on our Windows 2003 Server. However it > doesn't seem to work in a cfexecute. What might I be missing here? > > > > > > arguments= "/url 'http://www.yahoo.com'" /> > > > > /url http://jibuas.com /out #ExpandPath( './capture/#strSmallFile#.jpg' )# /quality 100 /width 200 /height 150 /encoder jpg ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334079 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
