Re: Comma delimited list

2010-05-28 Thread Kevan Stannard
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 in

optimal payments code

2010-05-28 Thread Matthew P. Smith
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! ~|

Re: Comma delimited list

2010-05-28 Thread Charlie Griefer
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 hav

Re: Comma delimited list

2010-05-28 Thread Bill Hartley
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 "B

Re: Comma delimited list

2010-05-28 Thread Charlie Stell
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/Ang

RE: Comma delimited list

2010-05-28 Thread William Seiter
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 c

Comma delimited list

2010-05-28 Thread Bill Hartley
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 da

Re: CGI.SERVER_NAME

2010-05-28 Thread rex
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

CGI.SERVER_NAME

2010-05-28 Thread Chad Gray
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

Re: CF regex question [SOT]

2010-05-28 Thread Will Tomlinson
>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-Mi

Re: RE: CF regex question [SOT]

2010-05-28 Thread Greg Morphis
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,.

RE: CF regex question [SOT]

2010-05-28 Thread Andy Matthews
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

Jrun.exe Memory Usage Keeps Growing

2010-05-28 Thread patrick buch
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 th

CF regex question [SOT]

2010-05-28 Thread Greg Morphis
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.

Re: Installing ColdFusion 9 search services, after the fact.

2010-05-28 Thread Ian Skinner
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 cffusio

Re: Installing ColdFusion 9 search services, after the fact.

2010-05-28 Thread Dave Watts
> 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 > work

Re: Installing ColdFusion 9 search services, after the fact.

2010-05-28 Thread Ian Skinner
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 t

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Leigh
> 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).

Re: Installing ColdFusion 9 search services, after the fact.

2010-05-28 Thread Dave Watts
> 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

Installing ColdFusion 9 search services, after the fact.

2010-05-28 Thread Ian Skinner
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 Servic

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Jon Sala
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 d

Re: pdf metadata

2010-05-28 Thread Leigh
> 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-

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Leigh
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. cfSh

Re: pdf metadata

2010-05-28 Thread Raymond Camden
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/

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Jon Sala
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 manipulat

Re: pdf metadata

2010-05-28 Thread Leigh
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 Ope

pdf metadata

2010-05-28 Thread Hugo Ahlenius
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 ---

RE: Spreadsheet manipulation - clearing/deleting cell contents

2010-05-28 Thread Leigh
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 ~~

Re: Capturing a Flash Site Screen Shot

2010-05-28 Thread Jibu S
> 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 > see