RE: Creating Java String

[S . Isaac Dealey]

Ahh... I'd use mid() instead of string.substring() ... it's less
likely to confuse an entry-level cf coder and although BlueDragon
likely implements strings similarly, I'm not certain it does. Same
with railo.ch or any other cfml engine that might come later.

> You are absolutely right. I needed substring method.

> --
> Oleg Gunkin
> Email: [EMAIL PROTECTED]
> Phone: (604) 666-9392
> Emerging Technologies / Pacific Web Services
> Information Technology Services
> Public Works and Government Services Canada (Pacific)

> -Original Message-
> From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 24, 2006 16:07
> To: CF-Talk
> Subject: Re: Creating Java String


>> Can you please help me to create java String from
>> coldfusion srting?
>> I tried

>> 
>> 

>> but it returns the following error: "Unable to find a
>> constructor for class java.lang.String that accepts
>> parameters of type ( coldfusion.runtime.LocalScope )".

> What do you need a Java string object for? I would bet
> that you don't
> need it.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236201
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Creating Java String

[Oleg Gunkin]

You are absolutely right. I needed substring method.

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: S.Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 16:07
To: CF-Talk
Subject: Re: Creating Java String


> Can you please help me to create java String from
> coldfusion srting?
> I tried

> 
> 

> but it returns the following error: "Unable to find a
> constructor for class java.lang.String that accepts
> parameters of type ( coldfusion.runtime.LocalScope )".

What do you need a Java string object for? I would bet that you don't
need it.

s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236200
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Creating Java String

[Oleg Gunkin]

Nevermind, I screwed up in another place. Please ignore this thread.

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

-Original Message-
From: Oleg Gunkin 
Sent: Friday, March 24, 2006 15:57
To: CF-Talk
Subject: Creating Java String


Can you please help me to create java String from coldfusion srting?
I tried




but it returns the following error: "Unable to find a constructor for class 
java.lang.String that accepts parameters of type ( 
coldfusion.runtime.LocalScope )".

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236199
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Creating Java String

[S . Isaac Dealey]

> Can you please help me to create java String from
> coldfusion srting?
> I tried

> 
> 

> but it returns the following error: "Unable to find a
> constructor for class java.lang.String that accepts
> parameters of type ( coldfusion.runtime.LocalScope )".

What do you need a Java string object for? I would bet that you don't
need it.

s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236198
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Creating Java String

[Barney Boisvert]

CF strings ARE Java Strings.  You needn't do anything special.


#s.indexOf("s")#

cheers,
barneyb

On 3/24/06, Oleg Gunkin <[EMAIL PROTECTED]> wrote:
> Can you please help me to create java String from coldfusion srting?
> I tried
>
> 
> 
>
> but it returns the following error: "Unable to find a constructor for class 
> java.lang.String that accepts parameters of type ( 
> coldfusion.runtime.LocalScope )".
>
> --
> Oleg Gunkin

--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 100 invites.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236197
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Creating Java String

[Oleg Gunkin]

Can you please help me to create java String from coldfusion srting?
I tried




but it returns the following error: "Unable to find a constructor for class 
java.lang.String that accepts parameters of type ( 
coldfusion.runtime.LocalScope )".

--
Oleg Gunkin
Email: [EMAIL PROTECTED]
Phone: (604) 666-9392
Emerging Technologies / Pacific Web Services
Information Technology Services
Public Works and Government Services Canada (Pacific)

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236196
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Problem Installing New MX7 Instance

[Rob Wilkerson]

Has anyone ever had any trouble installing an MX7 instance in
multi-server configuration?  I have a developer machine:
WinXP SP2
CFMX7 Multi-server
IIS 5.1 (if that matters)

The machine is currently running 3 instances of MX7 and 1 instance of
MX6.1 that is deployed as a war file.  I'm trying to create a new MX7
instance and I keep getting the following error:

---
There was a problem
Message: The specified Directory attribute \servers\cfusion\SERVER-INF\temp\cfusion-war-tmp\2E85BB04-CF1E-54BF-49FC34E6D9076CCB\cfusion.ear\cfusion.war\CFIDE\scripts
cannot be deleted.
Detail: You may not have permissions to delete this directory. The
exception occurred during a cfdirectory action="delete".
---

I do have permissions (I'm an administrator on the machine) and, as
far as I can tell, the directory isn't locked by any process. 
Likewise, I've rebooted and tried the install with virtually nothing
else running.

I don't remember exactly when I created the other instances, but it
was a number of months ago - probably shortly after 7.0 was released. 
I've recently upgraded to 7.0.1, but the problem started before then. 
Since I don't remember when I did the original install, I can't be
certain of this, but I may have installed SP2 since the original
installs.  I've also kept up with the latest patches, of course.

Other than that, I can't think of any non-routine changes to the
machine configuration.  Has anyone else seen anything like this?  I've
been trying to add this new instance on and off for about the last
month and I'm dead in the water.  Any help or direction would be
greatly appreciated.

Thank you.

--

Rob Wilkerson

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236195
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Mike Klostermeyer]

Sorry, you are right.  Meant to mention that, but forgot.

Mike

-Original Message-
From: Munson, Jacob [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 3:02 PM
To: CF-Talk
Subject: RE: CFIF and null values


> Use the isNull() function directly in the SQL.

FYI, coalesce() is ANSI standard, isNull() is proprietary Microsoft
syntax.


---


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential
and/or exempt from disclosure under applicable law.  If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or use of the information contained herein (including any
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission
in error, please immediately contact the sender and destroy the material in
its entirety, whether in electronic or hard copy format.  Thank you.   A2





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236194
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF CMS recommendation

[Mark Holm]

>one of the difficulties in choosing a cms is to get your head round what
>your (or your clients) real requirements are.
>
>You really need to play with some to find out if it suits you.
>
>The bad news is that this represents a huge time investment.
>
>My approach was to start with a fairly simple CMS that I could get up and
>running quickly and then let this experience focus the requirements list -
>maybe hilighting features you need that were not initailly obvious.
>
>
>--
>Mike T
>Blog http://www.socialpoints.com/

Yes, I agree about the time. Unfortunately, as a one-man department, time is a 
luxury I do not have. This is why I was hoping to get a few bit ‘o wisdom 
from cf-talk.
So I’m doing this by seat of my pants. However, after the suggestions here 
and review of various CMS websites and blogs of course, I have gotten it 
narrowed down to farcry, assetnow and dynaportal.

Mark

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236193
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflogin and load balancing

[Adam Churvis]

If I'm not mistaken, *authorization* (not authentication) can't work across 
multiple CF servers -- clustered or not -- because there's no mechanism for 
specifying *roles* on any computer other than the one on which CFLOGINUSER was 
executed.  

It doesn't matter whether you're using cookies or session (with proper session 
syndication in place) because the cookie contains only the username, password, 
and application name -- no roles.  Which is another reason why you want to use 
loginStorage="Session", as the cookie is not encrypted (it's only Base64 
encoded).

BlueDragon, however, *does* handle all authentication and authorization 
properly across servers with the CFLOGIN framework.
Respectfully,

Adam Phillip Churvis
Certified Advanced ColdFusion MX 7 Developer
BlueDragon Alliance Founding Committee



Get advanced intensive Master-level training in
C# & ASP.NET for ColdFusion Developers at
ProductivityEnhancement.com

  - Original Message - 
  From: wolf2k5 
  To: CF-Talk 
  Sent: Friday, March 24, 2006 4:26 PM
  Subject: Re: cflogin and load balancing


  On 3/23/06, Adam Churvis <[EMAIL PROTECTED]> wrote:
  > ColdFusion Server is broken with respect to the CFLOGIN security framework
  > working on a clustered system with failover.  The reason is that the
  > authentication cookie contains the authentication information but not any
  > authorization (roles) information.  The authorization information is stored
  > locally only on the server on which CFLOGINUSER was called, but not in the
  > Session scope, so this information never gets synidcated to the other
  > machines.

  Setting cflogin to use cookies appears to work fine with multiple non
  clustered CF servers.

  Cheers.

  

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236192
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Michael E. Carluen]

Actually, if your using the expr3 variable on  ,
just be mindful of where the var is coming from- either from a query column
or as locally cfset var... always helps to be a little bit more explicit.

-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 1:35 PM
To: CF-Talk
Subject: RE: CFIF and null values

For the record, this worked. Apparently, changing the variable name is
required of CF can't keep track ot it. 

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 1:12 PM
To: CF-Talk
Subject: RE: CFIF and null values

Try this, works for me all the time







#newvar#



-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 12:58 PM
To: CF-Talk
Subject: RE: CFIF and null values

 
expr3=[#expr3#]

Results in:

expr3=[]  

on the web page.

I can see the NULL in the database. Datatype is SQL-Server numeric.

I am mystified why this does not work Maybe a typo??

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 12:49 PM
To: CF-Talk
Subject: Re: CFIF and null values

  will ctach NULLs

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com









~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236191
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Richard Colman]

For the record, this worked. Apparently, changing the variable name is
required of CF can't keep track ot it. 

-Original Message-
From: Michael E. Carluen [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 1:12 PM
To: CF-Talk
Subject: RE: CFIF and null values

Try this, works for me all the time







#newvar#



-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 12:58 PM
To: CF-Talk
Subject: RE: CFIF and null values

 
expr3=[#expr3#]

Results in:

expr3=[]  

on the web page.

I can see the NULL in the database. Datatype is SQL-Server numeric.

I am mystified why this does not work Maybe a typo??

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 12:49 PM
To: CF-Talk
Subject: Re: CFIF and null values

  will ctach NULLs

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com







~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236190
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflogin and load balancing

[wolf2k5]

On 3/23/06, Adam Churvis <[EMAIL PROTECTED]> wrote:
> ColdFusion Server is broken with respect to the CFLOGIN security framework
> working on a clustered system with failover.  The reason is that the
> authentication cookie contains the authentication information but not any
> authorization (roles) information.  The authorization information is stored
> locally only on the server on which CFLOGINUSER was called, but not in the
> Session scope, so this information never gets synidcated to the other
> machines.

Setting cflogin to use cookies appears to work fine with multiple non
clustered CF servers.

Cheers.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236189
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Having a common directory shared by several sites

[Claude Schneegans]

 >>Ahh, by using iFrames you are making new requests. 

Exact.

 >>My first thought is to call a façade template inside the application 
that simply includes the common template from the shared or mapped folder.

This is the solution I'm testing, thanks.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236188
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflogin and load balancing

[wolf2k5]

On 3/23/06, wolf2k5 <[EMAIL PROTECTED]> wrote:
> But I still wonder why the cflogin cookie includes the full login info
> (username/password base64 encoded), what does it need to then?

I stand corrected again!

I did further testing and the cflogin/cfloginuser code will
automatically login the user on the second server if the user has the
cflogin cookie from the first server.

It looks like using cflogin (set to use cookies) correctly will work
for my setup with mutiple servers not clustered, even if it's not very
secure (since the cookie includes the username/password).

Regards.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236187
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Having a common directory shared by several sites

[Claude Schneegans]

 >>If you include any template from a virtual directory it will 
automatically be in the application
and session scope of the application that included it.

As I said, I do not include the templates but run them as part of the 
application.
However, I've found a place in my app where most of them are called, so 
I replaced
the address, for instance "userEdit.cfm?id=#id#" by 
"common.cfm?userEdit.cfm&id=#id#"
and common.cfm is a very simple template that includes userEdit.cfm from 
the virtual common directory.

But I still have a lot of things to check before all the app works.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236186
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Michael E. Carluen]

Try this, works for me all the time







#newvar#



-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 12:58 PM
To: CF-Talk
Subject: RE: CFIF and null values

 
 expr3=[#expr3#]

Results in:

expr3=[]  

on the web page.

I can see the NULL in the database. Datatype is SQL-Server numeric.

I am mystified why this does not work Maybe a typo??

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 12:49 PM
To: CF-Talk
Subject: Re: CFIF and null values

  will ctach NULLs

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236185
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Having a common directory shared by several sites

[Ian Skinner]

They are called in iFrames, by url or by forms.

Ahh, by using iFrames you are making new requests.  My first thought is to call 
a façade template inside the application that simply includes the common 
template from the shared or mapped folder.  But I'm sure there are other ways 
to skin this cat.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236184
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Seapine SCM Users?

[Eric J. Hoffman]

If you are a user/administrator of Seapine, and wouldn't mind a quick
question, could you email me offline?

Gracias!!



Eric J. Hoffman
Managing Partner
2081 Industrial Blvd
StillwaterMN55082
mail: [EMAIL PROTECTED]
www: http://www.ejhassociates.com
tel: 651.717.4105
fax: 651.717.4115
mob: 651.245.2717



This message contains confidential information and is intended only for [EMAIL 
PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, 
distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by 
e-mail if you have received this e-mail by mistake and delete this e-mail from 
your system. E-mail transmission cannot be guaranteed to be secure or 
error-free as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does 
not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236183
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Munson, Jacob]

> Use the isNull() function directly in the SQL.

FYI, coalesce() is ANSI standard, isNull() is proprietary Microsoft
syntax.


---


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236182
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Munson, Jacob]

> 

This should be 'eq' not '='.  You knew that, I'm sure, just a slip.  :)





[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236181
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Richard Colman]

 
 expr3=[#expr3#]

Results in:

expr3=[]  

on the web page.

I can see the NULL in the database. Datatype is SQL-Server numeric.

I am mystified why this does not work Maybe a typo??

-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 12:49 PM
To: CF-Talk
Subject: Re: CFIF and null values

  will ctach NULLs

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236180
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Having a common directory shared by several sites

[Ian Skinner]

but what would be a simple
and convenient way for the common templates to get the application name 
it was called from
and set the proper application and session variables ?

By calling the template from the application.  Viola your done!

If you include any template from a virtual directory it will automatically be 
in the application and session scope of the application that included it.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236179
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Mike Klostermeyer]

Use the isNull() function directly in the SQL.

Mike

-Original Message-
From: Steve Milburn [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 2:50 PM
To: CF-Talk
Subject: Re: CFIF and null values


What is the data type of the field in the database?  If it is a char, it
could be an empty string of the length of the field specification, ie
char(10).  In which case, adding a trim to the function should work -
trim(len(expr3)) eq 0

Steve

Richard Colman wrote:
> I have a null value being returned from a query. I would like to catch it
> and give it a value before proceeding.
>
> So, assuming that CF returns a null value as a null string, I tried the
> following:
>
> 
>   
> 
>
> Also
>
> 
>   
> 
>
> However, neither of these are working.
>
> Any suggestions appreciated.
>
> Rick Colman
>
>
>
>
>



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236178
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFIF and null values

[Rob Wilkerson]

I've found that it's a good practice to trim any strings whose length
is being tested - especially when testing for zero-length.  You never
know when a space is going to sneak in there and I find random spaces
that I'm not expecting to be a very time consuming thing to debug
because it's never the first (or even the thirty-first) thing I try.

Take it for what it's worth.  Maybe I'm just not a quick learner.  :-)

On 3/24/06, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
>   will ctach NULLs
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236177
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Dave Watts]

> I have a null value being returned from a query. I would like 
> to catch it and give it a value before proceeding.
> 
> So, assuming that CF returns a null value as a null string, I 
> tried the following ...

CF does return NULL values as empty strings (not "null" strings, since there
are no such things!)

However, if you don't want this to happen, your best bet may be to handle it
in the database. For example, if you're using SQL Server, you can use
functions such as ISNULL or COALESCE to replace NULL values with something
else.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236176
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

job openings

[Netling, Kim]

 

 

Here's a blurb on some job postings we're putting out on net that someone in
our group might be interested in:

 

The Business Applications Group for the State of Alaska, Department of
Health and Social Services is looking for talented software developers with
all levels of experience. Our positions provide opportunities to use a
myriad of technologies including:

*   Microsoft Visual Studio .NET, 
*   IBM WebSphere RAD/J2EE, 
*   IBM Rational Team Unifying Platform and Modeling Tools (ClearCase,
ClearQuest, RequisitePro, Software Modeler), and 
*   ColdFusion 
*   MS SQL 

Our staff is located in Anchorage and Juneau, the Capital of Alaska. Both
towns have great access to outdoor activities - from the heart of downtown
Juneau, you can access: 

*   boating, 
*   scuba diving, 
*   sea and whitewater kayaking, 
*   mountaineering, 
*   rock climbing, 
*   ice climbing, 
*   backcountry and lift skiing, 
*   rink and pond hockey, 
*   figure skating, 
*   hiking, 
*   hunting, and 
*   fishing 

In addition, we have excellent art, music, and service communities that
allow you to participate instead of just observe.  Some of Juneau's
organizations include:

*   The Juneau Symphony (http://www.juneausymphony.org/
 ), 
*   Juneau Lyric Opera (http://www.juneau.com/opera/
 ), 
*   Perseverance Theatre (http://www.perseverancetheatre.org/
 ), 
*   The Alaska Folk Festival (http://akfolkfest.org/
 ), 
*   Juneau Arts& Humanities Council (http://www.juneauartscouncil.org/
 ), 
*   Juneau Jazz and Classics (http://www.jazzandclassics.org/about.php
 ), 
*   KTOO public radio (http://www.ktoo.org/  ), 
*   Capital City Fire and Rescue (http://www.ccfr.net/
 ), 
*   Juneau Mountain Rescue (http://www.juneaumountainrescue.org/
 out of date - but last year over 10
call-outs), 
*   Forest service cabin
network(http://www.fs.fed.us/r10/tongass/cabins/cabinlist.shtml#jnu
 ) 

 

 

We have positions open now, and expect to post many more in the next few
months!  Please visit
http://www.hss.state.ak.us/apps/itsjobs/recruitment.aspx
  to apply!

 

 

Kim Netling, APV

State of Alaska H&SS

FMS - Information Systems Section

P.O. Box 11650

Juneau, AK  99811-0650

(907) 465-3312

  

 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236175
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFIF and null values

[Steve Milburn]

What is the data type of the field in the database?  If it is a char, it 
could be an empty string of the length of the field specification, ie 
char(10).  In which case, adding a trim to the function should work - 
trim(len(expr3)) eq 0

Steve

Richard Colman wrote:
> I have a null value being returned from a query. I would like to catch it
> and give it a value before proceeding.
>
> So, assuming that CF returns a null value as a null string, I tried the
> following:
>
> 
>   
> 
>
> Also
>
> 
>   
> 
>
> However, neither of these are working. 
>
> Any suggestions appreciated.
>
> Rick Colman
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236174
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Richard Colman]

Did that, no spaces ... 

-Original Message-
From: Rob Wilkerson [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 12:48 PM
To: CF-Talk
Subject: Re: CFIF and null values

I use len ( trim ( the_null_value ) ) often and it's never failed. 
Any chance the value returned is actually 'NULL'?  Try dumping expr3, but
wrap the output with some sort of delimiter so you can tell whether there's
any space, maybe...

On 3/24/06, Richard Colman <[EMAIL PROTECTED]> wrote:
> I have a null value being returned from a query. I would like to catch 
> it and give it a value before proceeding.
>
> So, assuming that CF returns a null value as a null string, I tried 
> the
> following:
>
> 
> 
> 
>
> Also
>
> 
> 
> 
>
> However, neither of these are working.
>
> Any suggestions appreciated.
>
> Rick Colman
>
>
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236173
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFIF and null values

[Adkins, Randy]

If the value is a Query value two options you could possibly do


   
   

   
   
   
   
   
   

Then use the new variable.

Now something I have not tried is since the Query is actually a
structure,
If you know the column and row, you can update the structure.
Someone on here mentioned that earlier but not had a chance to test it.


-Original Message-
From: Richard Colman [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 3:42 PM
To: CF-Talk
Subject: CFIF and null values

I have a null value being returned from a query. I would like to catch
it and give it a value before proceeding.

So, assuming that CF returns a null value as a null string, I tried the
following:





Also





However, neither of these are working. 

Any suggestions appreciated.

Rick Colman






~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236172
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFIF and null values

[Bryan Stevenson]

  will ctach NULLs

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236171
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFIF and null values

[Rob Wilkerson]

I use len ( trim ( the_null_value ) ) often and it's never failed. 
Any chance the value returned is actually 'NULL'?  Try dumping expr3,
but wrap the output with some sort of delimiter so you can tell
whether there's any space, maybe...

On 3/24/06, Richard Colman <[EMAIL PROTECTED]> wrote:
> I have a null value being returned from a query. I would like to catch it
> and give it a value before proceeding.
>
> So, assuming that CF returns a null value as a null string, I tried the
> following:
>
> 
> 
> 
>
> Also
>
> 
> 
> 
>
> However, neither of these are working.
>
> Any suggestions appreciated.
>
> Rick Colman
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236170
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Regex on a big data

[Munson, Jacob]

> The results were a little surprising to me.  CF Tags did 
> better when processing a million lines in 265 files but the 
> java objects did better when processing 1 large file (100MB).

That's very interesting.  Looking at your results, I'd think Perl is
faster than both.  But I haven't tested it.  :)


--

This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or use of the information contained herein (including any reliance thereon) is 
STRICTLY PROHIBITED. If you received this transmission in error, please 
immediately contact the sender and destroy the material in its entirety, 
whether in electronic or hard copy format. Thank you. A1.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236169
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CFIF and null values

[Richard Colman]

I have a null value being returned from a query. I would like to catch it
and give it a value before proceeding.

So, assuming that CF returns a null value as a null string, I tried the
following:





Also





However, neither of these are working. 

Any suggestions appreciated.

Rick Colman




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236168
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Having a common directory shared by several sites

[Claude Schneegans]

 >>Why does this seem difficult to you?

Because I'm not using includes nor cfhttp.
These are plain vanilla CF templates that count on the application.cfm 
to set a whole bunch of variables and parameters.
Every set of templates is a sub application. Ie: select a user in the 
database, edit him, update him.
They are called in iFrames, by url or by forms.
I could pass the application name in the url, but I'm looking for a more 
elegant and safer solution.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236167
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Having a common directory shared by several sites

[Claude Schneegans]

 >>Isn't that what custom tag paths and cf server mappings are for?

Well, the problem is that my modules are not custom tags.
Most of them for instance are called inside an iFrame.
Each module is in the admin directory, and the Application.cfm template 
checks for users logged
and 
This ../Application.cfm sets the application name, but it is not 
reacheable this way anymore.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236166
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Having a common directory shared by several sites

[Loathe]

If your using mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 3:07 PM
To: CF-Talk
Subject: Having a common directory shared by several sites

Hi,

I'm thinking about a solution that will allow me to have several CF sites
sharing some templates in common in some special directory.

Defining a pseudo directory in IIS for every site is not really a problem,
but what would be a simple and convenient way for the common templates to
get the application name it was called from and set the proper application
and session variables ?

Any idea ?

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED]) Thanks.




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236165
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Having a common directory shared by several sites

[S . Isaac Dealey]

> Hi,

> I'm thinking about a solution that will allow me to have
> several CF
> sites sharing some templates in common
> in some special directory.

> Defining a pseudo directory in IIS for every site is not
> really a
> problem, but what would be a simple
> and convenient way for the common templates to get the
> application name
> it was called from
> and set the proper application and session variables ?

> Any idea ?

Isn't that what custom tag paths and cf server mappings are for?
(asside from cfc discovery) ... when you call the tag it has access to
all the scopes, so if it's executed within an application, whether it
uses application.cfc or the cfapplication tag, it can reference
#application.applicationname# just like any other template. The
mapping in conjunction with cfmodule or cfimport would give you less
ambiguity and thereby decrease the likelyhood of namespace conflicts
with templates in the directory containing the calling template.


s. isaac dealey 434.293.6201
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236164
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Having a common directory shared by several sites

[Claude Schneegans]

 >>Why not just assign a mapping in each CF app

Why not indeed ? I'll try this ;-)
Thanks.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236163
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Having a common directory shared by several sites

[Steve Brownlee]

Why not just assign a mapping in each CF app that points to the common
directory?  Automatically gets the App and Sess scope when called. 

> -Original Message-
> From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
> Sent: Friday, March 24, 2006 3:07 PM
> To: CF-Talk
> Subject: Having a common directory shared by several sites
> 
> Hi,
> 
> I'm thinking about a solution that will allow me to have several CF 
> sites sharing some templates in common
> in some special directory.
> 
> Defining a pseudo directory in IIS for every site is not really a 
> problem, but what would be a simple
> and convenient way for the common templates to get the 
> application name 
> it was called from
> and set the proper application and session variables ?
> 
> Any idea ?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236162
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Regex on a big data

[Trevor Burnette]

Here is an article I just did on regex java objects in CF.

http://www.burnette.us/blog/index.cfm/2006/3/23/Using-Java-RegEx-in-ColdFusion-App

The results were a little surprising to me.  CF Tags did better when processing 
a million lines in 265 files but the java objects did better when processing 1 
large file (100MB).

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236161
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Having a common directory shared by several sites

[Claude Schneegans]

Hi,

I'm thinking about a solution that will allow me to have several CF 
sites sharing some templates in common
in some special directory.

Defining a pseudo directory in IIS for every site is not really a 
problem, but what would be a simple
and convenient way for the common templates to get the application name 
it was called from
and set the proper application and session variables ?

Any idea ?

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236160
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can I change query results?

[Lee.S.Surma]

I have a question related to this. When you get into a situation where
you have numerous joins in one query, are you better off breaking the
mess into several database Views and simplifying the query? Could you
realize speed gains?

Lee Surma
 

-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 1:26 PM
To: CF-Talk
Subject: Re: Can I change query results?

The query is a massive query involving an inner and a few outer joins
with several conditionals around the joins. Because of new
requirements, I have to add four more tables to this beast of a query
so that I could let the DB do the math. If you have ever dealt with a
query that involves inner and outer joins, you would understand the
nightmare that is involved with guaranteeing the query always returns
the data you want.

So I need to do math on a column based on that specific columns needs.
Since adding more joined tables to the mix cause massive problems, I
want to do it after the fact. The only other choice is to rewrite the
query as a stored proc but my skills are limited in that area.

Phil

On 3/24/06, Ken Ferguson <[EMAIL PROTECTED]> wrote:
> I'm more interested in why you "can't" do the calcs in your original
> query. Why don't you post the query and tell us what the calcs you'd
> like to do look like. I'll bet we can figure a way to get it done in
the
> query.
>
> --Ferg



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236159
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can I change query results?

[Nick Han]

Sounds like you need a data warehouse.  On line transactional data model
is never efficient in pulling back by massive, additive type of data.

-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 11:26 AM
To: CF-Talk
Subject: Re: Can I change query results?

The query is a massive query involving an inner and a few outer joins
with several conditionals around the joins. Because of new
requirements, I have to add four more tables to this beast of a query
so that I could let the DB do the math. If you have ever dealt with a
query that involves inner and outer joins, you would understand the
nightmare that is involved with guaranteeing the query always returns
the data you want.

So I need to do math on a column based on that specific columns needs.
Since adding more joined tables to the mix cause massive problems, I
want to do it after the fact. The only other choice is to rewrite the
query as a stored proc but my skills are limited in that area.

Phil

On 3/24/06, Ken Ferguson <[EMAIL PROTECTED]> wrote:
> I'm more interested in why you "can't" do the calcs in your original
> query. Why don't you post the query and tell us what the calcs you'd
> like to do look like. I'll bet we can figure a way to get it done in
the
> query.
>
> --Ferg



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236158
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Can I change query results?

[Phill B]

The query is a massive query involving an inner and a few outer joins
with several conditionals around the joins. Because of new
requirements, I have to add four more tables to this beast of a query
so that I could let the DB do the math. If you have ever dealt with a
query that involves inner and outer joins, you would understand the
nightmare that is involved with guaranteeing the query always returns
the data you want.

So I need to do math on a column based on that specific columns needs.
Since adding more joined tables to the mix cause massive problems, I
want to do it after the fact. The only other choice is to rewrite the
query as a stored proc but my skills are limited in that area.

Phil

On 3/24/06, Ken Ferguson <[EMAIL PROTECTED]> wrote:
> I'm more interested in why you "can't" do the calcs in your original
> query. Why don't you post the query and tell us what the calcs you'd
> like to do look like. I'll bet we can figure a way to get it done in the
> query.
>
> --Ferg

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236157
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CAPTCHA

[Sandra Clark]

Cons:

Captcha's have accessibility problems.  Unless you also implement a spoken
system (where the system speaks the letters to be typed), a blind person
cannot use your system.

I ran into the same problem with my comment form on my new blog.  I
ultimately decided to go with a blacklist/whitelist system that I worked
out.  It does take some personal attention when a new person posts a
comment, but so far no spam.

I check to make sure the IP the form comes from is the same as my site, if
not the user gets blacklisted.

If the form has words that are forbidden, the user gets blacklisted.

If the user is blacklisted, the contents go to the ether. 

If the user is not blacklisted, the form gets posted.

If the user is whitelisted, then the comments get sent to subscribers

If the user is not whitelisted or blacklisted, then I get an email with the
form contents and two links, one allowing me to whitelist the user, and one
allowing me to blacklist the user (if the user is blacklisted, the comment
gets deleted).  If I whitelist the user, the comments get sent to
subscribers.

I, of course have an interest in accessibility and I need to walk my talk on
my web site.  YMMV.

Sandra Clark
==
http://www.shayna.com
Training in Cascading Style Sheets and Accessibility 


-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 1:28 PM
To: CF-Talk
Subject: CAPTCHA

Okay I have now a need to implement a Captcha type validation.
It seems my forms are getting spammed.
 
I know it has been discussed in the past as I also have searched the
archives. 

Which captcha functionality do you use and the pros/cons?
 
Thanks!
 




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236156
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CAPTCHA

[Adkins, Randy]

Okay I have now a need to implement a Captcha type validation.
It seems my forms are getting spammed.
 
I know it has been discussed in the past as I also have searched
the archives. 

Which captcha functionality do you use and the pros/cons?
 
Thanks!
 


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236155
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF7 Standard to CF7 Enterprise Upgrade

[Mike Fleming]

That makes sense.  My client is mainly looking at the upgrade to take
advantage of the supposed increase and multiple thread runs for cfdocument.
So from what the folks here have mentioned, it sounds as though we can
purchase the Enterprise license, pop the key in and take advantage of that
increased performance.  In their off season, I could then go down the
reinstall path to take advantage of the multi server instance features.

Also, for everyone's knowledge, I called Adobe today and asked the pricing.
If you already own a license for CF7 Standard, you can purchase to
Enterprise for $4700 (a discount of $1300 from the full version).  If you do
the quick math, basically they subtract the price of the standard edition
from the full enterprise since you already own it.  You cannot just buy the
upgrade of Enterprise as you would already need to have a license for a
previous Enterprise version.

Thanks for the responses.

Mike 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 12:17 PM
To: CF-Talk
Subject: RE: CF7 Standard to CF7 Enterprise Upgrade

> I believe it is the new license gets the Enterprise stuff, can anyone 
> confirm?  (going by how the trial works, enterprise back to developer, 
> etc)

Yes, whenever you change your serial number, you get the functionality
allowed by that license. However, a lot of the value of an Enterprise
license is wrapped up in the ability to run a complete JRun install, and you
would need to reinstall CFMX to get that if you upgraded from Standard to
Enterprise.

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!




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236154
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Can I change query results?

[Ken Ferguson]

I'm more interested in why you "can't" do the calcs in your original 
query. Why don't you post the query and tell us what the calcs you'd 
like to do look like. I'll bet we can figure a way to get it done in the 
query.

--Ferg


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236153
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Dave Watts]

> Contribute itself is not a true CMS - in terms of features 
> anyway!

Sure it is. It may be on the low end, but you can certainly consider
Contribute (especially with CPS) to be a CMS. You can set up workflow,
notifications, 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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236151
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: coldfusion built-in security framework: get a list of all roles for an user

[Nick Han]

No, but there's a workaround.

What I do is I stick the role list in the name of cfloginuser, once the
user has been authenticated, like so mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 7:25 AM
To: CF-Talk
Subject: coldfusion built-in security framework: get a list of all roles
for an user

Hi all,

I'm using the ColdFusion built-in security framework
(cflogin/cflogout) for a small application.

I can check if an user has a role by using the isUserInRole function.

Is there any way to get a list of all roles for an user?

Thanks.



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236152
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can I change query results?

[Nick Han]

Can don't you derive the computed column in the SQL statement itself?
Let the db do the heavy lifting.

-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 8:37 AM
To: CF-Talk
Subject: Can I change query results?

I query a database and receive multiple rows of data. Now I need to do
some conditional math on one of the columns. I would do this in the
initial query but I can't.

I tried to see if I could do an update on the column with a cfquery on
the record set. Sadly, update doesn't work in Query of queries. Grrr

So, how does some one go about doing this?

--
Phil



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236150
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can I change query results?

[Dave Watts]

> I query a database and receive multiple rows of data. Now I 
> need to do some conditional math on one of the columns. I 
> would do this in the initial query but I can't.
> 
> I tried to see if I could do an update on the column with a 
> cfquery on the record set. Sadly, update doesn't work in 
> Query of queries. Grrr
> 
> So, how does some one go about doing this?

You cannot use UPDATE with query of queries, because there are no actual
tables to be updated. You can, however, SELECT against an existing query,
and do your math in that SELECT.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236149
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF7 Standard to CF7 Enterprise Upgrade

[Dave Watts]

> I believe it is the new license gets the Enterprise 
> stuff, can anyone confirm?  (going by how the trial works, 
> enterprise back to developer, etc) 

Yes, whenever you change your serial number, you get the functionality
allowed by that license. However, a lot of the value of an Enterprise
license is wrapped up in the ability to run a complete JRun install, and you
would need to reinstall CFMX to get that if you upgraded from Standard to
Enterprise.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236148
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Dave Watts]

> Well, so it runs on Java ;-) using CF as the application?

Yes, it contains enough of JRun and CF to run the CF scripts that it comes
with. You can also extend some of those scripts to provide additional
functionality. You can't, however, write your own CF code and run it on CPS.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236147
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Robertson-Ravo, Neil (RX)]

Well, so it runs on Java ;-) using CF as the application?



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 16:56
To: CF-Talk
Subject: RE: CF CMS recommendation

> It runs on CF? eh?

The Contribute Publishing Service uses an embedded CF server, yes. CPS isn't
required to use Contribute.

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!




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236146
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can I change query results?

[Munson, Jacob]

The QuerySetCell function should work, if you use the row_Number
parameter (loop over all rows):
http://techfeed.net/cfQuickDocs/?querysetcell 

> -Original Message-
> From: Phill B [mailto:[EMAIL PROTECTED] 
> Sent: Friday, March 24, 2006 9:37 AM
> 
> I query a database and receive multiple rows of data. Now I need to do
> some conditional math on one of the columns. I would do this in the
> initial query but I can't.
> 
> I tried to see if I could do an update on the column with a cfquery on
> the record set. Sadly, update doesn't work in Query of queries. Grrr
> 
> So, how does some one go about doing this?


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236145
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Dave Watts]

> It runs on CF? eh?

The Contribute Publishing Service uses an embedded CF server, yes. CPS isn't
required to use Contribute.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236144
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF7 Standard to CF7 Enterprise Upgrade

[Eric J. Hoffman]

There is a path, I think it is 2699 retail or something like that.  I
believe it is the new license gets the Enterprise stuff, can anyone
confirm?  (going by how the trial works, enterprise back to developer,
etc) 





Eric J. Hoffman
Managing Partner
2081 Industrial Blvd
StillwaterMN55082
mail: [EMAIL PROTECTED]
www: http://www.ejhassociates.com
tel: 651.717.4105
fax: 651.717.4115
mob: 651.245.2717



This message contains confidential information and is intended only for [EMAIL 
PROTECTED] If you are not cf-talk@houseoffusion.com you should not disseminate, 
distribute or copy this e-mail. Please notify [EMAIL PROTECTED] immediately by 
e-mail if you have received this e-mail by mistake and delete this e-mail from 
your system. E-mail transmission cannot be guaranteed to be secure or 
error-free as information could be intercepted, corrupted, lost, destroyed, 
arrive late or incomplete, or contain viruses. Eric J. Hoffman therefore does 
not accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required please request a hard-copy version.


-Original Message-

From: Jeff Fleitz [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 10:42 AM
To: CF-Talk
Subject: Re: CF7 Standard to CF7 Enterprise Upgrade

Hey Mike,

We are considering this as well.  I have not been able to find an
upgrade path from CFMX7 Standard to Enterprise, have you?

On 3/24/06, Mike Fleming <[EMAIL PROTECTED]> wrote:
>
> Hello all.  I currently have CF Standard up and running on a 
> production server.  The client downloaded the trial version got it 
> running, then purchased the license and popped that on the server.  We

> are thinking of upgrading the server to CF7 Enterprise (mainly for the

> perfomance increase for cfdoucment).  Does anyone know if that would 
> require a total reinstall of CF or if the newly purchased license key 
> could be popped in and the new Enterprise features would then be 
> enabled.  I'm guessing it would require a new install but I'd just 
> like to know for sure before getting back to the client.
>
> Thanks,
> Mike
>
>
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236143
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Joining two different databases?

[Andy Matthews]

Oooh...

I forgot about that option. I'll give it a shot and see how it works.



-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 9:57 AM
To: CF-Talk
Subject: Re: Joining two different databases?


If the dbs are on the same server, and the connected user has the
correct rights, you would just need to qualify the table names with
the db names...
SELECT  FROM db1.table1 INNER JOIN db2.table2 ON 

I believe the above will work for MySQL...in MS-SQL, you will have to
also include the table owner...
SELECT  FROM db1.dbo.table1 INNER JOIN db2.dbo.table2 ON 
or just
SELECT  FROM db1..table1 INNER JOIN db2..table2 ON 

I don't think you have to include the table owner in MySQL.

On 3/24/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
> I'm building a site for a realtor who will be displaying real estate
> listings on their website. Now, my company has an agreement with the local
> MLS company that we get a nightly dump of their records so that we can
have
> a local copy of every listing in the middle Tennessee area.
>
> I am storing just the MLS number in a table for this realtor's website,
then
> looping over the OTHER database to get the detailed information. I'm fine
> with that in most cases but now I'm working on a search function which
needs
> to able to access both the foreign key MLS number in the realtor database
> AND the price and location information stored in the MLS database.
>
> So is it possible to join two totally different tables together somehow?
> They are on the same server and both are under my control if that helps.
>
> I'm using mySQL 4.01 on a Linux machine if that's important.
>
> I suspect the answer to this will be no, but I needed to ask anyway.
>
>  andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --//->
>
>
>



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236142
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF7 Standard to CF7 Enterprise Upgrade

[Jeff Fleitz]

Hey Mike,

We are considering this as well.  I have not been able to find an upgrade
path from CFMX7 Standard to Enterprise, have you?

On 3/24/06, Mike Fleming <[EMAIL PROTECTED]> wrote:
>
> Hello all.  I currently have CF Standard up and running on a production
> server.  The client downloaded the trial version got it running, then
> purchased the license and popped that on the server.  We are thinking of
> upgrading the server to CF7 Enterprise (mainly for the perfomance increase
> for cfdoucment).  Does anyone know if that would require a total reinstall
> of CF or if the newly purchased license key could be popped in and the new
> Enterprise features would then be enabled.  I'm guessing it would require
> a
> new install but I'd just like to know for sure before getting back to the
> client.
>
> Thanks,
> Mike
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236141
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Can I change query results?

[Robertson-Ravo, Neil (RX)]

Show us your query and what you want to do - mathematically.



-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 16:37
To: CF-Talk
Subject: Can I change query results?

I query a database and receive multiple rows of data. Now I need to do
some conditional math on one of the columns. I would do this in the
initial query but I can't.

I tried to see if I could do an update on the column with a cfquery on
the record set. Sadly, update doesn't work in Query of queries. Grrr

So, how does some one go about doing this?

--

Phil



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236140
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Can I change query results?

[Phill B]

I query a database and receive multiple rows of data. Now I need to do
some conditional math on one of the columns. I would do this in the
initial query but I can't.

I tried to see if I could do an update on the column with a cfquery on
the record set. Sadly, update doesn't work in Query of queries. Grrr

So, how does some one go about doing this?

--
Phil

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236139
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Robertson-Ravo, Neil (RX)]

It runs on CF? eh?



-Original Message-
From: Mark Holm [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 15:18
To: CF-Talk
Subject: Re: CF CMS recommendation

>Have you also looked into using Contribute?  For our www web site, we
>are probably going to use that rather than a packaged, or home-built,
>CMS.
>
>M!ke

That's what is being used now. I am not fond of it. It does not play well
with CF. (Which IMHO is funny since it runs on CF) Also, I often have to
clean up the html (not as bad as frontpage tho) and way too much inline CSS 

Mark



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236138
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Dave Watts]

> That's what is being used now. I am not fond of it. It does 
> not play well with CF. (Which IMHO is funny since it runs on 
> CF) Also, I often have to clean up the html (not as bad as 
> frontpage tho) and way too much inline CSS 

You do know you can control the use of inline CSS, right?

In my experience, the key to success with Contribute is strict control of
the templates, styles, etc that you can impose.

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!


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236137
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF CMS recommendation

[Mark Holm]

>Have you also looked into using Contribute?  For our www web site, we
>are probably going to use that rather than a packaged, or home-built,
>CMS.
>
>M!ke

That's what is being used now. I am not fond of it. It does not play well with 
CF. (Which IMHO is funny since it runs on CF) Also, I often have to clean up 
the html (not as bad as frontpage tho) and way too much inline CSS 

Mark

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236136
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Joining two different databases?

[Jim Wright]

If the dbs are on the same server, and the connected user has the
correct rights, you would just need to qualify the table names with
the db names...
SELECT  FROM db1.table1 INNER JOIN db2.table2 ON 

I believe the above will work for MySQL...in MS-SQL, you will have to
also include the table owner...
SELECT  FROM db1.dbo.table1 INNER JOIN db2.dbo.table2 ON 
or just
SELECT  FROM db1..table1 INNER JOIN db2..table2 ON 

I don't think you have to include the table owner in MySQL.

On 3/24/06, Andy Matthews <[EMAIL PROTECTED]> wrote:
> I'm building a site for a realtor who will be displaying real estate
> listings on their website. Now, my company has an agreement with the local
> MLS company that we get a nightly dump of their records so that we can have
> a local copy of every listing in the middle Tennessee area.
>
> I am storing just the MLS number in a table for this realtor's website, then
> looping over the OTHER database to get the detailed information. I'm fine
> with that in most cases but now I'm working on a search function which needs
> to able to access both the foreign key MLS number in the realtor database
> AND the price and location information stored in the MLS database.
>
> So is it possible to join two totally different tables together somehow?
> They are on the same server and both are under my control if that helps.
>
> I'm using mySQL 4.01 on a Linux machine if that's important.
>
> I suspect the answer to this will be no, but I needed to ask anyway.
>
>  andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --//->
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236135
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLDAP Question ?

[Dawson, Michael]

First, make sure your username is a domain account that has access to
view the IT OU in AD.  If that doesn't help, then remove the filter and
specify only the cn attribute.

Also, make sure you have specified a domain controller.  If you have a
different, working, CFLDAP tag, just use it and change the attributes,
one at a time, until you get it working.  It looks right, for me, but
there could be just a small detail that is breaking it.

I'm going to be off-line for about 4-5 hours.  If you have any other
problems, I can connect to an AD server later and try something else.

M!ke 

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 8:57 AM
To: CF-Talk
Subject: RE: CFLDAP Question ?

I am trying the following but it is not populating the .csv file ?
Instead I am getting the following error

Connection to LDAP Server failed  
 
The error occurred in cfldap10.cfm: line 11
 
9 : 






 

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 14:19
To: CF-Talk
Subject: RE: CFLDAP Question ?

I may not get all the attributes right, since I'm not connected to a
server right now...



That code should get you the records from AD.  Since proxyAddresses is a
multi-value attribute, you will need to handle those accordingly.  By
default, they will be comma-separated, if there are more than one value.

The filter says: Any object that is a User AND also has an email
address.  You may need to adjust this for your needs.

Then, loop over the ldap query and create your csv file using CFFILE.

There were some recent cf-talk posts on using java to save data to
files, in case your data is very large.

M!ke

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 6:02 AM
To: CF-Talk
Subject: RE: CFLDAP Question ?

Hi Mike

Going to use a different approach 

What code would I need to dump the following information from Active
Directory (CN, mailnickname, ProxyAddressses) to a .CSV file for all
users in a certain OU?

Any ideas?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236134
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

coldfusion built-in security framework: get a list of all roles for an user

[wolf2k5]

Hi all,

I'm using the ColdFusion built-in security framework
(cflogin/cflogout) for a small application.

I can check if an user has a role by using the isUserInRole function.

Is there any way to get a list of all roles for an user?

Thanks.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236133
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLDAP Question ?

[Ian Vaughan]

I am trying the following but it is not populating the .csv file ?
Instead I am getting the following error

Connection to LDAP Server failed  
 
The error occurred in cfldap10.cfm: line 11
 
9 : 



 






 

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 14:19
To: CF-Talk
Subject: RE: CFLDAP Question ?

I may not get all the attributes right, since I'm not connected to a
server right now...



That code should get you the records from AD.  Since proxyAddresses is a
multi-value attribute, you will need to handle those accordingly.  By
default, they will be comma-separated, if there are more than one value.

The filter says: Any object that is a User AND also has an email
address.  You may need to adjust this for your needs.

Then, loop over the ldap query and create your csv file using CFFILE.

There were some recent cf-talk posts on using java to save data to
files, in case your data is very large.

M!ke

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]
Sent: Friday, March 24, 2006 6:02 AM
To: CF-Talk
Subject: RE: CFLDAP Question ?

Hi Mike

Going to use a different approach 

What code would I need to dump the following information from Active
Directory (CN, mailnickname, ProxyAddressses) to a .CSV file for all
users in a certain OU?

Any ideas?



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236132
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Robertson-Ravo, Neil (RX)]

Contribute itself is not a true CMS - in terms of features anyway!

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 14:20
To: CF-Talk
Subject: RE: CF CMS recommendation

Have you also looked into using Contribute?  For our www web site, we
are probably going to use that rather than a packaged, or home-built,
CMS.

M!ke 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236131
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF7 Standard to CF7 Enterprise Upgrade

[Dawson, Michael]

All you *need* to do is pop in the new license key.  That will activate
the Ent-level features.  You probably won't even need to restart the CF
services, but I would, just because.

However, if you want to use separate instances, you will need to
unistall, then re-install in the multi-instance mode.

M!ke 

-Original Message-
From: Mike Fleming [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 8:05 AM
To: CF-Talk
Subject: CF7 Standard to CF7 Enterprise Upgrade

Hello all.  I currently have CF Standard up and running on a production
server.  The client downloaded the trial version got it running, then
purchased the license and popped that on the server.  We are thinking of
upgrading the server to CF7 Enterprise (mainly for the perfomance
increase for cfdoucment).  Does anyone know if that would require a
total reinstall of CF or if the newly purchased license key could be
popped in and the new Enterprise features would then be enabled.  I'm
guessing it would require a new install but I'd just like to know for
sure before getting back to the client.
 
Thanks,
Mike

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236130
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Dawson, Michael]

Have you also looked into using Contribute?  For our www web site, we
are probably going to use that rather than a packaged, or home-built,
CMS.

M!ke 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236129
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Robertson-Ravo, Neil (RX)]

If your business rule/model is that you must use CF then you are limited.
If want a best of breed CMS the you really need to look outside of the CF
sphere - this in itself does not mean you have to move away from CF as lots
of the enterprise tools allow you to use any and all technology you have.





-Original Message-
From: Raven Technology [mailto:[EMAIL PROTECTED] 
Sent: 24 March 2006 12:52
To: CF-Talk
Subject: Re: CF CMS recommendation

I use CommonSpot from PaperThin.  This is CF CMS systems.  Can be a little 
pricy.  Software starts at $20,000

Steve LaBadie
Raven Technology
http://www.ravenpcs.com
[EMAIL PROTECTED]
- Original Message - 
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, March 24, 2006 7:31 AM
Subject: RE: CF CMS recommendation


> It is also pretty bad on the usability side of things.  Loads of features
> though.
>
>
>
> -Original Message-
> From: Dawson, Michael [mailto:[EMAIL PROTECTED]
> Sent: 23 March 2006 19:18
> To: CF-Talk
> Subject: RE: CF CMS recommendation
>
> Hell no, it aint!  I must have missed the budget part.  Sorr!!!
>
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 23, 2006 1:13 PM
> To: CF-Talk
> Subject: Re: CF CMS recommendation
>
> Um, unless I am mistaken, PaperThin isn't for those with a small (or
> even medium) budget
>
> Dawson, Michael wrote:
>> Check out www.paperthin.com.
>>
>> M!ke
>>
>> -Original Message-
>> From: Mark Holm [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, March 23, 2006 12:53 PM
>> To: CF-Talk
>> Subject: CF CMS recommendation
>>
>> Hi,
>> I have been looking over CF CMS primarily Ektron, FarCry, Emojo's
>> Affino CMS and HotBanana. However, it is one thing to look at a demo
>> another thing to really work with it.
>> My needs are simple... a CF based CMS, easy editing for no tech users
>> and ability to integrate custom CF apps into the CMS for the site. In
>> addition, my budget is not big (small org)
>>
>> Can anybody give me some recommendations based on real world
>> experience with these CMS or perhaps suggest another CF CMS
> alternative?
>>
>> TIA
>> Mark Holm
>>
>>
>
>
>
>
>
> 



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236128
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLDAP Question ?

[Dawson, Michael]

I may not get all the attributes right, since I'm not connected to a
server right now...



That code should get you the records from AD.  Since proxyAddresses is a
multi-value attribute, you will need to handle those accordingly.  By
default, they will be comma-separated, if there are more than one value.

The filter says: Any object that is a User AND also has an email
address.  You may need to adjust this for your needs.

Then, loop over the ldap query and create your csv file using CFFILE.

There were some recent cf-talk posts on using java to save data to
files, in case your data is very large.

M!ke

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED] 
Sent: Friday, March 24, 2006 6:02 AM
To: CF-Talk
Subject: RE: CFLDAP Question ?

Hi Mike

Going to use a different approach 

What code would I need to dump the following information from Active
Directory (CN, mailnickname, ProxyAddressses) to a .CSV file for all
users in a certain OU?

Any ideas?

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236127
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Joining two different databases?

[Andy Matthews]

I'm building a site for a realtor who will be displaying real estate
listings on their website. Now, my company has an agreement with the local
MLS company that we get a nightly dump of their records so that we can have
a local copy of every listing in the middle Tennessee area.

I am storing just the MLS number in a table for this realtor's website, then
looping over the OTHER database to get the detailed information. I'm fine
with that in most cases but now I'm working on a search function which needs
to able to access both the foreign key MLS number in the realtor database
AND the price and location information stored in the MLS database.

So is it possible to join two totally different tables together somehow?
They are on the same server and both are under my control if that helps.

I'm using mySQL 4.01 on a Linux machine if that's important.

I suspect the answer to this will be no, but I needed to ask anyway.




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236126
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: cfhttp question.

[Andy Matthews]

If they're on the same server why not just cfinclude the form?



-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 23, 2006 3:39 PM
To: CF-Talk
Subject: RE: cfhttp question.


> I've been messing around with cfhttp to grab content locally
> to get the dynamic content and write it to a static page.
>
> What I've been trying to do is to find out if there is a way
> to get cfhttp to save the page without parsing the actual cfm code..
>
> Basicly, the page includes a simple cfmail form. At the
> beginning, it checks to see if the form was submitted, if
> not, is will display the form. However, when I crab the page
> via cfhttp, it removes the actual cfml code and only the form
> is contained in the file so it won't work.
>
> Is there anyway to put something like a start and end comment
> into the actual page so that cfhttp will parse everything but
> still leave the code intact between the start and end tags?

CFHTTP doesn't parse your CF code. It acts just like a browser - it requests
a URL, and gives you whatever is returned from that URL. If you use CFHTTP
to fetch a CF URL, the CF server will process the request just like if you'd
made it from a browser. So, the short answer is, no, you can't get CFHTTP to
behave the way you want it to.

If you want to be able to fetch the CF code, and you're running both scripts
on the same server, use CFFILE instead of CFHTTP. If the scripts are on
different servers, you're out of luck unless you control both servers - in
that case, you could write one program to read another using CFFILE, then
call that program from the other server 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!




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236125
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CF7 Standard to CF7 Enterprise Upgrade

[Mike Fleming]

Hello all.  I currently have CF Standard up and running on a production
server.  The client downloaded the trial version got it running, then
purchased the license and popped that on the server.  We are thinking of
upgrading the server to CF7 Enterprise (mainly for the perfomance increase
for cfdoucment).  Does anyone know if that would require a total reinstall
of CF or if the newly purchased license key could be popped in and the new
Enterprise features would then be enabled.  I'm guessing it would require a
new install but I'd just like to know for sure before getting back to the
client.
 
Thanks,
Mike




~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236124
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF CMS recommendation

[Michael Traher]

one of the difficulties in choosing a cms is to get your head round what
your (or your clients) real requirements are.

You really need to play with some to find out if it suits you.

The bad news is that this represents a huge time investment.

My approach was to start with a fairly simple CMS that I could get up and
running quickly and then let this experience focus the requirements list -
maybe hilighting features you need that were not initailly obvious.


--
Mike T
Blog http://www.socialpoints.com/


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236123
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Installing MX7 and CF5 on same server (apache + Windows 2000)

[Daniel McLaughlin]

Here is a link to instructions on how to get CF5 and MX7 cohabiting on the same 
server under Apache and Windows 2000.

http://danmacs.blogspot.com/2006/03/deploying-coldfusion-5-and-mx7-on-same.html";
 Deploy CFMX7 and CF5 on same server

hope this is of some use to someone.

Dan

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236122
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF CMS recommendation

[Raven Technology]

I use CommonSpot from PaperThin.  This is CF CMS systems.  Can be a little 
pricy.  Software starts at $20,000

Steve LaBadie
Raven Technology
http://www.ravenpcs.com
[EMAIL PROTECTED]
- Original Message - 
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, March 24, 2006 7:31 AM
Subject: RE: CF CMS recommendation


> It is also pretty bad on the usability side of things.  Loads of features
> though.
>
>
>
> -Original Message-
> From: Dawson, Michael [mailto:[EMAIL PROTECTED]
> Sent: 23 March 2006 19:18
> To: CF-Talk
> Subject: RE: CF CMS recommendation
>
> Hell no, it aint!  I must have missed the budget part.  Sorr!!!
>
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 23, 2006 1:13 PM
> To: CF-Talk
> Subject: Re: CF CMS recommendation
>
> Um, unless I am mistaken, PaperThin isn't for those with a small (or
> even medium) budget
>
> Dawson, Michael wrote:
>> Check out www.paperthin.com.
>>
>> M!ke
>>
>> -Original Message-
>> From: Mark Holm [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, March 23, 2006 12:53 PM
>> To: CF-Talk
>> Subject: CF CMS recommendation
>>
>> Hi,
>> I have been looking over CF CMS primarily Ektron, FarCry, Emojo's
>> Affino CMS and HotBanana. However, it is one thing to look at a demo
>> another thing to really work with it.
>> My needs are simple... a CF based CMS, easy editing for no tech users
>> and ability to integrate custom CF apps into the CMS for the site. In
>> addition, my budget is not big (small org)
>>
>> Can anybody give me some recommendations based on real world
>> experience with these CMS or perhaps suggest another CF CMS
> alternative?
>>
>> TIA
>> Mark Holm
>>
>>
>
>
>
>
>
> 

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236121
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Robertson-Ravo, Neil (RX)]

It is also pretty bad on the usability side of things.  Loads of features
though.



-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: 23 March 2006 19:18
To: CF-Talk
Subject: RE: CF CMS recommendation

Hell no, it aint!  I must have missed the budget part.  Sorr!!! 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 23, 2006 1:13 PM
To: CF-Talk
Subject: Re: CF CMS recommendation

Um, unless I am mistaken, PaperThin isn't for those with a small (or
even medium) budget

Dawson, Michael wrote:
> Check out www.paperthin.com.
> 
> M!ke
> 
> -Original Message-
> From: Mark Holm [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 23, 2006 12:53 PM
> To: CF-Talk
> Subject: CF CMS recommendation
> 
> Hi,
> I have been looking over CF CMS primarily Ektron, FarCry, Emojo's 
> Affino CMS and HotBanana. However, it is one thing to look at a demo 
> another thing to really work with it.
> My needs are simple... a CF based CMS, easy editing for no tech users 
> and ability to integrate custom CF apps into the CMS for the site. In 
> addition, my budget is not big (small org)
> 
> Can anybody give me some recommendations based on real world 
> experience with these CMS or perhaps suggest another CF CMS
alternative?
> 
> TIA
> Mark Holm
> 
> 





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236120
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFLDAP Question ?

[Ian Vaughan]

Hi Mike

Going to use a different approach 

What code would I need to dump the following information from Active
Directory (CN, mailnickname, ProxyAddressses) to a .CSV file for all
users in a certain OU?

Any ideas?


~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236119
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: cflogin and load balancing

[wolf2k5]

On 3/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
> If you have the username and password, why don't you log him in
> yourself?

What do you mean?

Thanks.

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236118
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF CMS recommendation

[Hugo Ahlenius]

| Um.. FarCry 3.0 [1] was released in November 2005.  We're just about 
| to release 3.0.1, followed by a webskin for Mollio [2] (a template 
| resource we released to the public at the webDU [3] conference
| 1-March)

Oh. I have missed this - and the FarCry web-site all mentions betas...
The web-site doesn't really mention the requirements for FarCry, btw --
will it run on BD now? Is 6.1 still ok, or is CFMX 7 a requirement?

/H.
###

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236117
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF CMS recommendation

[Geoff Bowers]

On 3/24/06, Hugo Ahlenius <[EMAIL PROTECTED]> wrote:
> | FarCry 3.0 is aimed at revising FarCry's old "techie" UI to a much
> | more appealing "Glamourous" UI:
> | http://docs.farcrycms.org:8080/confluence/display/FCDEV30/Admin+UI
> |
> | It's probably fair to say the solution is more on the complex side to
> | set up, but its designed for non-technical users to operate.
>
> So what is the realistic time frame for 3.0?
> ###

Um.. FarCry 3.0 [1] was released in November 2005.  We're just about
to release 3.0.1, followed by a webskin for Mollio [2] (a template
resource we released to the public at the webDU [3] conference
1-March)

-- geoff
http://www.daemon.com.au/

[1] http://www.farcrycms.org/
[2] http://www.mollio.org/
[3] http://www.webdu.com.au/

~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236116
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54