Re: Need Book Recommendation

[Massimo Foti]

> I have the CF5 Web App Kit, and have looked at the CFMX WAK but it
> appears to be mostly the same content as the CF5. So I've started
> considering the Advanced CFMX WAK or the Certification Study Guide.
> Can anyone recommend either, or another that would be appropriate for
> studying CFMX beyond the basics.

Both are excellent. I would consider this one as well:
http://www.oreilly.com/catalog/coldfusion2/

Check the TOC and sample chapter to get a better idea


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/




-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.3.0 - Release Date: 11/13/04


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184248
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

OT: ERD for MySQL

[Mark Drew]

Does anybody use any fornt ends to mysql that allow you to do ERD's in
the way the MS SQL Enterprise Manager works?

Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data
Studio et al), but something that I can visually design the tables and
relationships with .

If its for OS X the better!
-- 
Mark Drew

coldfusion and cfeclipse blogged:
http://cybersonic.blogspot.com/
39° 31' 58" , 0° 25' 53"
39.533 , -0.4316
4 Gmails up for grabs! Stop me and grab one.

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184249
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: ERD for MySQL

[Massimo Foti]

> Does anybody use any fornt ends to mysql that allow you to do ERD's in
> the way the MS SQL Enterprise Manager works?
> 
> Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data
> Studio et al), but something that I can visually design the tables and
> relationships with .

You could try Case Studio:

http://www.casestudio.com/


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.3.0 - Release Date: 11/13/04


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184250
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: OT: ERD for MySQL

[Stephen Moretti (cfmaster)]

Mark Drew wrote:

>Does anybody use any fornt ends to mysql that allow you to do ERD's in
>the way the MS SQL Enterprise Manager works?
>
>Any ideas? I am NOT looking just for a GUI (phpmyadmin, Aqua Data
>Studio et al), but something that I can visually design the tables and
>relationships with .
>
>If its for OS X the better!
>  
>

I use Charonware's CASE Studio. (http://www.casestudio.com)
Its not the worlds greatest ERD modelling tool, but for your money it 
does the job nicely and has reverse engineering tools as a bonus.

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184251
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: LSDateFormat & Locale's

[Andy Mcshane]

> Andy Mcshane wrote:
> > I am using the standard SQL datetime datatypes, The way I wrote it 
> above is just to simply demonstrate the way the SQL stores the date. I 
> handle all of my database 
> access using stored procedures so I use CFStorerdProc & CFProcParam so 
> I 
> what I actually try to pass out to SQL is this,
> 
> no, that's not how sql server stores dates. refer to your BoL.
> 
> >value=#lsdateformat(mydate, "DD MMM ")#
> 
> you've made up your own date format. in i18n work it's ALWAYS a good 
> rule to use standard date formats (standard as in java style), which 
> MX 
> also uses (for de_DE locale):
> 
> "full" Samstag, 13. November 2004
> "long" 13. November 2004
> "medium" 13.11.2004
> "short"  13.11.04
> 
> these should be understandable to users & easily parsed (and if not, 
> you 
> can always blame sun). making up your own date formats requires actual 
> 
> locale research & for me, too much programming. and if you're doing 
> this 
> w/out doing any locale research, well

OK, I am getting a little confused now, let me start again. I run a query that 
returns a date field from SQL, the format of that date is as follows;

2004-12-01 00:00:00.0 - returned from SQL

Now when I want to display that date on the page I use the following code;

#lsdateformat(MyQuery.MyDate, 'DD MMM ')#

This formats the date correctly as '01 Dez 2004' and displays in a text form 
field which the user can change.

The problem occurrs when I try to then manipulate that date field. The date 
gets formatted as I want it without any error when I format the original date 
from my SQL query but if I try to do anything else to that formatted date 
Coldfusion states that it is an invalid date format although I am using exactly 
the same code i.e.

#lsdateformat(MyQuery.MyDate, 'DD.MMM.')#

This where it is confusing as the LSDateFormat works the first time but then 
reports the date that it just formatted as now invalid! Maybe it's a bug .?

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184252
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: LSDateFormat & Locale's

[Paul Hastings]

Andy Mcshane wrote:

> This where it is confusing as the LSDateFormat works the first time but then 
> reports the date that it just formatted as now invalid! Maybe it's a bug 
> .?

i'm not sure what you're doing. you *seem* to be re-formatting the date 
you just formatted, is that what you're saying? if that's the case (and 
you're still making up your own date format) then what you have is a 
date string that's not parseable--as it's not a datetime object any 
longer you need to parse it back to one, ok? if this isn't the case & 
what you're doing is formatting the next row's date in that query then 
you probably have some bad data.

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184253
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: Blackstone to provide built-in "Flash Remoting" type capabilities?

[Rick Root]

Rick Faircloth wrote:
> 
> I just had a look at Flex and Flex "Explorer" demo...looks intriguing.
> And the coding is pretty straight-forward.
> 
> Any idea what kind of price Flex has (or will have?)

$12,000 is the list price I believe

And, you'll still pretty much have to learn Actionscript if you want to 
really do anything.

  - Rick

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184254
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: Blackstone to provide built-in "Flash Remoting" type capabilities?

[Rick Root]

Stacy Young wrote:
> Unless you have flash skills to leverage already I'd suggest holding off
> until other technologies start becoming more accessible. (flex or
> otherwise) 

I don't know if I would agree with that entirely.  I had never used 
Flash before taking the 1 day pre-conference training session last year 
on building RIA's with Flash.  I thought the transition was pretty easy.

I'd like to be able to use Flex, but even with our substatial volume 
discount, Flex is still very expensive.

  - Rick

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184255
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: Blackstone to provide built-in "Flash Remoting" type capabilities?

[Rick Root]

Rick Faircloth wrote:
> I just answered my own question about Flex pricing...$12,000...yikes!
> That much just for developing RIA's?

BIG ria's, in particular.

Jeff Tappan suggested in one of his sessions that he quotes jobs both 
ways... one large rich internet application developed in the Flash 
authoring environment was quoted at 400 hours, while the exact same 
application quoted using Flex was only 100 hours.  The client decided to 
go the Flex route and purchase a license for Flex.

Jeff Tappan has clients that will do that though.  I don't :)  So unless 
I can talk my boss here at Duke into getting Flex, I'll be sticking to 
regular old Flash RIAs for work and for freelancing.

  - Rick

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184256
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: Blackstone to provide built-in "Flash Remoting" type capabilities?

[Rick Faircloth]

>From the looks of what's out there...

Flash MX 2004, Flash MX 2004 Professional, and Flex (for LARGE budgets),
I'd say MM needs to go ahead and develop Flash MX 2004 Professional
as a tool to do what Flex does and break it off from its Flash Animation
moorings.
It seems to be doing almost the same thing on the RIA / data connection
side,
which is the only part I'm interested in...

BUT, the price needs to be about $11,500 less.  I run my own server and
don't
want to have to host apps outside to develop for and run in Flex...

I'm sure it's just my ignorance, but why does CF cost *only* $1,200 as a
server
and language and Flex costs $12,000?!

What makes the Flex server for RIA apps and its development capabilities
worth
10 times as much as Cold Fusion...I don't get it...How about selling Flex on
a
"per developer" basis...$500 per developer...so a sole developer, like
myself,
gets the business benefit from what one developer can develop...and a team
of 24 developers pay $12,000 because they can, supposedly, develop 24 times
better
and faster and get 24 times the financial benefit.  Per developer license,
instead of
per processor...

Put in some sort of (no rock-throwing, please...I'm recovering from a torn
rotator cuff / broken arm injury)
"digital rights management" for installations on x number of machines or
something...

Rick


>  -Original Message-
>  From: Rick Root [mailto:[EMAIL PROTECTED]
>  Sent: Monday, November 15, 2004 7:48 AM
>  To: CF-Talk
>  Subject: Re: Blackstone to provide built-in "Flash Remoting" type
>  capabilities?
>
>
>  Rick Faircloth wrote:
>  >
>  > I just had a look at Flex and Flex "Explorer" demo...looks
>  intriguing.
>  > And the coding is pretty straight-forward.
>  >
>  > Any idea what kind of price Flex has (or will have?)
>
>  $12,000 is the list price I believe
>
>  And, you'll still pretty much have to learn Actionscript if
>  you want to
>  really do anything.
>
>- Rick
>
>  ~
>  |
>  Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
>  http://www.cfhosting.net
>
>  Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184254
>  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=708.628.4
>  Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
>
>  --
>  No virus found in this incoming message.
>  Checked by AVG Anti-Virus.
>  Version: 7.0.290 / Virus Database: 265.3.0 - Release Date: 11/13/2004
>
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.290 / Virus Database: 265.3.0 - Release Date: 11/13/2004


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184257
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

cflogin

[Chris Doughty]

Hi,
 
I am using the cflogin tag to control user authentication and session
timeout but I am finding that the cflogin structure always exists.
 
My code in the fbx_settings page is as follows 
 

   
   
   
   
   Run query to check cflogin name and password
   

 
Authentication will always be as a result of a logon form being
submitted so i could test for form.j_username but this would be a work
around.
 
Has anyone else had any problems with this or any thoughts on what i am
doing wrong.
 
PS I am aware that an idle timeout of 5 seconds is a little harsh, this
is only whilst i test!
 
 
Chris Doughty
Business Analyst
Priority Pass
Tel +44 (0) 20 8253 5017
Fax +44 (0) 20 8688 6191
www.prioritypass.com
---
 
This e-mail may contain privileged and confidential information and/or
copyright material and is intended for the use of the addressee only. If
you
receive this e-mail by mistake please advise the sender immediately by
using
the reply facility in your e-mail software and delete this e-mail from
your
computer system. You may not deliver, copy or disclose its contents to
anyone else. Any unauthorised use may be unlawful. Any views expressed
in
this e-mail are those of the individual sender and may not necessarily
reflect the views of Priority Pass. 
 
 
 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184258
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

[Tangorre, Michael]

> From: Chris Doughty [mailto:[EMAIL PROTECTED] 
> I am using the cflogin tag to control user authentication and 
> session timeout but I am finding that the cflogin structure 
> always exists.

What is the loginstorage attribute set to in your cfapplication tag?

Michael T. Tangorre  

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184259
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

[Chris Doughty]

>> From: Chris Doughty [mailto:[EMAIL PROTECTED] 
>> I am using the cflogin tag to control user authentication and 
>> session timeout but I am finding that the cflogin structure 
>> always exists.
>
>What is the loginstorage attribute set to in your cfapplication tag?
>
>Michael T. Tangorre

I have left it to the default and also tried setting as 'session'. 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184260
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

[Raymond Camden]

"Authentication will always be as a result of a logon form being
submitted so i could test for form.j_username but this would be a work
around."

This isn't exactly true. It can come also come from two other places.
>From the docs:

# A request that uses CFHTTP Basic authentication, and therefore
includes an Authorization header with the username and password.
# A request that uses NTLM or Digest authentication. In this case, the
username and password are hashed using a one-way algorithm in the
Authorization header; ColdFusion gets the username from the web server
and sets the cflogin.password value to the empty string.

Do either of these apply to you?


On Mon, 15 Nov 2004 13:18:38 -, Chris Doughty
<[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I am using the cflogin tag to control user authentication and session
> timeout but I am finding that the cflogin structure always exists.
> 
> My code in the fbx_settings page is as follows
> 
> 
>
>
>
>
>Run query to check cflogin name and password
>
> 
> 
> Authentication will always be as a result of a logon form being
> submitted so i could test for form.j_username but this would be a work
> around.
> 
> Has anyone else had any problems with this or any thoughts on what i am
> doing wrong.
> 
> PS I am aware that an idle timeout of 5 seconds is a little harsh, this
> is only whilst i test!
> 
> Chris Doughty
> Business Analyst
> Priority Pass
> Tel +44 (0) 20 8253 5017
> Fax +44 (0) 20 8688 6191
> www.prioritypass.com
> ---
> 
> This e-mail may contain privileged and confidential information and/or
> copyright material and is intended for the use of the addressee only. If
> you
> receive this e-mail by mistake please advise the sender immediately by
> using
> the reply facility in your e-mail software and delete this e-mail from
> your
> computer system. You may not deliver, copy or disclose its contents to
> anyone else. Any unauthorised use may be unlawful. Any views expressed
> in
> this e-mail are those of the individual sender and may not necessarily
> reflect the views of Priority Pass.
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184261
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: cfc - cffunction question

[Raymond Camden]

Let me start by saying I am NOT an OO expert. PLEASE remember that. :)

To me, this doesn't break encapsulation because the CFCs are all in
the same package, so it makes sense that they would use one another.

As for flip flopping, I hear ya. Every other app I make using CFCs
does things a bit differently. You can see this clearly if you look at
my DRK apps. I'm still trying to find the best way myself.


On Sun, 14 Nov 2004 19:14:56 -0600, Dawson, Michael <[EMAIL PROTECTED]> wrote:
> Ray, doesn't this break encapsulation by putting the cfinvoke call
> _inside_ another component?  I'm still trying to learn the OO way, and I
> keep flip-flopping about best-practices and/or easier programming.
> 
> M!ke
> 
> 
> 
> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> Sent: Saturday, November 13, 2004 5:55 PM
> To: CF-Talk
> Subject: Re: cfc - cffunction question
> 
> But (normally), extends should only be used to create a "Is A"
> releationship. Settings doesn't match this rule. Just in case it wasn't
> too obvious for others, here is a super simple example of what I'm
> talking about. Please note I did not include attributes like
> output=false, hint, var statements, etc, just to make things tighter:
> 
> settings.cfc:
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> foo.cfc:
> 
> 
>  returnVariable="variables.settings">
> 
> 
> 
> select whatever
> 
> 
> 
> 
> 
> 
> What's nice then is that your Application.cfm can use the same cfinvoke
> statement to get global settings, although it would use
> returnVariable="application.settings". So now both your CFCs and your
> outside code all use the same method to get their settings.
> 
> On Sat, 13 Nov 2004 17:47:57 +0200, Murat Demirci <[EMAIL PROTECTED]>
> wrote:
> > For your specific situation you can use  in your
> > cffunction(s) or develop a global component which creates
> > variables.settings internally and extend it.
> >
> > Murat.
> >
> >
> >
> > > -Original Message-
> > > From: Charles Heizer [mailto:[EMAIL PROTECTED]
> > > Sent: Saturday, November 13, 2004 2:12 AM
> > > To: CF-Talk
> > > Subject: cfc - cffunction question
> > >
> > > Hello,
> > > I was wondering if it was possible to do a cfinclude in a cffunction
> 
> > > tag?
> > >
> > > I have a globals.cfm file which has site wide variables set and I
> > > want to reference them with out using cfinvokeargument tag.
> > >
> > > I hope this make sense,
> > > Thanks a bunch,
> > > - Charles
> > >
> > >
> > >
> >
> >
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184262
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

[Chris Doughty]

>"Authentication will always be as a result of a logon form being
>submitted so i could test for form.j_username but this would be a work
>around."
>
>This isn't exactly true. It can come also come from two other places.
>From the docs:
>
># A request that uses CFHTTP Basic authentication, and therefore
>includes an Authorization header with the username and password.
># A request that uses NTLM or Digest authentication. In this case, the
>username and password are hashed using a one-way algorithm in the
>Authorization header; ColdFusion gets the username from the web server
>and sets the cflogin.password value to the empty string.
>
>Do either of these apply to you?
>
>
>On Mon, 15 Nov 2004 13:18:38 -, Chris Doughty
><[EMAIL PROTECTED]> wrote:
>>

What I meant was that within my application authorisation will not always from 
a logon form being submitted not a general this is how authorisation in cf 
works.

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184263
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

CFMAIL ISSUE

[Ciliotta, Mario]

HI,

I was wondering if anyone has had any issues with email address that has an
apostrophe in it:   robert.o'[EMAIL PROTECTED]

When I try to send an email out using this address - CF spits out an error
message stating that the "TO" is invalid.  

I am using CFMX 6.0 - yes still trying to get my place to upgrade.

Mario




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184264
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: CFMail: Query attribute vs. cflooping

[Matt Robertson]

A loop is the only way to do the validation in one step.

If the list is static, validate it once in a special maintenance
routine in advance of your planned multi-use.


-- 
--Matt Robertson--
President, Janitor
MSB Designs, Inc.
mysecretbase.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184265
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

[Raymond Camden]

Err, I'm confused. You said that it seems like CFLOGIN always existed
when you tested your app. Even when you didn't submit the form. So, I
shared that doc to point out that you may be triggering another way
for the cflogin scope to exist.

Of course, you can make this easier by just changing your code to say,

if isDefined("form.logon") and isDefined("form.password")


On Mon, 15 Nov 2004 09:27:06 -0400, Chris Doughty
<[EMAIL PROTECTED]> wrote:
> 
> 
> >"Authentication will always be as a result of a logon form being
> >submitted so i could test for form.j_username but this would be a work
> >around."
> >
> >This isn't exactly true. It can come also come from two other places.
> >From the docs:
> >
> ># A request that uses CFHTTP Basic authentication, and therefore
> >includes an Authorization header with the username and password.
> ># A request that uses NTLM or Digest authentication. In this case, the
> >username and password are hashed using a one-way algorithm in the
> >Authorization header; ColdFusion gets the username from the web server
> >and sets the cflogin.password value to the empty string.
> >
> >Do either of these apply to you?
> >
> >
> >On Mon, 15 Nov 2004 13:18:38 -, Chris Doughty
> ><[EMAIL PROTECTED]> wrote:
> >>
> 
> What I meant was that within my application authorisation will not always 
> from a logon form being submitted not a general this is how authorisation in 
> cf works.
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184266
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: CFMAIL ISSUE

[Robertson-Ravo, Neil (RX)]

Hmmm,we use email addresses with apostrophes in them and they are
valid...they do not get any errors?!


-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED] 
Sent: 15 November 2004 14:43
To: CF-Talk
Subject: CFMAIL ISSUE

HI,

I was wondering if anyone has had any issues with email address that has an
apostrophe in it:   robert.o'[EMAIL PROTECTED]

When I try to send an email out using this address - CF spits out an error
message stating that the "TO" is invalid.  

I am using CFMX 6.0 - yes still trying to get my place to upgrade.

Mario






~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184267
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

Find first letter

[Robert Orlini]

I need to output a list of names alphabetically via the field "employee_lname" 
(last name).

What's the code that can check the first letter of the field employee_lname?

Thanks.

Robert O.
HWW

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184268
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: Find first letter

[Ben Forta]

Left(employee_lname, 1)


-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 10:03 AM
To: CF-Talk
Subject: Find first letter

I need to output a list of names alphabetically via the field
"employee_lname" (last name).

What's the code that can check the first letter of the field employee_lname?

Thanks.

Robert O.
HWW



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184269
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: CFMail: Query attribute vs. cflooping

[Dawson, Michael]

I just sent 1,400+ messages using cfloop > cfmail this morning.  This
took only a second or two to spool all of these.  This is also on a
pretty slow server with one bad processor out of two. 

I don't see that you will have any problems if your hardware is capable
of this.

M!ke

-Original Message-
From: Marcus Whitworth [mailto:[EMAIL PROTECTED] 
Sent: Sunday, November 14, 2004 10:44 PM
To: CF-Talk
Subject: CFMail: Query attribute vs. cflooping

Hi,

Does anyone know how much more efficient the cfmail query attribute is
for looping over a large recordset of recipients, as opposed to
embedding a cfmail tag within a cfloop tag?

I currently use the Query attribute for sending out newsletters, but
would like to validate each email against a regex, due to cfmail's habit
of throwing an error if it finds an incorrectly formatted address. I can
do this using cfloop > cfmail, but don't want to if it really slows down
or puts too much load on the system.

Any thoughts?

thanks,
Marcus.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184270
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: cfc - cffunction question

[Deanna Schneider]

I'm not an OO expert, either (hardly!). But, in our case, we have lots of 
apps that all use the same basic DSN configurations, but each "stand alone" 
in terms of application structure. So, I'm using the approach of having a 
settings.cfc type thing (that can either use the default configurations or 
override them), and then passing that object to my local application objects 
in the init() call. I still get the advantage of only having one place per 
app where I set the settings.cfc info (usually in the app scope in my 
Application.cfm). So, if it changes I can change it in one place. AND, I can 
use it "outside the package" so to speak.

I'm still just learning all this, too. But, this seems to be working well 
for me, so far.

Example (stripping out all the cfif stuff):
In Application.cfm

// create the settings object with the default settings
application.settings = createObject("component", "cfc.ces.DBData").init();

// create the survey object, passing in the settings object
session.thisSurvey = createObject("component", 
"ces.apps.360Review.cfc.survey").init(application.settings);


In survey.cfc


...






- Original Message - 
From: "Raymond Camden" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 8:21 AM
Subject: Re: cfc - cffunction question


> Let me start by saying I am NOT an OO expert. PLEASE remember that. :)
>
> To me, this doesn't break encapsulation because the CFCs are all in
> the same package, so it makes sense that they would use one another.
>
> As for flip flopping, I hear ya. Every other app I make using CFCs
> does things a bit differently. You can see this clearly if you look at
> my DRK apps. I'm still trying to find the best way myself.
>
>
> On Sun, 14 Nov 2004 19:14:56 -0600, Dawson, Michael <[EMAIL PROTECTED]> 
> wrote:
>> Ray, doesn't this break encapsulation by putting the cfinvoke call
>> _inside_ another component?  I'm still trying to learn the OO way, and I
>> keep flip-flopping about best-practices and/or easier programming.
>>
>> M!ke
>>
>>
>>
>> -Original Message-
>> From: Raymond Camden [mailto:[EMAIL PROTECTED]
>> Sent: Saturday, November 13, 2004 5:55 PM
>> To: CF-Talk
>> Subject: Re: cfc - cffunction question
>>
>> But (normally), extends should only be used to create a "Is A"
>> releationship. Settings doesn't match this rule. Just in case it wasn't
>> too obvious for others, here is a super simple example of what I'm
>> talking about. Please note I did not include attributes like
>> output=false, hint, var statements, etc, just to make things tighter:
>>
>> settings.cfc:
>> 
>>
>> 
>> 
>> 
>> 
>> 
>> 
>> 
>>
>> 
>>
>> foo.cfc:
>> 
>>
>> > returnVariable="variables.settings">
>>
>> 
>> 
>> select whatever
>> 
>> 
>> 
>>
>> 
>>
>> What's nice then is that your Application.cfm can use the same cfinvoke
>> statement to get global settings, although it would use
>> returnVariable="application.settings". So now both your CFCs and your
>> outside code all use the same method to get their settings.
>>
>> On Sat, 13 Nov 2004 17:47:57 +0200, Murat Demirci <[EMAIL PROTECTED]>
>> wrote:
>> > For your specific situation you can use  in your
>> > cffunction(s) or develop a global component which creates
>> > variables.settings internally and extend it.
>> >
>> > Murat.
>> >
>> >
>> >
>> > > -Original Message-
>> > > From: Charles Heizer [mailto:[EMAIL PROTECTED]
>> > > Sent: Saturday, November 13, 2004 2:12 AM
>> > > To: CF-Talk
>> > > Subject: cfc - cffunction question
>> > >
>> > > Hello,
>> > > I was wondering if it was possible to do a cfinclude in a cffunction
>>
>> > > tag?
>> > >
>> > > I have a globals.cfm file which has site wide variables set and I
>> > > want to reference them with out using cfinvokeargument tag.
>> > >
>> > > I hope this make sense,
>> > > Thanks a bunch,
>> > > - Charles
>> > >
>> > >
>> > >
>> >
>> >
>>
>>
>
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184271
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

Error in CFX_Excel Tag

[James Watkins]

I have upgraded to Windows 2003 and now my CFX_Excel tag no longer
works.  I use IIS and CF 6.1  I have registered the tag.  I get the
"Can't start Excel"  error.  Please help!

Jim Watkins
VP Technology & Inst Svcs
706 781-2305 - Blairsville
706 754-7850 - Clarkesville
[EMAIL PROTECTED]
http://www.northgatech.edu  

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184272
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: Find first letter

[Aaron Rouse]

Do you want to do it in the DB or in CF?  If in the query then it
depends on the database you are using, something like this would work
in Oracle

SELECT SUBSTR(EMPLOYEE_LNAME, 1, 1) AS ABBR FROM EMPLOYEES ORDER BY
UPPER(EMPLOYEE_LNAME)

If in CF then #Left(queryname.employee_lname, 1)# would output just
the first one


On Mon, 15 Nov 2004 10:03:20 -0500, Robert Orlini <[EMAIL PROTECTED]> wrote:
> I need to output a list of names alphabetically via the field 
> "employee_lname" (last name).
> 
> What's the code that can check the first letter of the field employee_lname?
> 
> Thanks.
> 
> Robert O.
> HWW
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184273
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: Find first letter

[Deanna Schneider]

You know, this is the kind of thing that you can probably do in your 
database, too. So, that you pass back a column with the full last name and 
one with the first letter. Don't know your DB, so I can't give you any 
syntax. But, I just did this with Oracle, and it's a piece of cake.


- Original Message - 
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 9:03 AM
Subject: Find first letter


>I need to output a list of names alphabetically via the field 
>"employee_lname" (last name).
>
> What's the code that can check the first letter of the field 
> employee_lname?
>
> Thanks.
>
> Robert O.
> HWW
>
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184274
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: Find first letter

[Katz, Dov B (IT)]

I have code I use which does this combination of CF and SQL

Select *,substr(Lastname,1,1) as Letter 
from users  order by Lastname ASC, Firstname ASC

 
#letter#

#lastname#,#firstname#



HTH
-dov
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 10:25 AM
To: CF-Talk
Subject: Re: Find first letter

You know, this is the kind of thing that you can probably do in your
database, too. So, that you pass back a column with the full last name
and one with the first letter. Don't know your DB, so I can't give you
any syntax. But, I just did this with Oracle, and it's a piece of cake.


- Original Message -
From: "Robert Orlini" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 9:03 AM
Subject: Find first letter


>I need to output a list of names alphabetically via the field 
>"employee_lname" (last name).
>
> What's the code that can check the first letter of the field 
> employee_lname?
>
> Thanks.
>
> Robert O.
> HWW
>
> 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184275
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: Find first letter

[Bert Dawson]

If you need to list them alphabetically then you should just retrieve
them alphabetically from the database:

SELECT employee_lname
FROM employees
ORDER BY employee_lname

If you're not getting the names from a dB, but have an actual list
then you could convert the list to an array (using listToArray()),
then sort the array using ArraySort()

Or is there another reason why you need the first character?

Bert

On Mon, 15 Nov 2004 10:03:20 -0500, Robert Orlini <[EMAIL PROTECTED]> wrote:
> I need to output a list of names alphabetically via the field 
> "employee_lname" (last name).
> 
> What's the code that can check the first letter of the field employee_lname?
> 
> Thanks.
> 
> Robert O.
> HWW
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184276
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: Blackstone to provide built-in "Flash Remoting" type capabilities?

[Douglas Knudsen]

me thinks its MACRs attempt to get into the enterprise market more. 
CF is now with its J2EE foundation, but CF is not fetching enterprise
price levels.  The big boys buy expensive toys whilst holding meetings
at the golf course, eh?  Maybe MACR can price a 'stand alone' Flex
version for developers and keep the J2EE version priced for the big
enterprise buyers, eh?  Looking at enterprise software, Flex is not
that expensive really.  I mean, take a gander at the cost of Websphere
or Lotus Domino or Seibel.

Doug



On Mon, 15 Nov 2004 08:14:09 -0500, Rick Faircloth
<[EMAIL PROTECTED]> wrote:
> From the looks of what's out there...
> 
> Flash MX 2004, Flash MX 2004 Professional, and Flex (for LARGE budgets),
> I'd say MM needs to go ahead and develop Flash MX 2004 Professional
> as a tool to do what Flex does and break it off from its Flash Animation
> moorings.
> It seems to be doing almost the same thing on the RIA / data connection
> side,
> which is the only part I'm interested in...
> 
> BUT, the price needs to be about $11,500 less.  I run my own server and
> don't
> want to have to host apps outside to develop for and run in Flex...
> 
> I'm sure it's just my ignorance, but why does CF cost *only* $1,200 as a
> server
> and language and Flex costs $12,000?!
> 
> What makes the Flex server for RIA apps and its development capabilities
> worth
> 10 times as much as Cold Fusion...I don't get it...How about selling Flex on
> a
> "per developer" basis...$500 per developer...so a sole developer, like
> myself,
> gets the business benefit from what one developer can develop...and a team
> of 24 developers pay $12,000 because they can, supposedly, develop 24 times
> better
> and faster and get 24 times the financial benefit.  Per developer license,
> instead of
> per processor...
> 
> Put in some sort of (no rock-throwing, please...I'm recovering from a torn
> rotator cuff / broken arm injury)
> "digital rights management" for installations on x number of machines or
> something...
> 
> 
> 
> Rick
> 
> >  -Original Message-
> >  From: Rick Root [mailto:[EMAIL PROTECTED]
> >  Sent: Monday, November 15, 2004 7:48 AM
> >  To: CF-Talk
> >  Subject: Re: Blackstone to provide built-in "Flash Remoting" type
> >  capabilities?
> >
> >
> >  Rick Faircloth wrote:
> >  >
> >  > I just had a look at Flex and Flex "Explorer" demo...looks
> >  intriguing.
> >  > And the coding is pretty straight-forward.
> >  >
> >  > Any idea what kind of price Flex has (or will have?)
> >
> >  $12,000 is the list price I believe
> >
> >  And, you'll still pretty much have to learn Actionscript if
> >  you want to
> >  really do anything.
> >
> >- Rick
> >
> >  ~
> >  |
> >  Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
> >  http://www.cfhosting.net
> >
> >  Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184254
> >  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=708.628.4
> 
> 
> >  Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
> >
> >  --
> >  No virus found in this incoming message.
> >  Checked by AVG Anti-Virus.
> >  Version: 7.0.290 / Virus Database: 265.3.0 - Release Date: 11/13/2004
> >
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.290 / Virus Database: 265.3.0 - Release Date: 11/13/2004
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184277
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 a table problems

[Daniel Kessler]

I am creating a DB to monitor the number of steps our faculty uses on 
their pedometers.
I have two tables, one for login and the other for the step entries. 
I can't get the table for the step entries to CREATE.  It gives me 
the error, "no matching unique or primary key for this column-list." 
It references the login table.

Here are the two tables.

create table marathon_login (
 marathon_id NUMBER Primary Key,
 marathon_date_added date,
 marathon_fname VARCHAR2(100),
 marathon_lname VARCHAR2(100),
 marathon_email VARCHAR2(100),
 marathon_type VARCHAR2(100)
)

create table marathon_entries (
 marathon_id NUMBER REFERENCES marathon_login(marathon_id),
 marathon_date_added date,
 marathon_type VARCHAR2(100) REFERENCES marathon_login(marathon_type),
 marathon_data_date date,
 marathon_entry VARCHAR2(10)
)

btw, any other comments on these tables or their structure is 
welcome.  I'm pretty new to all this.

-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184278
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: cfc - cffunction question

[Matthew Drayer]

The one thing that will help you to make the proper decision(s) regarding 
object calls will be to lay out your application framework ahead of time and 
set up rules to govern communications between objects.  If you set the proper 
rules, they're easy to follow and you won't find yourself having to bend/break 
them.

As an example, here is how we set up our model:

Subsystem layer:  CFCs representing core business applications and data stores 
(listserv, CRM/fulfillment system, database, etc.).  These are *dumb* objects 
that can only submit/return data from these systems.

Business logic layer:  These are objects identified as major players in our 
model.  They are not allowed to talk to each other.  They utilize the subsystem 
layer to gather, cache, and process the data they represent.

Business logic interface layer:  A single CFC that governs all communication 
with the BL layer.  This CFC is essentially an assembler/constructor that calls 
the BL CFCs to perform specific jobs.

User interface layer:  Web site templates that communicate with the business 
logic interface CFC.  The UI is not allowed to access the BL directly.  Putting 
this rule in place has helped to streamline our code and make it immensely 
easier to manage.

There *are* other objects in the system that function outside of these rules, 
but they are few.  We have the token user/customer session object, and a 
security object (server scope) that has free reign over the entire system.

There are other rules in place for these objects as well, besides actual O-O 
communication.  Scope access is one of the bigger ones.  Objects are not 
allowed to access information outside of the scope they live in.  Sounds 
drastic, but it works very well and keeps the model clean.  If a job requires 
the combination of data from several scopes, it typically happens at the 
template level (probably in a custom tag), with object calls bringing data to 
the template and the end result passed along to its destination.

Anyway, granted this might not be true OO design, but it's working well (and 
fast), holding up under load, and it's a heck of a lot easier to manage code 
now than it was a year ago :)

Matt

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184279
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

JVM 1.5.0 - Anyone using it?

[Ryan Emerle]

Hey,

Has anyone upgraded to 1.5 jvm?  It's supposedly has "improved
out-of-box performance".  I'm assuming anyone who has upgraded hasn't
done so on a production box.  Any noticeable benefits in your dev
environments?

I just dropped it on a dev box here, and it seems pretty smooth.  I
haven't done any benchmarks as i don't intend on using it in
production, but some things seem a bit more responsive.

Any Comments?
--
Ryan Emerle

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184280
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 a table problems

[Ben Doom]

I can't help you with your main problem, as I usually use a tool for 
creating/altering tables, but I will say this:  create a pk or identity 
for your entries table.  For that matter, every table ever should have 
an identity.

--Ben

Daniel Kessler wrote:
> I am creating a DB to monitor the number of steps our faculty uses on 
> their pedometers.
> I have two tables, one for login and the other for the step entries. 
> I can't get the table for the step entries to CREATE.  It gives me 
> the error, "no matching unique or primary key for this column-list." 
> It references the login table.
> 
> Here are the two tables.
> 
> create table marathon_login (
>  marathon_id NUMBER Primary Key,
>  marathon_date_added date,
>  marathon_fname VARCHAR2(100),
>  marathon_lname VARCHAR2(100),
>  marathon_email VARCHAR2(100),
>  marathon_type VARCHAR2(100)
> )
> 
> create table marathon_entries (
>  marathon_id NUMBER REFERENCES marathon_login(marathon_id),
>  marathon_date_added date,
>  marathon_type VARCHAR2(100) REFERENCES marathon_login(marathon_type),
>  marathon_data_date date,
>  marathon_entry VARCHAR2(10)
> )
> 
> btw, any other comments on these tables or their structure is 
> welcome.  I'm pretty new to all this.
> 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184281
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: JVM 1.5.0 - Anyone using it?

[Dave Watts]

> Has anyone upgraded to 1.5 jvm?  It's supposedly has 
> "improved out-of-box performance".  I'm assuming anyone who 
> has upgraded hasn't done so on a production box.  Any 
> noticeable benefits in your dev environments?
> 
> I just dropped it on a dev box here, and it seems pretty 
> smooth.  I haven't done any benchmarks as i don't intend on 
> using it in production, but some things seem a bit more 
> responsive.

I think that Apache Axis doesn't work with 1.5 yet, so you might want to
test web services.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184282
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 a table problems

[daniel kessler]

Ben, I do have a pk marathon_id within marathon_login.  Do you mean that I 
should have one in marathon_entries?

>I can't help you with your main problem, as I usually use a tool for 
>creating/altering tables, but I will say this:  create a pk or identity 
>for your entries table.  For that matter, every table ever should have 
>an identity.
>
>--Ben

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184283
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 a table problems

[daniel kessler]

>I can't help you with your main problem, as I usually use a tool for 
>creating/altering tables, but I will say this:  create a pk or identity 
>for your entries table.  For that matter, every table ever should have 
>an identity.

I adjusted it to the following, but as you said, I'm left with my original 
table creation problem for marathon_entries:

create table marathon_login (
marathon_id NUMBER Primary Key,
marathon_date_added date,
marathon_fname VARCHAR2(100),
marathon_lname VARCHAR2(100),
marathon_email VARCHAR2(100),
marathon_type VARCHAR2(100)
)

create table marathon_entries (
marathon_entry_id NUMBER Primary Key,
marathon_id NUMBER REFERENCES marathon_login(marathon_id),
marathon_date_added date,
marathon_type VARCHAR2(100) REFERENCES marathon_login(marathon_type),
marathon_data_date date,
marathon_entry VARCHAR2(10)
)

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184284
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 a table problems

[Dave Watts]

> Ben, I do have a pk marathon_id within marathon_login.  Do 
> you mean that I should have one in marathon_entries?

Yes, every table should have its own primary key. If a table depends on
another table's primary key, it should have a foreign key as well of course.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184285
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: Re: Blackstone to provide built-in

[simon]

I wouldn't say you HAVE to learn AS 2 to use flex.  It's extremely helpful, 
however you can use it without coding any AS 2.  If you're interested in 
seperating business logic from the rest of your applications, Flex supports 
invoking remote functionality not only encapsulated in compiled Flash, but also 
web services and java objects.  That said, if I had my choice of languages to 
extend Flex with, I agree with Rick's statement that ActionScript 2 is 
essential - it's supported natively and is a very robust means of extending the 
environment.  Don't think you must know it to "really do anything" with Flex, 
though - it does a lot more than you might think right out of the box without 
knowing AS.  The one caveat is that you'll really want to get comfortable with 
one-liner AS syntax for binding components... but that's not a big deal and 
requires no prior AS experience.

~Simon


> 
> Rick Faircloth wrote:
> > 
> > I just had a look at Flex and Flex "Explorer" demo...looks intriguing.
> > And the coding is pretty straight-forward.
> > 
> > Any idea what kind of price Flex has (or will have?)
> 
> $12,000 is the list price I believe
> 
> And, you'll still pretty much have to learn Actionscript if you want to 
> really do anything.
> 
>   - Rick
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184286
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: Blackstone to provide built-in "Flash Remoting" type capabilities?

[Rick Root]

Douglas Knudsen wrote:
> enterprise buyers, eh?  Looking at enterprise software, Flex is not
> that expensive really.  I mean, take a gander at the cost of Websphere
> or Lotus Domino or Seibel.

We're considering building a reporting application using Flex and 
Coldfusion, building internally...

An alternative is a SAS enterprise reporting solution... does a lot more 
yeah but do we need it?

Flex:  $12,000
CF Ent: $5,000

SAS Enterprise Reporting Solution:  $100,000?  $200,000?

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184287
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 a table problems

[Deanna Schneider]

I usually do them in two steps - first create table with pk fields being 
non-null

create table marathon_login (
marathon_id NUMBER Not Null,
marathon_date_added date,
marathon_fname VARCHAR2(100),
marathon_lname VARCHAR2(100),
marathon_email VARCHAR2(100),
marathon_type VARCHAR2(100)
)

Then...

ALTER TABLE marathon_login
 ADD CONSTRAINT pk_marathon_login PRIMARY KEY (marathon_id)

ALTER TABLE marathon_entries
 ADD CONSTRAINT fk_marathon_entries FOREIGN KEY (marathon_id)
  REFERENCES marathon_login(marathon_id)


One of the benefits of doing it this way is giving explicit names to your 
constraints. If you don't name them, Oracle will give them horrificly 
un-identifiable names. Then, if you ever want to disable them without a gui, 
you're sort of screwed.


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184288
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 a table problems

[daniel kessler]

It doesn't appear that adding the constraint is keeping me from creating the 
table.  If I remove the line:
marathon_type VARCHAR2(100) REFERENCES marathon_login(marathon_type),
it creates the table fine.  Could it have to do with it being defined 
varchar2(100) with incorrect syntax?  I dunno. I'm really at a loss.

>I usually do them in two steps - first create table with pk fields being 
>non-null
>
>create table marathon_login (
>marathon_id NUMBER Not Null,
>marathon_date_added date,
>marathon_fname VARCHAR2(100),
>marathon_lname VARCHAR2(100),
>marathon_email VARCHAR2(100),
>marathon_type VARCHAR2(100)
>)
>
>Then...
>
>ALTER TABLE marathon_login
> ADD CONSTRAINT pk_marathon_login PRIMARY KEY (marathon_id)
>
>ALTER TABLE marathon_entries
> ADD CONSTRAINT fk_marathon_entries FOREIGN KEY (marathon_id)
>  REFERENCES marathon_login(marathon_id)
>
>
>One of the benefits of doing it this way is giving explicit names to your 
>constraints. If you don't name them, Oracle will give them horrificly 
>un-identifiable names. Then, if you ever want to disable them without a gui, 
>you're sort of screwed.

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184289
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

Delete CFMAGIC cookie?

[Lofback, Chris]

All--

Is there anyway to force a client browser to delete a CFMAGIC domain-level
cookie?  We have users who have domain cookies that are getting each other's
sessions and need to remove the cookie.

Thanks,
Chris

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184290
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: Delete CFMAGIC cookie?

[Dave Watts]

> Is there anyway to force a client browser to delete a CFMAGIC 
> domain-level cookie?  We have users who have domain cookies 
> that are getting each other's sessions and need to remove the
> cookie.





Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184291
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 a table problems

[Dave Watts]

> Here are the two tables.
> 
> create table marathon_login (
>  marathon_id NUMBER Primary Key,
>  marathon_date_added date,
>  marathon_fname VARCHAR2(100),
>  marathon_lname VARCHAR2(100),
>  marathon_email VARCHAR2(100),
>  marathon_type VARCHAR2(100)
> )
> 
> create table marathon_entries (
>  marathon_id NUMBER REFERENCES marathon_login(marathon_id),
>  marathon_date_added date,
>  marathon_type VARCHAR2(100) REFERENCES 
> marathon_login(marathon_type),
>  marathon_data_date date,
>  marathon_entry VARCHAR2(10)
> )
> 
> btw, any other comments on these tables or their structure is 
> welcome.  I'm pretty new to all this.

You don't need to have marathon_entries.marathon_type - you already
reference the marathon_login table using its primary key.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184292
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

Weird Version Control Spot?

[Eric Hoffman]

I am in a position that I need to look at version control
capabilities...

The quick overview:   Win2003, CFMX 6.1...built a large
fulfillment/distribution house management system in all CF, from order
taking in call center to warehouse/shipping and all inbetween.

Peculiarity comes as they now want to replicate the system for another
client they will start accepting calls/customer service/shipping for.
Various reasons, I want to do this right.  They are essentially asking
that the new system run parallel due to some agreements with
lawyer-types.  I understand it means two codebases under one umbrella
system, so I can't do some fancy dynamic graphics, sessions, etc

Has anyone ever had to have a system in place, make a change say in the
inventory control modules, and then need to replicate to a parallel
system?  I assume version control of each file is best way to handle?
Any ideas welcome, perhaps this isn't the huge "oh crap" Monday moment I
was thinking it wasand what version control software if that is the
answer meshes best with CF (Dreamweaver MX 2004 coding tools)

Thanks for thoughts on this!!

Eric



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184293
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: Delete CFMAGIC cookie?

[Lofback, Chris]

We tried that and it didn't work.  Here's the background:

We were using SETDOMAINCOOKIES in CFAPPLICATION.  The CFMAGIC cookie is a
domian cookie with no exdate and it appears to be overriding our other host
cookies that we want to expire when the browser is closed.  CF is "bumping"
all the cookies up into the domain cookie and where they aren't expiring.
Is there anyway to override that behavior?

Thanks,
Chris

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 15, 2004 12:43 PM
> To: CF-Talk
> Subject: RE: Delete CFMAGIC cookie?
> 
> 
> > Is there anyway to force a client browser to delete a CFMAGIC 
> > domain-level cookie?  We have users who have domain cookies 
> > that are getting each other's sessions and need to remove the
> > cookie.
> 
> 
>   
> 
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> phone: 202-797-5496
> fax: 202-797-5444
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184294
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 a table problems

[Ben Doom]

Yes.  Yes I do.  Every single table should have something that 
distinctly identifies rows, even if all the "useful" data is duplicated.

Just a good idea in general.  There have been myriad discussions about 
this, so feel free to browse the archives.

--Ben

daniel kessler wrote:
> Ben, I do have a pk marathon_id within marathon_login.  Do you mean that I 
> should have one in marathon_entries?
> 
> 
>>I can't help you with your main problem, as I usually use a tool for 
>>creating/altering tables, but I will say this:  create a pk or identity 
>>for your entries table.  For that matter, every table ever should have 
>>an identity.
>>
>>--Ben
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184295
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

OT: Online Email Newsletter Services

[Jeffrey Fongemie]

Hi everyone,

Sorry for the off topic post.

Anyone have any good experiences with any of the online email-bulk-newsletter 
services? Can anyone recommend a good service?


Thanks!

Jeff
-{



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184296
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: Online Email Newsletter Services

[SStewart]

Real Magnet: http://www.realmagnet.com


sas

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 100
Chantilly, VA 20151
Phone: (703) 471-8400
Fax: (703) 834-5527


-Original Message-
From: Jeffrey Fongemie [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 01:36 pm
To: CF-Talk
Subject: OT: Online Email Newsletter Services

Hi everyone,

Sorry for the off topic post.

Anyone have any good experiences with any of the online
email-bulk-newsletter services? Can anyone recommend a good service?


Thanks!

Jeff
-{





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184297
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

SOT: Client Variable database

[Janine Jakim]

I am using client variables for some of my applications.  I have done the
recommended way and made a client variable database to store all the info.
(on a MSSQL db) It is the only info stored there.
I just noticed today that this db is over 10 gig big!  It's not like there
are many rows of informtaion.  My other database that has millions of rows
is 80% smaller than this database!

This database is on the same maintenance plan as the other database.
Any clues to why this is happening.
Thanks,
J

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184298
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 a table problems

[daniel kessler]

>> Here are the two tables.
>
>You don't need to have marathon_entries.marathon_type - you already
>reference the marathon_login table using its primary key.

ok, you are correct.  And this made me realize that I still need the field, but 
that it shouldn't be a foreign key.  The marathon_login.marathon_type is the 
marathon type that they are currently logged into.  The 
marathon_entries.marathon_type has whatever marathon was in use when the entry 
was created.

Still, I wonder why the original field wouldn't work as a foreign key.  Was it 
because the table was already referenced through the marathon_id?

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184299
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: cfc - cffunction question

[Charles Heizer]

Thanks to all who replied. This works very well form me.

Thanks again!

- Charles

On Nov 13, 2004, at 3:55 PM, Raymond Camden wrote:

> But (normally), extends should only be used to create a "Is A"
> releationship. Settings doesn't match this rule. Just in case it
> wasn't too obvious for others, here is a super simple example of what
> I'm talking about. Please note I did not include attributes like
> output=false, hint, var statements, etc, just to make things tighter:
>
> settings.cfc:
> 
>
> 
> 
> 
> 
> 
> 
> 
>
> 
>
> foo.cfc:
> 
>
>  returnVariable="variables.settings">
>
> 
> 
> select whatever
> 
> 
> 
>
> 
>
> What's nice then is that your Application.cfm can use the same
> cfinvoke statement to get global settings, although it would use
> returnVariable="application.settings". So now both your CFCs and your
> outside code all use the same method to get their settings.
>
> On Sat, 13 Nov 2004 17:47:57 +0200, Murat Demirci <[EMAIL PROTECTED]>  
> wrote:
>> For your specific situation you can use  in your  
>> cffunction(s) or
>> develop a global component which creates variables.settings  
>> internally and
>> extend it.
>>
>> Murat.
>>
>>
>>
>>> -Original Message-
>>> From: Charles Heizer [mailto:[EMAIL PROTECTED]
>>> Sent: Saturday, November 13, 2004 2:12 AM
>>> To: CF-Talk
>>> Subject: cfc - cffunction question
>>>
>>> Hello,
>>> I was wondering if it was possible to do a cfinclude in a cffunction
>>> tag?
>>>
>>> I have a globals.cfm file which has site wide variables set
>>> and I want
>>> to reference them with out using cfinvokeargument tag.
>>>
>>> I hope this make sense,
>>> Thanks a bunch,
>>> - Charles
>>>
>>>
>>>
>>
>>
>
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184300
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: Weird Version Control Spot?

[Barney Boisvert]

Check out Subversion or CVS.  Subversion is newer and more feature
rich, CVS is older, more established, and has a larger set of support
software available.  Both are free.

Either one will let you branch your code so that you have two distinct
lines that eveolve independantly from one another, but allow you to
easily merge changes between the two branches.

Managing a large project with multiple branches is not for the faint
of heart, especially for someone new to the process.  In general,
however, it's all reasonably logical, and there are myriad online
references for helping you through some trouble spots.  And best of
all, since you've got version control, you can't really screw anything
up.  The worst you can do is do something wrong and have to undo it,
thereby wasting time.

cheers,
barneyb

On Mon, 15 Nov 2004 12:01:17 -0600, Eric Hoffman
<[EMAIL PROTECTED]> wrote:
> I am in a position that I need to look at version control
> capabilities...
> 
> The quick overview:   Win2003, CFMX 6.1...built a large
> fulfillment/distribution house management system in all CF, from order
> taking in call center to warehouse/shipping and all inbetween.
> 
> Peculiarity comes as they now want to replicate the system for another
> client they will start accepting calls/customer service/shipping for.
> Various reasons, I want to do this right.  They are essentially asking
> that the new system run parallel due to some agreements with
> lawyer-types.  I understand it means two codebases under one umbrella
> system, so I can't do some fancy dynamic graphics, sessions, etc
> 
> Has anyone ever had to have a system in place, make a change say in the
> inventory control modules, and then need to replicate to a parallel
> system?  I assume version control of each file is best way to handle?
> Any ideas welcome, perhaps this isn't the huge "oh crap" Monday moment I
> was thinking it wasand what version control software if that is the
> answer meshes best with CF (Dreamweaver MX 2004 coding tools)
> 
> Thanks for thoughts on this!!
> 
> Eric
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 0 GMail invites for the taking

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184301
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: Client Variable database

[Figy, Kam]

It's probably the transaction log, since it has to run some sql for
client var requests.

Theres a way to truncate the log, but I don't remember it offhand. Try
the t-sql help in query analyzer.

Hth
Kam 

-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 10:45 AM
To: CF-Talk
Subject: SOT: Client Variable database

I am using client variables for some of my applications.  I have done
the recommended way and made a client variable database to store all the
info.
(on a MSSQL db) It is the only info stored there.
I just noticed today that this db is over 10 gig big!  It's not like
there are many rows of informtaion.  My other database that has millions
of rows is 80% smaller than this database!

This database is on the same maintenance plan as the other database.
Any clues to why this is happening.
Thanks,
J



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184302
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: Weird Version Control Spot?

[Eric Hoffman]

Thanks!  Any links for the two? 

-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 1:06 PM
To: CF-Talk
Subject: Re: Weird Version Control Spot?

Check out Subversion or CVS.  Subversion is newer and more feature rich,
CVS is older, more established, and has a larger set of support software
available.  Both are free.

Either one will let you branch your code so that you have two distinct
lines that eveolve independantly from one another, but allow you to
easily merge changes between the two branches.

Managing a large project with multiple branches is not for the faint of
heart, especially for someone new to the process.  In general, however,
it's all reasonably logical, and there are myriad online references for
helping you through some trouble spots.  And best of all, since you've
got version control, you can't really screw anything up.  The worst you
can do is do something wrong and have to undo it, thereby wasting time.

cheers,
barneyb

On Mon, 15 Nov 2004 12:01:17 -0600, Eric Hoffman
<[EMAIL PROTECTED]> wrote:
> I am in a position that I need to look at version control 
> capabilities...
> 
> The quick overview:   Win2003, CFMX 6.1...built a large
> fulfillment/distribution house management system in all CF, from order

> taking in call center to warehouse/shipping and all inbetween.
> 
> Peculiarity comes as they now want to replicate the system for another

> client they will start accepting calls/customer service/shipping for.
> Various reasons, I want to do this right.  They are essentially asking

> that the new system run parallel due to some agreements with 
> lawyer-types.  I understand it means two codebases under one umbrella 
> system, so I can't do some fancy dynamic graphics, sessions, etc
> 
> Has anyone ever had to have a system in place, make a change say in 
> the inventory control modules, and then need to replicate to a 
> parallel system?  I assume version control of each file is best way to
handle?
> Any ideas welcome, perhaps this isn't the huge "oh crap" Monday moment

> I was thinking it wasand what version control software if that is 
> the answer meshes best with CF (Dreamweaver MX 2004 coding tools)
> 
> Thanks for thoughts on this!!
> 
> Eric
> 
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 0 GMail invites for the taking



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184303
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

CF Server custom errors

[Steve Brownlee]

This is a question regarding the built-in server for CFMX.  We're running
both CF5 and CFMX on our development machines, and in the CF5 configuration,
we have IIS redirecting users to a page on any 404 error.  Is there a way to
set up the CFMX server to mimic this functionality?

Thanks in advance,
Steve

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184304
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: Weird Version Control Spot?

[Barney Boisvert]

Sorry 'bout that.

https://www.cvshome.org/
http://subversion.tigris.org/

cheers,
barneyb


On Mon, 15 Nov 2004 13:20:41 -0600, Eric Hoffman
<[EMAIL PROTECTED]> wrote:
> Thanks!  Any links for the two?
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 0 GMail invites for the taking

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184305
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

MX sql driver issues

[Lawrence Ng]

hello there,

I came across this over the weekend with a fellow developer over the
weekend...

Have any of you experienced any issues simliar to this with the JDBC
driver with SQL 2000 server?  

1. Two weeks ago, they switched over to MX and it bombed under load -
it was producing constant sql deadlocks.  They believe they were able to
track down the problem with some stored procedures - why would this
issue cropped up in MX and not in CF5. Is it because MX is not as
forgiving as CF5?

2.   Then another major error occurred:

Operation failed on the data source named "whatever5sql". Reason of
failure

"[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not
be prepared."  


This has happened twice and it required the services to be restarted.
It has been frustrating for the developer and the users.  Management
that MX was faster and more stable to justify buying it.  They had to
rollback to CF5 once and the developer doesn't want switch back at this
time, otherwise the company just wasted $1500 (CDN).

thoughts?

thank you.





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184306
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

website not quite processing CFM file correctly.

[Ian Skinner]

I suspect there is something incomplete about the website/ColdFusion 
integration.  If I call a complete URL, all is well (http://website/index.cfm). 
 But, if I leave off the file, relying on the defaults to process, the 
index.cfm file is found by the web server (Windows 2000), but it is not handed 
off to the ColdFusion server.  The file is delivered as text to the browser, 
thus just showing the code in the file.

Example of output for a link such as http://website/





NOTE:  This is the output in the browser, the CFML was not processed.

Does anybody know how to fix this off the top of their head?  I'm sure it is 
some kind of setting or configuration, but I have no clue where to start 
looking.

ColdFusion MX 6.1
Windows 2000 Server

Thank You

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

"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. 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184307
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 Server custom errors

[Steve Brownlee]

Actually I should be more specific, what we're doing with CF5 is making the
application a bit smarter.  If someone types in
http://www.ourapp.com/nonexistentsubdirectory, the code will take
'nonexistentsubdirectory' and see if that user exists in the database and
then redirect the browser to the login page for that user.  This is done via
a custom 404 error setting in IIS that automatically redirects the previous
URL to index.cfm?site=nonexistentsubdirectory.

 

-Original Message-
From: Steve Brownlee 
Sent: Monday, November 15, 2004 2:23 PM
To: CF-Talk
Subject: CF Server custom errors

This is a question regarding the built-in server for CFMX.  We're running
both CF5 and CFMX on our development machines, and in the CF5 configuration,
we have IIS redirecting users to a page on any 404 error.  Is there a way to
set up the CFMX server to mimic this functionality?

Thanks in advance,
Steve



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184308
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: MX sql driver issues

[Dirk De Bock - Listclient]

apart from reviewing the cf code you may want to look into the jTDS drivers 
available from
http://jtds.sourceforge.net/
they are regarded as considerably more stable and also more performant than 
microsoft's own offering


- Original Message - 
From: "Lawrence Ng" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 8:37 PM
Subject: MX sql driver issues


> hello there,
>
> I came across this over the weekend with a fellow developer over the
> weekend...
>
> Have any of you experienced any issues simliar to this with the JDBC
> driver with SQL 2000 server?
>
> 1. Two weeks ago, they switched over to MX and it bombed under load -
> it was producing constant sql deadlocks.  They believe they were able to
> track down the problem with some stored procedures - why would this
> issue cropped up in MX and not in CF5. Is it because MX is not as
> forgiving as CF5?
>
> 2.   Then another major error occurred:
>
> Operation failed on the data source named "whatever5sql". Reason of
> failure
>
> "[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not
> be prepared."
>
>
> This has happened twice and it required the services to be restarted.
> It has been frustrating for the developer and the users.  Management
> that MX was faster and more stable to justify buying it.  They had to
> rollback to CF5 once and the developer doesn't want switch back at this
> time, otherwise the company just wasted $1500 (CDN).
>
> thoughts?
>
> thank you.
>
>
>
>
>
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184309
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: MX sql driver issues

[Dave Watts]

> Have any of you experienced any issues simliar to this with 
> the JDBC driver with SQL 2000 server?  
> 
> 1. Two weeks ago, they switched over to MX and it bombed 
> under load - it was producing constant sql deadlocks.  They 
> believe they were able to track down the problem with some 
> stored procedures - why would this issue cropped up in MX and 
> not in CF5. Is it because MX is not as forgiving as CF5?
> 
> 2.   Then another major error occurred:
> 
> Operation failed on the data source named "whatever5sql". 
> Reason of failure
> 
> "[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) 
> could not be prepared." 

I've experienced all sorts of JDBC problems with MS SQL Server. Have you
applied Updater 1? This provides a newer version of the DataDirect JDBC
drivers, which fixes a bunch of SQL Server problems. If that doesn't work,
you might try using the free JDBC driver for SQL Server 2000 from the
Microsoft site, which fixes other problems. Or, you might try JTurbo from
New Atlanta; I don't have much experience with it yet but have heard very
good things about it. Unfortunately it's not free, but if it works it might
be worth the money to you.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184310
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: MX sql driver issues

[Lawrence Ng]

thank you. I will have a look at it.



>>> [EMAIL PROTECTED] 11/15/2004 11:44:27 AM >>>
apart from reviewing the cf code you may want to look into the jTDS
drivers 
available from
http://jtds.sourceforge.net/ 
they are regarded as considerably more stable and also more performant
than 
microsoft's own offering


- Original Message - 
From: "Lawrence Ng" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 15, 2004 8:37 PM
Subject: MX sql driver issues


> hello there,
>
> I came across this over the weekend with a fellow developer over the
> weekend...
>
> Have any of you experienced any issues simliar to this with the JDBC
> driver with SQL 2000 server?
>
> 1. Two weeks ago, they switched over to MX and it bombed under load
-
> it was producing constant sql deadlocks.  They believe they were able
to
> track down the problem with some stored procedures - why would this
> issue cropped up in MX and not in CF5. Is it because MX is not as
> forgiving as CF5?
>
> 2.   Then another major error occurred:
>
> Operation failed on the data source named "whatever5sql". Reason of
> failure
>
> "[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could
not
> be prepared."
>
>
> This has happened twice and it required the services to be
restarted.
> It has been frustrating for the developer and the users.  Management
> that MX was faster and more stable to justify buying it.  They had
to
> rollback to CF5 once and the developer doesn't want switch back at
this
> time, otherwise the company just wasted $1500 (CDN).
>
> thoughts?
>
> thank you.
>
>
>
>
>
> 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184311
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: MX sql driver issues

[Lawrence Ng]

thank you Dave. I'll ask him.

>>> [EMAIL PROTECTED] 11/15/2004 11:54:21 AM >>>
> Have any of you experienced any issues simliar to this with 
> the JDBC driver with SQL 2000 server?  
> 
> 1. Two weeks ago, they switched over to MX and it bombed 
> under load - it was producing constant sql deadlocks.  They 
> believe they were able to track down the problem with some 
> stored procedures - why would this issue cropped up in MX and 
> not in CF5. Is it because MX is not as forgiving as CF5?
> 
> 2.   Then another major error occurred:
> 
> Operation failed on the data source named "whatever5sql". 
> Reason of failure
> 
> "[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) 
> could not be prepared." 

I've experienced all sorts of JDBC problems with MS SQL Server. Have
you
applied Updater 1? This provides a newer version of the DataDirect
JDBC
drivers, which fixes a bunch of SQL Server problems. If that doesn't
work,
you might try using the free JDBC driver for SQL Server 2000 from the
Microsoft site, which fixes other problems. Or, you might try JTurbo
from
New Atlanta; I don't have much experience with it yet but have heard
very
good things about it. Unfortunately it's not free, but if it works it
might
be worth the money to you.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/ 
phone: 202-797-5496
fax: 202-797-5444




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184312
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

A Quick cry for help, figured you guys have probably seen this...

[Jeff Small]

We have a development database running on a little windowsXP Pro machine 
that's hummed along quite nicely. Then today, we ran SP2 because we did a 
monthly reboot and it reminded us. We didn't change any settings and when it 
came back up we just cut off the Windows Firewall, the Virus checker, etc 
thinking, "well, we'll just cut it all off". We really didn't fear it 
because this little machine does *one* thing...run SQL server in-house for 
testing and development.

Now the server running CF is throwing errors and all the SQL server 
datasources that are normally pointing at the IG-SQL (Interactive Group 
SQL...clever, eh?) and working are all being refused with the following 
error:

Connection verification failed for data source: TestSQL
[]java.sql.SQLException: SQLException while attempting to connect: 
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing 
socket. Connection refused: connect
The root cause was that: java.sql.SQLException: SQLException while 
attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC 
Driver]Error establishing socket. Connection refused: connect

This is when we simply go in and submit the datasource with all the correct 
info...'cause nothing's changed...well...*technically*...

For what it's worth, I can look at "IG-SQL" on my machine with my Enterprise 
Manager and all is well. I can see my instance of it, it expands, I see all 
the tables, etc...so I know the machine's up and working just dandy. I can 
use Enterprise Manager locally on the Machine...and on my machine and see 
the server hunky dorey...

Anyway, I just thought one of you guys might have seen it, and could go, "oh 
yeah, this happened to us and we #solution#".

Thank ye 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184313
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: Need Book Recommendation

[Donna French]

I've looked at that one briefly and plan to look at it more in-depth
on my next Books a Million outing.

THX!!!


On Thu, 11 Nov 2004 17:54:57 +0100, Massimo Foti <[EMAIL PROTECTED]> wrote:
> > I have the CF5 Web App Kit, and have looked at the CFMX WAK but it
> > appears to be mostly the same content as the CF5. So I've started
> > considering the Advanced CFMX WAK or the Certification Study Guide.
> > Can anyone recommend either, or another that would be appropriate for
> > studying CFMX beyond the basics.
> 
> Both are excellent. I would consider this one as well:
> http://www.oreilly.com/catalog/coldfusion2/
> 
> Check the TOC and sample chapter to get a better idea
> 
> 
> Massimo Foti
> DW tools: http://www.massimocorner.com
> CF tools:  http://www.olimpo.ch/tmt/
> 
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.289 / Virus Database: 265.3.0 - Release Date: 11/13/04
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184314
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: A Quick cry for help, figured you guys have probably seen this...

[Stephen Moretti (cfmaster)]

Jeff Small wrote:

>We have a development database running on a little windowsXP Pro machine 
>that's hummed along quite nicely. Then today, we ran SP2 because we did a 
>monthly reboot and it reminded us. We didn't change any settings and when it 
>came back up we just cut off the Windows Firewall, the Virus checker, etc 
>thinking, "well, we'll just cut it all off". We really didn't fear it 
>because this little machine does *one* thing...run SQL server in-house for 
>testing and development.
>
>Now the server running CF is throwing errors and all the SQL server 
>datasources that are normally pointing at the IG-SQL (Interactive Group 
>SQL...clever, eh?) and working are all being refused with the following 
>error:
>  
>
This should help I think.

http://www.winnetmag.com/SQLServer/Article/ArticleID/42854/SQLServer_42854.html

Stephen


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184315
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: A Quick cry for help, figured you guys have probably seen this...

[Jeff Small]

> This should help I think.
>
> http://www.winnetmag.com/SQLServer/Article/ArticleID/42854/SQLServer_42854.html
>
> Stephen

Boy howdythanks ever so much. 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184316
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: Client Variable database

[jjakim]

That was my initial reaction. But the maintanance plan that this database uses 
is suppose to shrink the log/ remove old files after a certain amount of time.  
All the other databases under this maintenance plan have not balloned like this 
one.
It's strange that it's only happening on this particular database

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184317
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

OT: CSS Resources

[Donna French]

I am hoping some of you can recommend a good online source for CSS.
I'm wanting to add dotted lines and such around paragraphs, and would
like to see examples with code of what all can be done with CSS.

TIA,
-- 

Donna French
[EMAIL PROTECTED]

Blog: http://dgfrench.blogspot.com
Site: http://www.dgfrenchdesigns.com

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184318
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

OT: flowchart diagrams - best tools & guides?

[Damien McKenna]

I'm attempting to document my work a bit more thoroughly and am looking 
to do flowcharts for my work.  Are there any better (free) flowcharting 
tools other than Dia (http://dia-installer.sf.net/)?  Are there any 
quick reference guides online for the basic shapes?  Thanks.
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 

The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Why are you wearing that stupid man suit?" - Frank

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184319
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: CSS Resources

[Massimo, Tiziana e Federica]

> I am hoping some of you can recommend a good online source for CSS.
> I'm wanting to add dotted lines and such around paragraphs, and would
> like to see examples with code of what all can be done with CSS.

This is an excellent starting point, containing plenty of links to
additional resources:

http://css-discuss.incutio.com/


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184320
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: CSS Resources

[Figy, Kam]

www.csszengarden.com 

http://www.w3schools.com/css/default.asp

Hth
Kam
-Original Message-
From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 12:37 PM
To: CF-Talk
Subject: OT: CSS Resources

I am hoping some of you can recommend a good online source for CSS.
I'm wanting to add dotted lines and such around paragraphs, and would
like to see examples with code of what all can be done with CSS.

TIA,
--

Donna French
[EMAIL PROTECTED]

Blog: http://dgfrench.blogspot.com
Site: http://www.dgfrenchdesigns.com



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184321
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: CSS Resources

[Emmet McGovern]

http://www.alistapart.com 

-e 

-Original Message-
From: Donna French [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 15, 2004 3:37 PM
To: CF-Talk
Subject: OT: CSS Resources

I am hoping some of you can recommend a good online source for CSS.
I'm wanting to add dotted lines and such around paragraphs, and would like
to see examples with code of what all can be done with CSS.

TIA,
--

Donna French
[EMAIL PROTECTED]

Blog: http://dgfrench.blogspot.com
Site: http://www.dgfrenchdesigns.com



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184322
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

CFC's and multiple returnVariable(s)

[Charles Heizer]

Hello,
I'm really new to using cfc and I really like them and I'm find them to 
be a great time saver. My question is, I was wondering if it was 
possible to have multiple returnVariable in my cfinvoke? If so, can 
some one tell me how?

Thanks,
- Charles


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184323
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: CFC's and multiple returnVariable(s)

[Dave Watts]

> I'm really new to using cfc and I really like them and I'm 
> find them to be a great time saver. My question is, I was 
> wondering if it was possible to have multiple returnVariable 
> in my cfinvoke? If so, can some one tell me how?

No, your functions can only return one thing. However, that thing can be a
complex data object (query, structure, array, XML document object, CFC
instance).

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184324
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: CFC's and multiple returnVariable(s)

[Barney Boisvert]

Nope, you can only return a single "thing" from a given method call. 
However, there's no reason that single thing can't be a structure
filled with a whole bunch different stuff.

For example, a getUserInfo() method might need to return a name and
email.  Rather than returning them directly, make a struct with two
keys ('name' and 'email'), and return that struct.

cheers,
barneyb


On Mon, 15 Nov 2004 13:13:47 -0800, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm really new to using cfc and I really like them and I'm find them to
> be a great time saver. My question is, I was wondering if it was
> possible to have multiple returnVariable in my cfinvoke? If so, can
> some one tell me how?
> 
> Thanks,
> - Charles
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 0 GMail invites for the taking

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184325
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: CFC's and multiple returnVariable(s)

[Michael Dinowitz]

Place all of the return variables into a structure and return the structure.

> Hello,
> I'm really new to using cfc and I really like them and I'm find them to
> be a great time saver. My question is, I was wondering if it was
> possible to have multiple returnVariable in my cfinvoke? If so, can
> some one tell me how?
> 
> Thanks,
> - Charles



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184326
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: CFC's and multiple returnVariable(s)

[Andy Ousterhout]

Return a structure.

-Original Message-
From: Charles Heizer [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 3:14 PM
To: CF-Talk
Subject: CFC's and multiple returnVariable(s)


Hello,
I'm really new to using cfc and I really like them and I'm find them to
be a great time saver. My question is, I was wondering if it was
possible to have multiple returnVariable in my cfinvoke? If so, can
some one tell me how?

Thanks,
- Charles




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184327
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: OT: flowchart diagrams - best tools & guides?

[Damien McKenna]

To answer my own questoin, I found this guide:
http://www.deneba.com/community/howto/flowcharts/default.html
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 

The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Why are you wearing that stupid man suit?" - Frank

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184328
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

CFC Objects in Drop Down

[Ryan Anklam]

Is there any way to pass CFC's into a drop down menu and have the form submit 
the cfc instead of having to re-create the cfc on the form handler page based 
on a value from the drop down?  If this is impossiable I'd love to hear how 
other people have solved this problem.




   #aryObjects[i].GetName()#



I get a "Complex object types cannot be converted to simple values." error when 
trying to do this.  

Thanks!
Ryan

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184329
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

512 character limitation on the total length of groups returned by NTSecurity.cfc

[Ian Skinner]

There seems to be a 512 character limitation on the total length of groups 
returned by both the NTSecurity.cfc getUserGroups() and 
authenticateAndGetGroups() methods. If the total number of characters exceeds 
512, these functions return false for valid users.

I spoke to John Cummings about this at the recent MAX convention. He said he 
was going to get back to me, once he had a chance to do some checking when he 
got back to Macromedia. I have not heard from him, and I do not have any direct 
contact information for him. I'm hoping this message will be noticed inside 
Macromedia and find its way to him.

 --
Ian Skinner ([EMAIL PROTECTED])
Web Programmer
BloodSource

 www.BloodSource.org  
Sacramento, CA

"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. 




~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184330
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: OT: CSS Resources

[Michael Wilson]

Donna French wrote:
> I am hoping some of you can recommend a good online source for CSS.
> I'm wanting to add dotted lines and such around paragraphs, and would
> like to see examples with code of what all can be done with CSS.
> 
> TIA,

Hi,

http://www.westciv.com/style_master/academy/css_tutorial/properties/border.html
http://www.w3schools.com/css/pr_border-style.asp

-- 
Best regards,
Michael Wilson


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184331
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: CFC Objects in Drop Down

[Andy Ousterhout]

When I want to do this, I create a session variable and pass it's name to
the form handler.

-Original Message-
From: Ryan Anklam [mailto:[EMAIL PROTECTED]
Sent: Monday, November 15, 2004 2:31 PM
To: CF-Talk
Subject: CFC Objects in Drop Down


Is there any way to pass CFC's into a drop down menu and have the form
submit the cfc instead of having to re-create the cfc on the form handler
page based on a value from the drop down?  If this is impossiable I'd love
to hear how other people have solved this problem.




   #aryObjects[i].GetName()#



I get a "Complex object types cannot be converted to simple values." error
when trying to do this.

Thanks!
Ryan



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184332
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: 512 character limitation on the total length of groups return ed by NTSecurity.cfc

[Dave Watts]

> There seems to be a 512 character limitation on the total 
> length of groups returned by both the NTSecurity.cfc 
> getUserGroups() and authenticateAndGetGroups() methods. If 
> the total number of characters exceeds 512, these functions 
> return false for valid users.
> 
> I spoke to John Cummings about this at the recent MAX 
> convention. He said he was going to get back to me, once he 
> had a chance to do some checking when he got back to 
> Macromedia. I have not heard from him, and I do not have any 
> direct contact information for him. I'm hoping this message 
> will be noticed inside Macromedia and find its way to him.

This is just a shot in the dark, but most people at Macromedia have email
addresses that use the first letter of the first name and the last name, so
his address may well be "[EMAIL PROTECTED]".

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184333
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: CFC Objects in Drop Down

[Matthew Walker]

A CFC object is a complex data structure. There's no predefined way to
render it as a string. If it were a structure or query record set or
something you could use cfwddx, although I wouldn't recommend it -- exposing
a data structure like that in HTML sounds like a very bad idea to me. But it
wouldn't work for an object anyway. 

You could perhaps store the CFC object in a persistent scope such as
session, then just place the name of the CFC object in the select box.



Matthew Walker, ESWsoftware
http://www.eswsoftware.com


> -Original Message-
> From: Ryan Anklam [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, 16 November 2004 9:31 a.m.
> To: CF-Talk
> Subject: CFC Objects in Drop Down
> 
> Is there any way to pass CFC's into a drop down menu and have 
> the form submit the cfc instead of having to re-create the 
> cfc on the form handler page based on a value from the drop 
> down?  If this is impossiable I'd love to hear how other 
> people have solved this problem.
> 
>  
> 
> 
> value="#aryObjects[i]">#aryObjects[i].GetName()#
> 
> 
> 
> I get a "Complex object types cannot be converted to simple 
> values." error when trying to do this.  
> 
> Thanks!
> Ryan
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184334
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

Users getting other user's CFIDs and CFTOKENs

[Lofback, Chris]

We have discovered that some of our users--not all--are somehow getting
another user's CFID/CFTOKEN.

Our setup:  CF5/Win2K/IIS5, two apps, each in a 2-server cluster, each in
the same domain: ie, app1.domain.com and app2.domain.com, storing client
variables in a database.  We were using CFAPPLICATION with the
SETDOMAINCOOKIES="YES" but have disabled it.  But the domain cookie that was
created still exists with the old CFID/CFTOKEN and we can't get rid of it.
It appears that users with the domain-level cookie are getting assigned old
CFID/CFTOKEN each time they log back in, and if a session with the same
CFID/CFTOKEN exists, they are getting the existing users data.  

We thought we could fix this by deleteing the domain cookie to force a new
session but we have been unable to manually expire the domain cookie with
CFCOOKIE.

Any ideas?  We're desperate!

Thanks,
Chris

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184335
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: OT: flowchart diagrams - best tools & guides?

[Damien McKenna]

I found the following guide on flowcharts:
http://www.fh-jena.de/~kleine/history/software/IBM-FlowchartingTechniques-GC20-8152-1.pdf
 

Its from 1969 and mentions things like punch cards, card deck, magnetic 
drums, etc.

Then I found this good guide to the basic symbols:
http://www.smartdraw.com/tutorials/flowcharts/basic.htm
Then just use Dia  and I'm set.
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 

The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
"Why are you wearing that stupid man suit?" - Frank

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184336
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

List Contains

[Stuart Kidd]

Hi guys,

I'm having problems with lists.

I displayed a list of all article titles (and IDs) that could relate to a
specific title and the user can select which ones can be links (via a select
form).

That part is all good and it inserts the comma separated list into the field
articleRelatedLinks (something like 37, 76, 84, 99).

Then when I would like the user to be able to update the form is when I have
the problem.

The problem I'm having below is that it only seems to select the first
number in the list - it doesn't see it as a list but one field.

 Article Related Links

  

 

  selected>#showTitles.articleTitle#

 

  

 

Is there a way I can loop it through the list or am I going around it the
wrong way.

Any help will be appreciated.

Thanks,

Saturday.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184337
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: OT: flowchart diagrams - best tools & guides?

[Stephen Hait]

Here's a link to a shareware flowchart product that works pretty 
well on Windows:

http://www.paraben.com/html/flow.html

Stephen

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184338
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: List Contains

[Jerry Johnson]

You are almost there. Two problems.

First, you are going to want listFind, rather than listContains, I think. 
listContains is not an exact match. looking for "5" will find "5" and "35" and 
"50".
Second, are there really spaces after the , in the list? If so, I think you'll 
want to get rid of them. "5" will not match " 5"

If you are still having problems, could you send the exact relatedLinks value, 
and a couple of ID values to see if there is some reason they aren't matching?

Thanks,


Jerry Johnson
Web Developer
Dolan Media Company

>>> [EMAIL PROTECTED] 11/15/04 05:29PM >>>



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184339
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: List Contains

[Al Everett]

Looks like you need ListFind(), not ListContains().

ListFind looks at the entire element, while ListContains looks at
substrings.



ListFind(myList,7) will return 15

ListContains(myList,7) will return 5 (which is the element 17)


--- Stuart Kidd <[EMAIL PROTECTED]> wrote:

> Hi guys,
> 
> I'm having problems with lists.
> 
> I displayed a list of all article titles (and IDs) that could relate to
> a
> specific title and the user can select which ones can be links (via a
> select
> form).
> 
> That part is all good and it inserts the comma separated list into the
> field
> articleRelatedLinks (something like 37, 76, 84, 99).
> 
> Then when I would like the user to be able to update the form is when I
> have
> the problem.
> 
> The problem I'm having below is that it only seems to select the first
> number in the list - it doesn't see it as a list but one field.
> 
>  Article Related Links
> 
>   
> 
>  
> 
>ListContains(showArticle.articleRelatedLinks,
>
showTitles.articleID)>selected>#showTitles.articleTitle#
> 
>  
> 
>   
> 
>  
> 
> Is there a way I can loop it through the list or am I going around it
> the
> wrong way.
> 
> Any help will be appreciated.
> 
> Thanks,
> 
> Saturday.
> 
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184340
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

OT - DWMX

[Stephen Cowling]

Hey everyone, apologies for the off topic post.

Is there a way to customise the predefined code that is displayed when 
you select a new document type?

Does that make sense? DW help tells me that the thing I am talking about 
is a Dreamweaver Design File. Can I create my own? Or at the very least 
edit the default ones?

Thanks in advance

Steve


-- 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184341
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: OT - DWMX

[Stephen Cowling]

And then the next thing I guess, is there a way to populate it 
dynamically? for example with todays date?

Cheers
Steve

Stephen Cowling wrote:

> Hey everyone, apologies for the off topic post.
> 
> Is there a way to customise the predefined code that is displayed when 
> you select a new document type?
> 
> Does that make sense? DW help tells me that the thing I am talking about 
> is a Dreamweaver Design File. Can I create my own? Or at the very least 
> edit the default ones?
> 
> Thanks in advance
> 
> Steve
> 
> 

-- 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184342
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

Losing Session Variable

[Scott Brady]

I've seen this general topic come up in the past, but I haven't been
able to find an example in the archives that matches our current
situation.

We have a multi-step form process.  When you submit the form step 1,
you get to step 2 just fine. When you submit step 2, you should end up
at step 3.  However, we're finding that the jsessionid changes going
from step 2 to the action page of step 2 (doing a dump in the
application.cfm file shows that it happens right away).  The cfid and
cftoken stay the same.

This happens on both a production box and a stage box.  [The
production box isn't actually live yet, because we are changing hosts
to this new production box this weekend]

I believe I just found the issue.  It's the multipart enctype.  That
causes the session id to change.

Any ideas why?

Scott

-- 
-
Scott Brady
http://www.scottbrady.net/

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184343
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: List Contains

[Stuart Kidd]

Thanks for your help Jerry and Al!

I'm still having that problem where it only finds a few of the numbers in
the list.  The field is set as a varchar(200) that shouldn't be a problem
should it?

I broke the code down so it's easier to read and only specifically targets
one particular row (just for my testing):



SELECT *
FROM tbl_020articleDetails
WHERE articleID = 61




SELECT articleID, articleTitle
FROM tbl_020articleDetails


Article Related Links



selected>#articleTitle#






The field articleRelatedLinks (row 61) has this information:

13,7,64,8,14,21,63,37,76,15

It's really bizzare how it is only picking up a few pieces of the list.

Any help would be great,

Thanks,

Saturday.





On 15/11/04 10:33 pm, "Jerry Johnson" <[EMAIL PROTECTED]> wrote:

> You are almost there. Two problems.
> 
> First, you are going to want listFind, rather than listContains, I think.
> listContains is not an exact match. looking for "5" will find "5" and "35" and
> "50".
> Second, are there really spaces after the , in the list? If so, I think you'll
> want to get rid of them. "5" will not match " 5"
> 
> If you are still having problems, could you send the exact relatedLinks value,
> and a couple of ID values to see if there is some reason they aren't matching?
> 
> Thanks,
> 
> 
> Jerry Johnson
> Web Developer
> Dolan Media Company
> 
 [EMAIL PROTECTED] 11/15/04 05:29PM >>>
> 
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184344
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: OT - DWMX

[dave]

C:\Program Files\Macromedia\Dreamweaver MX 
2004\Configuration\DocumentTypes\NewDocuments
pick the doc type u want and edit & save it
dont know about doing it dynamically though







-- Original Message --
From: Stephen Cowling <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 16 Nov 2004 09:56:55 +1100

>And then the next thing I guess, is there a way to populate it 
>dynamically? for example with todays date?
>
>Cheers
>Steve
>
>Stephen Cowling wrote:
>
>> Hey everyone, apologies for the off topic post.
>> 
>> Is there a way to customise the predefined code that is displayed when 
>> you select a new document type?
>> 
>> Does that make sense? DW help tells me that the thing I am talking about 
>> is a Dreamweaver Design File. Can I create my own? Or at the very least 
>> edit the default ones?
>> 
>> Thanks in advance
>> 
>> Steve
>> 
>> 
>
>-- 
>
>
>

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184345
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: OT - DWMX

[Stephen Cowling]

ahh thanks. too easy.

Steve

dave wrote:

> C:\Program Files\Macromedia\Dreamweaver MX 
> 2004\Configuration\DocumentTypes\NewDocuments
> pick the doc type u want and edit & save it
> dont know about doing it dynamically though
> 
> 
> 
> 
> 
> 
> 
> -- Original Message --
> From: Stephen Cowling <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date:  Tue, 16 Nov 2004 09:56:55 +1100
> 
> 
>>And then the next thing I guess, is there a way to populate it 
>>dynamically? for example with todays date?
>>
>>Cheers
>>Steve
>>
>>Stephen Cowling wrote:
>>
>>
>>>Hey everyone, apologies for the off topic post.
>>>
>>>Is there a way to customise the predefined code that is displayed when 
>>>you select a new document type?
>>>
>>>Does that make sense? DW help tells me that the thing I am talking about 
>>>is a Dreamweaver Design File. Can I create my own? Or at the very least 
>>>edit the default ones?
>>>
>>>Thanks in advance
>>>
>>>Steve
>>>
>>>
>>
>>-- 
>>
>>
>>
> 
> 
> 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184346
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: Error in CFX_Excel Tag

[Jim Watkins]

>I have upgraded to Windows 2003 and now my CFX_Excel tag no longer
>works.  I use IIS and CF 6.1  I have registered the tag.  I get the
>"Can't start Excel"  error.  Please help!
>
>Jim Watkins
>VP Technology & Inst Svcs
>706 781-2305 - Blairsville
>706 754-7850 - Clarkesville
>[EMAIL PROTECTED]
>http://www.northgatech.edu

Retry

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184347
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