Re: "Pivoting" a CFLOOP'ed HTML table

2008-11-07 Thread Mike Chabot
MySQL doesn't have any built-in pivot support. You could add this in
to MySQL, but it is probably easier to write the equivalent
functionality in CF.

The first thing that comes to mind is to loop over the result set once
to build up an alternate data structure, such as a 2-dimensional
array, then loop over that new data structure to create the output. Or
maybe use the array syntax of cfquery and instead of looping over a
query you loop over listlen(query.columnlist) and reference the
datapoints like query['firstname'][1] query['firstname'][2], for
the top table row.

-Mike Chabot

On Fri, Nov 7, 2008 at 10:36 PM, Pete Ruckelshaus
<[EMAIL PROTECTED]> wrote:
> Any idea how to do that in MySQL 5?
>
> On Fri, Nov 7, 2008 at 9:00 PM, Mike Chabot <[EMAIL PROTECTED]> wrote:
>> You can run a pivot command in your database query before sending the
>> results to ColdFusion so that CF receives the data in a format that
>> can be easily looped over.
>>
>> -Mike Chabot
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314986
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Apache not working

2008-11-07 Thread James Holmes
Do you have other websites set up on the same server?

Does an http request (as opposed to an https request) work?

Does the default Apache page show up if you request
http://www.mysite.mobi/ and https://www.mysite.mobi/?

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2008/11/8 Fawzi Amadu <[EMAIL PROTECTED]>:
> I have setup apache along with Coldfusion on a dedicates server. My problem 
> is that when I try to access Coldfusion Administration (url: 
> https://www.mysite.mobi/CFIDE/administrator/index.cfm, I get an error saying 
> that apache coud not reliable determine the server fully qualified domain 
> name.
>
> What is it that I am doing wrong? TIA
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314985
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: "Pivoting" a CFLOOP'ed HTML table

2008-11-07 Thread Pete Ruckelshaus
Any idea how to do that in MySQL 5?

On Fri, Nov 7, 2008 at 9:00 PM, Mike Chabot <[EMAIL PROTECTED]> wrote:
> You can run a pivot command in your database query before sending the
> results to ColdFusion so that CF receives the data in a format that
> can be easily looped over.
>
> -Mike Chabot
>

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314984
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: "Pivoting" a CFLOOP'ed HTML table

2008-11-07 Thread Mike Chabot
You can run a pivot command in your database query before sending the
results to ColdFusion so that CF receives the data in a format that
can be easily looped over.

-Mike Chabot

On Fri, Nov 7, 2008 at 5:53 PM, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
> I'm stumped.
>
> I need to create a table from a resultset, but the headers, rather
> than being along the top axis, need to be on the left side...sort of
> like this http://www.bilenky.com/geometry.html  So, I can't really use
> cfoutput to write each table row out.  Any ideas how I might
> accomplish this?
>
> Thnaks
>
> Pete
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314983
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JBoss / CF8 installation/configuration guide?

2008-11-07 Thread Dan LeGate
Okay, so I'm answering most of my own questions, and coming up with 
more.  I found:

http://www.adobe.com/products/coldfusion/pdfs/cf8_systemsupportmatrix.pdf

which is a more updated list of supported versions/platforms, etc. so I 
got that answer.

Now I'm running into a problem where after installing CF and expanding 
my cfusion.war file, there is no application.xml to edit as instructed 
in the docs.

Anyone seen this happen?

Dan

Dan LeGate wrote:
> Just a quick follow-up, I noticed this site:
>
> http://livedocs.adobe.com/coldfusion/8/htmldocs/installj2ee_15.html
>
> says JBoss 4.0.5 is supported, however the latest stable release appears 
> to be 4.2.3.GA.
>
> Should we go with 4.0.5, or get the latest and greatest of version 4?
>
> Thanks again,
>
> Dan
>
> Dan LeGate wrote:
>   
>> Is there a JBoss & CF8 install / configuration guide?  Or any good blogs 
>> on the subject of properly configuring/tuning this kind of environment?
>>
>> We're about to bring this up in a test environment, and would like to 
>> know the *proper* way to set this up, and not just follow all defaults.
>>
>> Any advice is appreciated.
>>
>> Thanks!
>>
>> Dan
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314982
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Script to move email to from undelivr to spool?

2008-11-07 Thread Nick Gleason
Thanks bobby!

Nick




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314981
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Charles Heizer
Thanks, I was using the CFHTTPPARAM to put a file which is on the local file 
system to the WEBDAV host. This right now is not a web form just a simple cfm 
page.

Thanks,
- Charles

> > I seem to be getting closer. I'm now getting a "409 Conflict". I 
> really dont know much about the WEBDAV protocol. Does anyone know what 
> a 409 Conflict is.
> 
> It means that there's some reason why WebDAV can't accept the file.
> Maybe it's older than the one already there. Maybe you're providing
> incorrect parameters. Is there a reason why the name attribute of 
> your
> CFHTTPPARAM contains the value "base.xml"? Typically, this contains
> the name of the formfield that contains the file the server's
> expecting to receive.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more 
information! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314980
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Best Open Source Message Board?

2008-11-07 Thread Nitai @ SixSigns
Thank you for letting me know. I fixed the issue.

Kind Regards,
Nitai

On Nov 8, 2008, at 12:19 AM, Bobby Hartsfield wrote:

> Tried to check it out but got this...
>
> http://forums.sixsigns.com/
>
> HTTP Status 500 -
>
> type Exception report
>
> message
>
> description The server encountered an internal error () that  
> prevented it
> from fulfilling this request.
>
> exception
>
> javax.servlet.ServletException: Servlet execution threw an exception
>
> root cause
>
> java.lang.OutOfMemoryError: Java heap space
>
> note The full stack trace of the root cause is available in the Apache
> Tomcat/6.0.18 logs.
>
>
> Would love to see it.
>
> ..:.:.:.:.:.:.:.:.:.:.
> Bobby Hartsfield
> http://acoderslife.com
> http://cf4em.com
>
>
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 05, 2008 12:11 PM
> To: cf-talk
> Subject: Re: Best Open Source Message Board?
>
> If it works in Adobe CF, I think it's fine. (Not that I'm the final  
> say of
> course.)
>
> On Wed, Nov 5, 2008 at 10:56 AM, Nitai @ SixSigns <[EMAIL PROTECTED]>
> wrote:
>> Hi Ray
>>
>> Thought about it, but then our products are based on OpenBD. If it is
>> ok, of course we would like to list it there as well.
>>
>> Kind Regards,
>> Nitai
>>
>> On Nov 5, 2008, at 5:49 PM, Raymond Camden wrote:
>>
>>> You should post this to Riaforge. You don't have to host there. You
>>> can use RIAForge simply as a way to list your project.
>>>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314979
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Best Open Source Message Board?

2008-11-07 Thread Bobby Hartsfield
Tried to check it out but got this...

http://forums.sixsigns.com/

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it
from fulfilling this request.

exception

javax.servlet.ServletException: Servlet execution threw an exception

root cause

java.lang.OutOfMemoryError: Java heap space

note The full stack trace of the root cause is available in the Apache
Tomcat/6.0.18 logs.


Would love to see it.

..:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 05, 2008 12:11 PM
To: cf-talk
Subject: Re: Best Open Source Message Board?

If it works in Adobe CF, I think it's fine. (Not that I'm the final say of
course.)

On Wed, Nov 5, 2008 at 10:56 AM, Nitai @ SixSigns <[EMAIL PROTECTED]>
wrote:
> Hi Ray
>
> Thought about it, but then our products are based on OpenBD. If it is 
> ok, of course we would like to list it there as well.
>
> Kind Regards,
> Nitai
>
> On Nov 5, 2008, at 5:49 PM, Raymond Camden wrote:
>
>> You should post this to Riaforge. You don't have to host there. You 
>> can use RIAForge simply as a way to list your project.
>>



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314978
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Script to move email to from undelivr to spool?

2008-11-07 Thread Bobby Hartsfield
Really? No cfexecute solutions? tsk tsk



Just setup a scheduled task to hit a page with that on it as often as you
need.

Of course... you are going to begin to collect emails that CF just can't
send for whatever reason and will want to clean it out periodically.

I can think of a few ways to handle it.

One would be to loop the contents of undelivr into a database with a
timestamp or a count to keep track of when or how many times it has been
moved back to the spool in an attempt to send it.

Delete the files after so many attempts (and the records)

And again, have the whole process triggered by a scheduled task.

Not sure if Andy's "Undelivrnator" handles it that way but I plan to find
out since we need to do something like this at work soon. :-)

..:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: sachin chawla [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 05, 2008 8:02 AM
To: cf-talk
Subject: Re: Script to move email to from undelivr to spool?

Hi Nick try this



#myDirectory.RecordCount#








and add a schedular in the cold fusion administrator. Still apart from this
we have another alternative of using Directory watcher Events, which do not
need a schedular, they are invoked automatically when a new file comes to
the undeliver folder. 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314977
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


"Pivoting" a CFLOOP'ed HTML table

2008-11-07 Thread Pete Ruckelshaus
I'm stumped.

I need to create a table from a resultset, but the headers, rather
than being along the top axis, need to be on the left side...sort of
like this http://www.bilenky.com/geometry.html  So, I can't really use
cfoutput to write each table row out.  Any ideas how I might
accomplish this?

Thnaks

Pete

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314976
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Dave Watts
> I seem to be getting closer. I'm now getting a "409 Conflict". I really dont 
> know much about the WEBDAV protocol. Does anyone know what a 409 Conflict is.

It means that there's some reason why WebDAV can't accept the file.
Maybe it's older than the one already there. Maybe you're providing
incorrect parameters. Is there a reason why the name attribute of your
CFHTTPPARAM contains the value "base.xml"? Typically, this contains
the name of the formfield that contains the file the server's
expecting to receive.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314975
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Apache not working

2008-11-07 Thread Fawzi Amadu
I have setup apache along with Coldfusion on a dedicates server. My problem is 
that when I try to access Coldfusion Administration (url: 
https://www.mysite.mobi/CFIDE/administrator/index.cfm, I get an error saying 
that apache coud not reliable determine the server fully qualified domain name.

What is it that I am doing wrong? TIA 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314974
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Improve SQL for Retrieving The Next Similar Record

2008-11-07 Thread Dawson, Michael
My goal:

I am trying to retrieve the "next" record based on the date from a given
record.  That part is easy enough.  However, part of the criteria is
that the "next" record must match as far as nullability.

In other words, if the archivedDate in my "known" record IS NULL, then I
want to look for the "next" record where archivedDate is also NULL.

Conversely, if archivedDate in my "known" record IS NOT NULL, then I
want to look for the "next" record where archivedDate is any date value.

The SQL below works perfectly, but I'm not convinced it is the best
solution.  Would anyone have a better solution to this problem that they
would be willing to share?

SELECT TOP 1
a.alertId
FROM
Alerts a
INNER JOIN AlertParticipants ap
ON a.alertId = ap.alertId
WHERE
ap.colleagueId = '094'
AND
CASE
WHEN a.archivedDate IS NULL THEN 'Active'
ELSE 'Archived'
END = (SELECT
   CASE
   WHEN archivedDate IS NULL THEN 'Active'
   ELSE 'Archived' END
   FROM
   Alerts
   WHERE
   alertId = 198)
AND
a.updatedDate < (SELECT
 updatedDate
 FROM
 Alerts
 WHERE
 alertId = 198)
ORDER BY
updatedDate DESC


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314973
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JBoss / CF8 installation/configuration guide?

2008-11-07 Thread Dan LeGate
Just a quick follow-up, I noticed this site:

http://livedocs.adobe.com/coldfusion/8/htmldocs/installj2ee_15.html

says JBoss 4.0.5 is supported, however the latest stable release appears 
to be 4.2.3.GA.

Should we go with 4.0.5, or get the latest and greatest of version 4?

Thanks again,

Dan

Dan LeGate wrote:
> Is there a JBoss & CF8 install / configuration guide?  Or any good blogs 
> on the subject of properly configuring/tuning this kind of environment?
>
> We're about to bring this up in a test environment, and would like to 
> know the *proper* way to set this up, and not just follow all defaults.
>
> Any advice is appreciated.
>
> Thanks!
>
> Dan
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314972
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Subscribe

2008-11-07 Thread Alonso Viela
-- 
_
Alonso Vilela
[EMAIL PROTECTED]


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314971
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


JBoss / CF8 installation/configuration guide?

2008-11-07 Thread Dan LeGate
Is there a JBoss & CF8 install / configuration guide?  Or any good blogs 
on the subject of properly configuring/tuning this kind of environment?

We're about to bring this up in a test environment, and would like to 
know the *proper* way to set this up, and not just follow all defaults.

Any advice is appreciated.

Thanks!

Dan

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314970
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Charles Heizer
I seem to be getting closer. I'm now getting a "409 Conflict". I really dont 
know much about the WEBDAV protocol. Does anyone know what a 409 Conflict is.

Thanks


>I tried it with http instead and no error, but it also did not put the file.
>
>Any ideas?
>
>>http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=843 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314969
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Charles Heizer
I tried it with http instead and no error, but it also did not put the file.

Any ideas?

>You are most likely not doing anything wrong. cfhttp request to https
>are a real pain!!! Coldfusion is most likely not reading your SSL cert
>correctly and the error sucks!
>
>If you can make a call using http and that works, then it's the ssl cert.
>
>Try this link for information on how to resolve it but it is still a
>pain in the ass!
>
>http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=843 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314968
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Dave Watts
> You are most likely not doing anything wrong. cfhttp request to https
> are a real pain!!! Coldfusion is most likely not reading your SSL cert
> correctly and the error sucks!

Well, technically, it doesn't have to do with CF not reading the cert
correctly. For a certificate to be accepted, from CF or from a
browser, there has to be a corresponding trusted root certificate.
Each browser comes installed with a relatively large set of public
trusted root certificates from Verisign, Thawte and other vendors. CF
does not come with a large set of trusted root certificates, since
it's not a browser, and you have to install the appropriate trusted
root certificate yourself.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314967
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Dave Watts
>> Can you check your web server's log files? Are you able to make a
>> regular HTTPS GET successfully?
>
> Yea, I was able to connect via https using Safari just fine.

No, I meant from CF, using CFHTTP.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314966
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Casey Dougall
On Fri, Nov 7, 2008 at 1:54 PM, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I have a WEBDAV server set up and I would like to post a file to it. I was 
> trying to use cfhttp and I keep getting a "Connection Failure: Status code 
> unavailable" error.
>
> Here is the simple code I'm using to test...
>
> https://myhost.com"; username="user" password="pass" 
> throwonerror="true">
>
> 


You are most likely not doing anything wrong. cfhttp request to https
are a real pain!!! Coldfusion is most likely not reading your SSL cert
correctly and the error sucks!

If you can make a call using http and that works, then it's the ssl cert.

Try this link for information on how to resolve it but it is still a
pain in the ass!

http://www.bpurcell.org/blog/index.cfm?mode=entry&entry=843

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314965
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Charles Heizer
I also just used Dreamweaver and it worked fine with put and get.

Thanks,
- Charles

> > I have a WEBDAV server set up and I would like to post a file to it. 
> I was trying to use
> > cfhttp and I keep getting a "Connection Failure: Status code 
> unavailable" error.
> 
> Can you check your web server's log files? Are you able to make a
> regular HTTPS GET successfully?
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more 
information! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314964
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


CFGrid|CFGridColumn usage.

2008-11-07 Thread Ian Skinner
I am attempting to use the new CF8 version of the Grid an GridColumn 
tags for the first time.  I have not made use of these tags since 4.5.

I have very specific usage in mind, but I am not quickly figuring out 
how to archive my goal from the documentation.  I'm hoping a couple of 
you all could suggest to me what combination of tags and parameters I 
want to use to make this happen.

I have a single database table I want to create a grid control to allow 
the editing with the following rules.

1) Display all five columns of the table for browsing; Code, Method, 
Active, Creation Date and End Date.

2) Only allow the editing of the Active column of existing records with 
a 'Y' value from a 'Y'es to a 'N'o.

3) Allow the adding of a new row of data by providing new Code and 
Method values.  The other fields are automatically determined during the 
SQL Insert statement.

Is this level of granularity supported in some form of the Grid control?

TIA
Ian

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314963
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Charles Heizer
Yea, I was able to connect via https using Safari just fine.

> > I have a WEBDAV server set up and I would like to post a file to it. 
> I was trying to use
> > cfhttp and I keep getting a "Connection Failure: Status code 
> unavailable" error.
> 
> Can you check your web server's log files? Are you able to make a
> regular HTTPS GET successfully?
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more 
information! 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314962
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: WEBDAV Put using CFHTTP

2008-11-07 Thread Dave Watts
> I have a WEBDAV server set up and I would like to post a file to it. I was 
> trying to use
> cfhttp and I keep getting a "Connection Failure: Status code unavailable" 
> error.

Can you check your web server's log files? Are you able to make a
regular HTTPS GET successfully?

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314961
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


WEBDAV Put using CFHTTP

2008-11-07 Thread Charles Heizer
Hello,
I have a WEBDAV server set up and I would like to post a file to it. I was 
trying to use cfhttp and I keep getting a "Connection Failure: Status code 
unavailable" error.

Here is the simple code I'm using to test...

https://myhost.com"; username="user" password="pass" 
throwonerror="true">



I have confirmed that the user name and password work and that I can add files.

What am I doing wrong?
Thanks,
- Charles

Oh yea, CFMX 7.0.3 on Linux 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314960
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Access individual instances in a cluster without JWS?

2008-11-07 Thread Jason Fisher
The other clustering approach is to use Client scope rather than Session scope. 
 To overly simplify things, Client scope is a contract between the user's 
browser and the application, whereas Session scope is a contract between the 
user's browser and the server.  Since Client scope can maintain state with the 
application, a user can be seamlessly bounced from server to server without 
loss of data / connection.  Works really well behind hardware load balancing, 
for example.  Not so sure it fits your situation, but thought I'd at least 
mention it in case.

Just remember to never, ever use Registry as your Client scope store.  It's the 
CF default, but it can quickly overwhelm server swapspace.  Go ahead and use a 
datasource instead. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314959
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Certified Adobe PDFs and cfdocument

2008-11-07 Thread Dave Watts
> From what I've been able to find on the Adobe website so far, it seems
> there are different kinds of pdfs.  PDFs created with Acrobat Pro can be
> digitally certified and locked to prevent the recipient from editing.
> CFDocument allows you to add a password, and prevent edits as well, but it
> is not the same as a digital certification.  Does anyone else have any
> experience with this?
>
> What the project folks would like is to use ColdFusion to generate
> certified pdfs, but I don't think this is possible, as from the docs I've
> read so far, the pdf types are different.

PDFs are certified through the application of a digital certificate.
This is completely different from password protection. CF doesn't
support this, and if you use CF to modify a certified PDF, it will
break the certification.

To generate certified PDFs, you will need Adobe LiveCycle.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314958
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Access individual instances in a cluster without JWS?

2008-11-07 Thread Dave Watts
> I should have mentioned that we have about 150 websites (running the same app 
> code) on > the server. And we add new sites every week..
>
> So I dismissed that option without investigating it a lot, recreating the 
> cluster every few
> days doesn't look like fun. So therefore we use the "all virtual servers" 
> option.
>
> Any other options?
>
> Is this a bug in JWS or will it stay this way "forever"?
> I cannot hope for a fix from Adobe on this?

Well, I wasn't aware of a bug in JWS that would cause this, as I've
set up clusters that used JWS to address the individual members and
IIS or Apache to address the cluster. But I don't use session
replication that much, honestly. Can you provide more information
about the bug?

Alternatively, you could configure a management interface in Apache
for each instance. You'll have to do that by hand, though - the
wsconfig tool only gets you so far with Apache.

Ultimately, you'll have to contact Adobe about a fix; I have no inside
information or access to their bugbase, etc.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314957
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Access individual instances in a cluster without JWS?

2008-11-07 Thread Matthew Williams
We leave the built-in JRun webserver turned on.  You can then just call 
http://{servername}:{jrunserver port}/cfide/administrator to access each 
instance.  You can even use SSL (as long as you don't have JVM 1.6 
installed!).  This assumes that you're using JRun... I'm not sure how 
other J2EE platforms are set up.  This has worked for us from MX 6.1 - 8.01.

Matthew Williams
Geodesic GraFX

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314956
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Certified Adobe PDFs and cfdocument

2008-11-07 Thread Randi Knutson
>From what I've been able to find on the Adobe website so far, it seems
there are different kinds of pdfs.  PDFs created with Acrobat Pro can be
digitally certified and locked to prevent the recipient from editing. 
CFDocument allows you to add a password, and prevent edits as well, but it
is not the same as a digital certification.  Does anyone else have any
experience with this?

What the project folks would like is to use ColdFusion to generate
certified pdfs, but I don't think this is possible, as from the docs I've
read so far, the pdf types are different. 

Any thoughts on this would be appreciated!

(yup we are running CF8).



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314955
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: strip alpha char

2008-11-07 Thread Peter Boughton
> Is there some magic CF function to take strings like this an strip the 
> alpha character?

With CF8 (and equiv) there is a new rematch function, which would allow:




Which is selecting the numbers rather than stripping the non-numbers.

The difference in behaviour would be if you had non-consecutive numbers, e.g. 
"Image12334blue1" - with the rereplace method, you would get "123341", but with 
rematch you get an array containing "12334" and "1".



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314954
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Access individual instances in a cluster without JWS?

2008-11-07 Thread WebSite CFTalk
Hello Dave,

I should have mentioned that we have about 150 websites (running the same app 
code) on the server.
And we add new sites every week..

So I dismissed that option without investigating it a lot, recreating the 
cluster every few days doesn't look like fun..
So therefore we use the "all virtual servers" option.

Any other options?

Is this a bug in JWS or will it stay this way "forever"?
I cannot hope for a fix from Adobe on this?

Thanks,
Helge

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: 7. november 2008 18:46
To: cf-talk
Subject: Re: Access individual instances in a cluster without JWS?

> 2 physical servers with 2 JRun instances on each on W2003/iis6.0. (CFMX 8.01 
> Ent.)
>
> Since 6.1 I've had no success with session replication across the cluster.
>
> I finally found a solution for that;
> Session replication was failing until I disabled JWS (and that took quite 
> some time to find > out.)
>
> So now the cluster is running fine, but since JWS is disabled I cannot access 
> the admin
> instances on the cluster. (And not having access to the server monitor is not 
> good..)
>
> I tried to add the admin roots to IIS but that didn't work since the 
> instances then got
> clustered also. Then I tried to use Apache as a second web server tied to the 
> admin root, > but I cannot find a way to connect that via the JRun connector.

First, you'll need to create multiple virtual servers in IIS - one for
the cluster, and one for each instance.

Next, you'll need to use wsconfig to delete the current connection
between your cluster and IIS, then delete the cluster itself (not the
cluster members, just the cluster).

Then, use wsconfig to connect each instance to the appropriate IIS
virtual server only - don't connect it to "all" IIS virtual servers.

Finally, recreate your cluster, and reconnect it to the appropriate
IIS virtual server, and you should be all set.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314953
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Access individual instances in a cluster without JWS?

2008-11-07 Thread Dave Watts
> 2 physical servers with 2 JRun instances on each on W2003/iis6.0. (CFMX 8.01 
> Ent.)
>
> Since 6.1 I've had no success with session replication across the cluster.
>
> I finally found a solution for that;
> Session replication was failing until I disabled JWS (and that took quite 
> some time to find > out.)
>
> So now the cluster is running fine, but since JWS is disabled I cannot access 
> the admin
> instances on the cluster. (And not having access to the server monitor is not 
> good..)
>
> I tried to add the admin roots to IIS but that didn't work since the 
> instances then got
> clustered also. Then I tried to use Apache as a second web server tied to the 
> admin root, > but I cannot find a way to connect that via the JRun connector.

First, you'll need to create multiple virtual servers in IIS - one for
the cluster, and one for each instance.

Next, you'll need to use wsconfig to delete the current connection
between your cluster and IIS, then delete the cluster itself (not the
cluster members, just the cluster).

Then, use wsconfig to connect each instance to the appropriate IIS
virtual server only - don't connect it to "all" IIS virtual servers.

Finally, recreate your cluster, and reconnect it to the appropriate
IIS virtual server, and you should be all set.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314952
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Access individual instances in a cluster without JWS?

2008-11-07 Thread WebSite CFTalk
Hello,

I've been struggling with clustering for a while now..

2 physical servers with 2 JRun instances on each on W2003/iis6.0. (CFMX 8.01 
Ent.)

Since 6.1 I've had no success with session replication across the cluster.

I finally found a solution for that;
Session replication was failing until I disabled JWS (and that took quite some 
time to find out.)

So now the cluster is running fine, but since JWS is disabled I cannot access 
the admin instances on the cluster.
(And not having access to the server monitor is not good..)

I tried to add the admin roots to IIS but that didn't work since the instances 
then got clustered also.
Then I tried to use Apache as a second web server tied to the admin root, but I 
cannot find a way to connect that via the JRun connector.

So,
Has anyone else experienced this?
Have you got a solution on how to access the admin instances without JWS and 
"outside" of the cluster?

Maybe there is a setting in JWS I've missed?

Thanks,
Helge

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314951
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: REReplace to avoid HTML elements

2008-11-07 Thread Peter Boughton
>The \b actually did not work, it put the link within the first span element
>but maybe was how I tested it.  I tried:  "(?![)(\b)(sub)(\b)" as
>well as  "(?![)\b(sub)\b"
>

Ah, you need to change your \2 to \1 in your replace part.

Since the \b is zero-width, it looks like it wont populate a backreference even 
when wrapped in parens.

Infact, if you wanted, you could go a step further and use \0 along with 
"(?![)\bsub\b" 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314950
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: strip alpha char

2008-11-07 Thread Andy Matthews
There's also REMatch (new in CF8) which returns the actual string matched
instead of just the position of that string.

-Original Message-
From: Chad Gray [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 07, 2008 10:57 AM
To: cf-talk
Subject: RE: strip alpha char

Ah... REReplace... I only knew of REFind...

THANKS!

> -Original Message-
> From: Matt Quackenbush [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2008 11:50 AM
> To: cf-talk
> Subject: Re: strip alpha char
> 
> Ops, I did that backwards...
> 
> reReplace(myString, "[\D]", "", "all")
> 
> 
> On Fri, Nov 7, 2008 at 10:46 AM, Matt Quackenbush
> <[EMAIL PROTECTED]>wrote:
> 
> > reReplace(myString, "[^A-Za-z]", "", "all")
> >
> 
> 
> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314949
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: strip alpha char

2008-11-07 Thread Matt Quackenbush
String functions:
http://livedocs.adobe.com/coldfusion/8/htmldocs/functions-pt0_18.html#1099887

:-)


On Fri, Nov 7, 2008 at 10:57 AM, Chad Gray <[EMAIL PROTECTED]> wrote:

> Ah... REReplace... I only knew of REFind...
>
> THANKS!
>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314948
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: REReplace to avoid HTML elements

2008-11-07 Thread Aaron Rouse
The \b actually did not work, it put the link within the first span element
but maybe was how I tested it.  I tried:  "(?![)(\b)(sub)(\b)" as
well as  "(?![)\b(sub)\b"

On Fri, Nov 7, 2008 at 10:49 AM, s. isaac dealey <[EMAIL PROTECTED]> wrote:

> > That's the \W bits you're using - they're wrong; you want a
> > zero-width word boundary, not a non-word character.
> >
> > Use \b(#Variables.Word#)\b and you wont need to do the workaround.
>
> Thanks Peter... I'd never used word boundaries... so of course, they
> don't occur to me when I go to write a regex. :) I'll have to remember
> that in the future.
>
>
>
> --
> s. isaac dealey  ^  new epoch
>  isn't it time for a change?
> ph: 781.769.0723
>
> http://onTap.riaforge.org/blog
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314947
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: strip alpha char

2008-11-07 Thread Chad Gray
Ah... REReplace... I only knew of REFind...

THANKS!

> -Original Message-
> From: Matt Quackenbush [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 07, 2008 11:50 AM
> To: cf-talk
> Subject: Re: strip alpha char
> 
> Ops, I did that backwards...
> 
> reReplace(myString, "[\D]", "", "all")
> 
> 
> On Fri, Nov 7, 2008 at 10:46 AM, Matt Quackenbush
> <[EMAIL PROTECTED]>wrote:
> 
> > reReplace(myString, "[^A-Za-z]", "", "all")
> >
> 
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314946
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: strip alpha char

2008-11-07 Thread Adrian Lynch
REReplace()

Adrian

-Original Message-
From: Chad Gray
Sent: 07 November 2008 16:44
To: cf-talk
Subject: strip alpha char


I have a list of file names and I only want the numbers in the file names.
I don't want any alpha characters.

I can use RE to find the numbers, but it get complicated to find the
starting position of the number and the ending of the numbers then using the
mid function to get the number.

Is there some magic CF function to take strings like this an strip the alpha
character?

Image12334blue
Image12323red

I want just the numbers:
12334
12323


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314945
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: strip alpha char

2008-11-07 Thread Matt Quackenbush
Ops, I did that backwards...

reReplace(myString, "[\D]", "", "all")


On Fri, Nov 7, 2008 at 10:46 AM, Matt Quackenbush <[EMAIL PROTECTED]>wrote:

> reReplace(myString, "[^A-Za-z]", "", "all")
>


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314943
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: REReplace to avoid HTML elements

2008-11-07 Thread s. isaac dealey
> That's the \W bits you're using - they're wrong; you want a
> zero-width word boundary, not a non-word character.
> 
> Use \b(#Variables.Word#)\b and you wont need to do the workaround. 

Thanks Peter... I'd never used word boundaries... so of course, they
don't occur to me when I go to write a regex. :) I'll have to remember
that in the future. 



-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 781.769.0723

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314944
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: strip alpha char

2008-11-07 Thread Matt Quackenbush
reReplace(myString, "[^A-Za-z]", "", "all")


On Fri, Nov 7, 2008 at 10:44 AM, Chad Gray <[EMAIL PROTECTED]> wrote:

> I have a list of file names and I only want the numbers in the file names.
>  I don't want any alpha characters.
>
> I can use RE to find the numbers, but it get complicated to find the
> starting position of the number and the ending of the numbers then using the
> mid function to get the number.
>
> Is there some magic CF function to take strings like this an strip the
> alpha character?
>
> Image12334blue
> Image12323red
>
> I want just the numbers:
> 12334
> 12323
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314942
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


strip alpha char

2008-11-07 Thread Chad Gray
I have a list of file names and I only want the numbers in the file names.  I 
don't want any alpha characters.
 
I can use RE to find the numbers, but it get complicated to find the starting 
position of the number and the ending of the numbers then using the mid 
function to get the number.
 
Is there some magic CF function to take strings like this an strip the alpha 
character?
 
Image12334blue
Image12323red
 
I want just the numbers:
12334
12323

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314941
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Can't access ColdFusion Administrator on IIS

2008-11-07 Thread Dave Watts
> I have just installed ColdFusion 8 on and IIS 6 machine. Upon completion when 
> I try to
> access Coldfusion administrator using www.mydomain.com/CFIDE/administrator
> /index.cfm. The system requests for an ID and password.
>
> But I did not setup any. How do I resolve this? TIA

You'll need to allow the "authenticated users" group to read and
execute files within the web server's root directory, and the wsconfig
subdirectory that was created when you configured the web server to
talk to IIS.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314940
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Can't access ColdFusion Administrator on IIS

2008-11-07 Thread Azadi Saryev
enable anonymous access on your web server

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Fawzi Amadu wrote:
> I have just installed ColdFusion 8 on and IIS 6 machine. Upon completion when 
> I try to access Coldfusion administrator using 
> www.mydomain.com/CFIDE/administrator/index.cfm. The system requests for an ID 
> and password.
>
> But I did not setup any. How do I resolve this? TIA 
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314939
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Can't access ColdFusion Administrator on IIS

2008-11-07 Thread Fawzi Amadu
I have just installed ColdFusion 8 on and IIS 6 machine. Upon completion when I 
try to access Coldfusion administrator using 
www.mydomain.com/CFIDE/administrator/index.cfm. The system requests for an ID 
and password.

But I did not setup any. How do I resolve this? TIA 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314938
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: REReplace to avoid HTML elements

2008-11-07 Thread Aaron Rouse
Thanks, I will try that out locally and make a note to apply it the next
time I am in there since I already initiated the push process to get the
changes into place.

On Fri, Nov 7, 2008 at 8:03 AM, Peter Boughton <[EMAIL PROTECTED]> wrote:

> >we ultimately came up with this:
> >"(?![ >
> >The only downside that we found is if the word is at the very end or
> >beginning of the paragraph.
>
> That's the \W bits you're using - they're wrong; you want a zero-width word
> boundary, not a non-word character.
>
> Use \b(#Variables.Word#)\b and you wont need to do the workaround.
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314937
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: REReplace to avoid HTML elements

2008-11-07 Thread Peter Boughton
>we ultimately came up with this:
>"(?![
>The only downside that we found is if the word is at the very end or
>beginning of the paragraph.

That's the \W bits you're using - they're wrong; you want a zero-width word 
boundary, not a non-word character.

Use \b(#Variables.Word#)\b and you wont need to do the workaround. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314936
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 image resize makes picture too small??

2008-11-07 Thread Azadi Saryev
as stated here:
http://cfsearching.blogspot.com/2008/04/coldfusion-8-imageresize-is-losing-it.html
(thanks again to -==cfSearching==- from adobe cf forums!), it is a
rounding problem and it is mentioned in CF8.0.1 release notes as a know
issue.

to absolutely make sure your resized image is of proper dimensions, you
have to manually calculate the resulting image size through percentage
reduction of whichever aspect you are resizing (w or h).

i have basically switched in all image resizing to using aspectCrop()
method from ben nadel's and ray camden's imageUtils.cfc (available on
riaforge.org)

hth

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/





~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314935
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CF8 image resize makes picture too small??

2008-11-07 Thread Adrian Lynch
It should get you 160x107 for the 968x648 image though.

I wonder if it's a bug or if there's a valid reason for it?

Adrian

-Original Message-
From: Michael Christensen
Sent: 07 November 2008 11:14
To: cf-talk
Subject: Re: CF8 image resize makes picture too small??


With a picture that 600x400 I get width = 160 px (as I asked) and a height
of 106px.

So it seems it could be rounding-related

>Yup, I've seen it but it's never been an issue because it's only 1px out.
>
>I get that maintaining the aspect ratio will result in decimal values but
>even when it's 159 it still gives it a decimal width.
>
>968x648
>160x107.107
>159x106.438
>
>What width are you getting, 107 or 106?
>
>I'm interested in this too.
>
>Adrian
>Building a database of ColdFusion errors at http://cferror.org/
>
>I have a jpg, width = 968px, height = 648px.
>
>I run the following command;
>name="oImage">
>
>and immediately after that;
>
>
>
>
>To my shock and horror, the width returned is 159 instead of the asked
>160!?!
>
>Has anyone else experienced this and is there a work-around?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314934
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 image resize makes picture too small??

2008-11-07 Thread Michael Christensen
With a picture that 600x400 I get width = 160 px (as I asked) and a height of 
106px.

So it seems it could be rounding-related

>Yup, I've seen it but it's never been an issue because it's only 1px out.
>
>I get that maintaining the aspect ratio will result in decimal values but
>even when it's 159 it still gives it a decimal width.
>
>968x648
>160x107.107
>159x106.438
>
>What width are you getting, 107 or 106?
>
>I'm interested in this too.
>
>Adrian
>Building a database of ColdFusion errors at http://cferror.org/
>
>I have a jpg, width = 968px, height = 648px.
>
>I run the following command;
>name="oImage">
>
>and immediately after that;
>
>
>
>
>To my shock and horror, the width returned is 159 instead of the asked
>160!?!
>
>Has anyone else experienced this and is there a work-around? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314933
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: CF8 image resize makes picture too small??

2008-11-07 Thread Michael Christensen
Thanks for the heads up - I knew cfimage was too good to be true :o)

Is this an officially known issue (i.e. Adobe acknowledges it) and if so, do 
you by any chance have a link to where this issue is described? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314932
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF8 image resize makes picture too small??

2008-11-07 Thread Adrian Lynch
Is that a definite solution or is it because the extra .1 happens to push
the height over .5 and so it rounds up maybe?

Adrian
Building a database of ColdFusion errors at http://cferror.org/

-Original Message-
From: Azadi Saryev
Sent: 07 November 2008 11:04
To: cf-talk
Subject: Re: CF8 image resize makes picture too small??

yes, it is a known issue. the workaround that worked for me is setting
the width/height .1 pixel larger than needed:



Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Michael Christensen wrote:
> I have a jpg, width = 968px, height = 648px.
>
> I run the following command;
> 
>
> and immediately after that;
>
> 
> 
>
> To my shock and horror, the width returned is 159 instead of the asked
160!?!
>
> Has anyone else experienced this and is there a work-around?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314931
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: CF8 image resize makes picture too small??

2008-11-07 Thread Adrian Lynch
Yup, I've seen it but it's never been an issue because it's only 1px out.

I get that maintaining the aspect ratio will result in decimal values but
even when it's 159 it still gives it a decimal width.

968x648
160x107.107
159x106.438

What width are you getting, 107 or 106?

I'm interested in this too.

Adrian
Building a database of ColdFusion errors at http://cferror.org/

-Original Message-
From: Michael Christensen
Sent: 07 November 2008 10:54
To: cf-talk
Subject: CF8 image resize makes picture too small??


I have a jpg, width = 968px, height = 648px.

I run the following command;


and immediately after that;




To my shock and horror, the width returned is 159 instead of the asked
160!?!

Has anyone else experienced this and is there a work-around?


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314930
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CF8 image resize makes picture too small??

2008-11-07 Thread Azadi Saryev
yes, it is a known issue. the workaround that worked for me is setting
the width/height .1 pixel larger than needed:



Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Michael Christensen wrote:
> I have a jpg, width = 968px, height = 648px.
>
> I run the following command;
>  name="oImage">
>
> and immediately after that;
>
> 
> 
>
> To my shock and horror, the width returned is 159 instead of the asked 160!?!
>
> Has anyone else experienced this and is there a work-around? 
>
>   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314929
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF8 image resize makes picture too small??

2008-11-07 Thread Michael Christensen
I have a jpg, width = 968px, height = 648px.

I run the following command;


and immediately after that;




To my shock and horror, the width returned is 159 instead of the asked 160!?!

Has anyone else experienced this and is there a work-around? 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314928
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfchart Flash chart not showing

2008-11-07 Thread James Holmes
You need a webserver mapping to /CFIDE/scripts.

mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/



2008/11/7 Sebastian Powell <[EMAIL PROTECTED]>:
> Looking at the page in the browser there is a warning in the status bar which 
> says:
>
> Line:204
> Char:1
> Error:Object Expected
> Code 0
>
> Thanks,
>
> Bas.
>
>> I have developed a few charts of format type "flash" using cfchart on
>> a development version of CF8 and they can be viewed no problems in the
>> browser.  When I deploy the code on CF8 standard, the charts do not
>> show. When changing the chart to format type "jpg" they do appear, so
>> seems to suggest an issue with the chart format type "flash".
>>
>> Am i missing a plugin or is it the version? Flash player is installed
>> and I have also ensure CF8 standard hot fix is up-to-date (hot fix 3).
>>
>>
>> Any ideas why this might be occurring?
>>
>> Thanks,
>>
>> Bas.
>>
>> Heres the code:
>>
>> > format="flash"
>> font="Arial"
>> fontsize=12
>> show3d="true">
>
>> >   type="pie"
>>   query="session.qTotResp"
>>   itemcolumn="Status"
>>   valuecolumn="PScore"/>
>> 
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314927
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4