No focus on page, when page loads

2008-02-28 Thread ismail cassiem
Hi, i'm using an xslt file that loads my page - which does not use a body. 

The problem i have is that everytime i open the page the focus is on the submit 
button. I don't really want that - where i just want no focus when the page 
opens up. I geuss a javascript is needed but i also dont have a body tag! 

Any ideas!

Please assist!

Regards 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300148
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: An effort to make cold fusion 8 standard edition more efficie nt

2008-02-28 Thread John Mason
>IIS supports compression, but it's a PITA to configure.  Of course MS 
>doesn't provide any sort of GUI for this and you have to edit their xml
file... 

Actually you don't, if you want to use IIS compression, there is a plugin
called  HttpZip by Port80. It's a GUI plugin to manage the IIS settings for
this.

http://www.port80software.com/products/httpzip/

They also have several other tools for IIS configurations.

John Mason
[EMAIL PROTECTED]
770.337.8363
 
www.FusionLink.com - ColdFusion and Flex hosting
Now offering ColdFusion 8 Enterprise hosting
FREE Subversion hosting


-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 29, 2008 12:26 AM
To: CF-Talk
Subject: RE: An effort to make cold fusion 8 standard edition more efficie
nt

IIS supports compression, but it's a PITA to configure.  Of course MS
doesn't provide any sort of GUI for this and you have to edit their xml
file... 

Apache also supports compression and is much easier to configure.  

FusionReactor supports compression as well for CF content. 

Russ

> -Original Message-
> From: Don L [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 28, 2008 9:11 PM
> To: CF-Talk
> Subject: Re: An effort to make cold fusion 8 standard edition more 
> efficie nt
> 
> Thanks for the idea, Dave, unfortunately my version of the web server 
> does not seem to support compression, oddly it has a dll for
compression...
> I'll probably need to do more research...
> 
> Don
> >
> >Yes, if your web server is configured to gzip static files, these 
> >files
> will
> >be gzipped. All CF does is write the SCRIPT tags that reference the 
> >.js files.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >
> >Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
> >http://training.figleaf.com/
> >
> >WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> >http://www.webmaniacsconference.com/
> 
> 



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300147
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: An effort to make cold fusion 8 standard edition more efficie nt

2008-02-28 Thread Russ
IIS supports compression, but it's a PITA to configure.  Of course MS
doesn't provide any sort of GUI for this and you have to edit their xml
file... 

Apache also supports compression and is much easier to configure.  

FusionReactor supports compression as well for CF content. 

Russ

> -Original Message-
> From: Don L [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 28, 2008 9:11 PM
> To: CF-Talk
> Subject: Re: An effort to make cold fusion 8 standard edition more efficie
> nt
> 
> Thanks for the idea, Dave, unfortunately my version of the web server does
> not seem to support compression, oddly it has a dll for compression...
> I'll probably need to do more research...
> 
> Don
> >
> >Yes, if your web server is configured to gzip static files, these files
> will
> >be gzipped. All CF does is write the SCRIPT tags that reference the .js
> >files.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >
> >Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> >http://training.figleaf.com/
> >
> >WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> >http://www.webmaniacsconference.com/
> 
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300146
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: An effort to make cold fusion 8 standard edition more efficie nt

2008-02-28 Thread Rick Root
Yeah, that kind of compression is almost always a web server function.

On 2/28/08, Don L <[EMAIL PROTECTED]> wrote:
> Thanks for the idea, Dave, unfortunately my version of the web server does 
> not seem to support compression, oddly it has a dll for compression... I'll 
> probably need to do more research...
>
> Don
> >
> >Yes, if your web server is configured to gzip static files, these files will
> >be gzipped. All CF does is write the SCRIPT tags that reference the .js
> >files.
> >
> >Dave Watts, CTO, Fig Leaf Software
> >http://www.figleaf.com/
> >
> >Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> >http://training.figleaf.com/
> >
> >WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> >http://www.webmaniacsconference.com/
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300145
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: An effort to make cold fusion 8 standard edition more efficie nt

2008-02-28 Thread Don L
Thanks for the idea, Dave, unfortunately my version of the web server does not 
seem to support compression, oddly it has a dll for compression... I'll 
probably need to do more research...

Don
>
>Yes, if your web server is configured to gzip static files, these files will
>be gzipped. All CF does is write the SCRIPT tags that reference the .js
>files.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>
>Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
>http://training.figleaf.com/
>
>WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
>http://www.webmaniacsconference.com/ 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300144
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFLDAP problem

2008-02-28 Thread david reiter
I'm having a difficult time with a client's LDAP server. I'm using the
routine 2-query CFLDAP auth scheme that first confirms the username on
the nameserver using admin creds, then matches the username and password
using the user's creds. The code works fine on multiple other instances.
But I can't query one client's LDAP server beyond matching the username
via the filter. When I add the password, even without any other
attributes as filter="(unicode_Pwd=#FORM.userlogin#)", the query won't
execute. I can't query at all via basic security / port 636, and using
the unsecured default port acts as above.

I am also unable to match on attributes their admin swears are correct. I
can pull some (e.g. cn, firstName, givenName) but not others (e.g.
samaccountName). And I'm at the limits of my CFLDAP experience and
knowledge.   The client seems not to have anyone with expert knowledge of
their LDAP server.  Any ideas would be greatly appreciated.

Thanks!

David

-- 
Want an e-mail address like mine?
Get a free e-mail account today at www.mail.com!



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300143
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: comparing data in a loop

2008-02-28 Thread Richard White
i have seen the documentation on the query on a query and it says that distinct 
can be used and i have it exactly as in the example so i really dont know why 
that error is showing!

anyone seen this error before?

thanks


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300142
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: An effort to make cold fusion 8 standard edition more efficie nt

2008-02-28 Thread Dave Watts
> And on js, Gzip components is recommended, does the current 
> cf8 standard support that?  For instance, ext-core.js is 
> called by cf server instance, not manually called by a developer.

Yes, if your web server is configured to gzip static files, these files will
be gzipped. All CF does is write the SCRIPT tags that reference the .js
files.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300141
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Interesting idea for next CF - thoughts...

2008-02-28 Thread Jim Davis
> -Original Message-
> From: Brad Wood [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 28, 2008 9:13 AM
> To: CF-Talk
> Subject: RE: Interesting idea for next CF - thoughts...
> 
> Watch out for that though.  I remember someone on this list who used to
> use the extends="" attribute in their cfcomponent tags.  That worked
> great until CF8 when Adobe actually implemented that attribute and all
> their code broke.  :)

Yeah... you really can't use any "common" words.

Since my imprint in the "DepressedPress" I prefix everything with "DP_"...
something like that should keep it off any reserved word lists.  ;^)

Jim Davis


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300140
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: How accurate is IP address / Geocode lookup?

2008-02-28 Thread Paul Hastings
Jeff Chastain wrote:
> I have a client that is looking to ascertain the state ( or country if not
> US based ) of the current visitor to their web site.  One possibility has
> been to use their IP address and a geocode lookup, which I have never done

the location you often get is where the IP block owner is located. for country 
level, IP lookups are > 90% accurate (our geoLocator CFC stops at 
country/locale 
info). accuracy drops off the smaller the administrative unit you want to find, 
where the client is physically located (somebody along a state/province border 
could go either way) & the ISP involved (AOL is a famous extreme case where 
every user's state, etc. is "AOL" & satellite-based ISPs will also screw you up 
even at the country level).

that said, if you're not using the location to deliver packages or drop bombs 
it's probably good enough, especially if you use a manual fallback mechanism.

there's supposedly more accurate means of measuring where a given IP is 
physically located:

http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry=831F21D5-20ED-7DEE-2AFB50CC1481BAC1

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300139
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: How accurate is IP address / Geocode lookup?

2008-02-28 Thread Ben Forta
I've used this product, integrates with CF, too:

http://www.cyscape.com/products/chawk/

--- Ben


-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 5:42 PM
To: CF-Talk
Subject: Re: How accurate is IP address / Geocode lookup?

 From what I understand, it's usually the ISP.  However, it is often the 
last hop before the actual client, so it would only be inaccurate if, 
say, the person was in TN and the ISP was in KY.

That said, at my last job, we were in KY, and we showed up as in (I 
think) PA, since that was where the router for static IPs was.  Alltel 
was our ISP, IIRC.

So it's a good approximation, but I would not rely on it for calculating 
sales tax.  :-)

--Doom

Jeff Chastain wrote:
> I have a client that is looking to ascertain the state ( or country if not
> US based ) of the current visitor to their web site.  One possibility has
> been to use their IP address and a geocode lookup, which I have never done
> before.  So, how accurate is doing a geocode lookup based upon IP?  Does
it
> really give the user's location or more often the ISP's location?
> 
>  
> 
> Any feedback would be appreciated.
> 
>  
> 
> Thanks.
> 
> 
> 
> 



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300138
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: SOT - SQL Union Problem

2008-02-28 Thread Mark Henderson
And thanks to Ben as well (and anyone else I missed), who also went into
NoSpamToday (usually a product I have no hassles with).

Mark


-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED] 
Sent: 29 February 2008 04:42
To: CF-Talk
Subject: Re: SOT - SQL Union Problem

I'm not an SQL guru, so take this with a grain of salt:

You could do a join on table1.firstname=table2.firstname and 
table1.firstname = table2.lastname to get all the results that match.

You could union this to two unioned selects where there's an entry in 
table1 but not table2 and vice versa.  You'll have to select empty 
strings for the columns that are only present in one or the other table.

This should give you a result set where you either have the addresses 
from one, or the other, or both.  You can make display (or further 
processing) decisions based on that.

--Ben Doom


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300137
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: SOT - SQL Union Problem

2008-02-28 Thread Mark Henderson
Sonny,

Sorry for the delay, as your original message got eaten by NoSpamToday
on our Exchange server (go figure) and my time zone tends to have me in
bed when the *rest of the world* is hard at work. 

Awesome, thanks (yes I think it worked)! 

I do have one question however - when I do the original union on just
first and last names I get a record count of 1192, but when using your
union and left outer join I have 1202. Just an interesting side note but
it does appear to be doing what I want, so I wont delve into the
intricacies too much.  

Once again, the assistance is much appreciated.

Mark 


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300136
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Gerald Guido
If you are looking fir some pre-rolled alternatives to CF's AJAX offerings
you can take a look here.

http://ajaxrain.com/

This WYSIWYG was on the front page:

http://projects.bundleweb.com.ar/jWYSIWYG/

I just ran into this today BTW so I cannot comment on their offerings


On Thu, Feb 28, 2008 at 5:48 PM, Don L <[EMAIL PROTECTED]> wrote:

> Tom, thanks for the pointer... after scanning the relevant doc a bit
> more...
>
> Particuarly the following on the CFAJAXIMPORT tag,
> "You can have only ONE scriptsrc attribute on a page, in a cfajaximport
> tag or a cfform tag. You can use a scriptsrc attribute in a cfajaximport tag
> to apply its value to all forms on a page."
>
> In the case of, cfgrid, cftextarea, they are parts of CFFORM family, so, I
> need to figure out, the dependences (all the related js scripts for each
> including FukEditor...), then, package them into one...
> has anyone done that, any one interested in working with me on that (cut
> down time...)
>
> Appreciated.
>
> Don
> >Check the docs. I'm pretty sure you can lighten up the scripts.
> >
> >
> >--
> >Thanks,
> >
> >Tom
> >
> >Tom McNeer
> >MediumCool
> >http://www.mediumcool.com
> >1735 Johnson Road NE
> >Atlanta, GA 30306
> >404.589.0560
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300135
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Don L
Thank you for sharing your insights, Gerald, 

option one of redoing the design for optimal performance gain on the part of 
the inadequacy of some of the core js compoments within the cf8 context would 
be very time-consuming...

option two of nudging/pleading with Adobe to add more best resources like Ben 
Forta in the design, overseeing and improvements of their flagship product like 
Cold Fusion 8 over their third world developers would help...

option three...


Don

>I have been evaluating inline JS editors for years and I can say that I have
>not very been happy with any of them so far. Even with the best of them a
>user can mangle a well formed page in no time flat. And not to mention that
>JS can be extreemly picky and temperamental. We are dealing with a googie
>spell issue right now that is getting on our nerves. I am not all that
>suprised that you are having problems with placing an editor in a complex
>cfwindow design.
>
>The JS files that comes out of the box with CF 8 are large, as some of the
>JS libraries to begin with. The Ext-all library is 450+ k even with all the
>white space trimmed out. It is just the nature of the beast.
>
>IMO your best bet would be to forgo CF's built-in AJAX components and roll
>your own using the available libraries like EXT, Jquery, YUI or what ever
>best suits your needs.
>
>If you are worried about load time you can turn on compression on the server
>or roll your own (I have read about people doing it with cf a while back).
>
>,
>
>Got to the site and down load it. You can build your own ext library using
>only what you need.
>
>
>
>
>On Thu, Feb 28, 2008 at 4:50 PM, D
>
>> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300134
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Don L
Tom, thanks for the pointer... after scanning the relevant doc a bit more...

Particuarly the following on the CFAJAXIMPORT tag, 
"You can have only ONE scriptsrc attribute on a page, in a cfajaximport tag or 
a cfform tag. You can use a scriptsrc attribute in a cfajaximport tag to apply 
its value to all forms on a page."

In the case of, cfgrid, cftextarea, they are parts of CFFORM family, so, I need 
to figure out, the dependences (all the related js scripts for each including 
FukEditor...), then, package them into one... 
has anyone done that, any one interested in working with me on that (cut down 
time...)

Appreciated.

Don
>Check the docs. I'm pretty sure you can lighten up the scripts.
>
>
>-- 
>Thanks,
>
>Tom
>
>Tom McNeer
>MediumCool
>http://www.mediumcool.com
>1735 Johnson Road NE
>Atlanta, GA 30306
>404.589.0560 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300133
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Prevent users from voting twice.

2008-02-28 Thread Porter, Benjamin L.
Why not use some sort of captcha they have to enter in addition to
selecting the item they wish to vote for. It is hard to automate reading
captcha. That combined with a cookie will reduce the amount of
duplicates.
 
This email may contain material confidential to
Pearson.  If you were not an intended recipient, 
please notify the sender and delete all copies. 
We may monitor email to and from our network. 


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300132
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Gerald Guido
I have been evaluating inline JS editors for years and I can say that I have
not very been happy with any of them so far. Even with the best of them a
user can mangle a well formed page in no time flat. And not to mention that
JS can be extreemly picky and temperamental. We are dealing with a googie
spell issue right now that is getting on our nerves. I am not all that
suprised that you are having problems with placing an editor in a complex
cfwindow design.

The JS files that comes out of the box with CF 8 are large, as some of the
JS libraries to begin with. The Ext-all library is 450+ k even with all the
white space trimmed out. It is just the nature of the beast.

IMO your best bet would be to forgo CF's built-in AJAX components and roll
your own using the available libraries like EXT, Jquery, YUI or what ever
best suits your needs.

If you are worried about load time you can turn on compression on the server
or roll your own (I have read about people doing it with cf a while back).

>>Ok, so, show me some trick on trimming down ext-core.js (repackaging vs ?)
,

Got to the site and down load it. You can build your own ext library using
only what you need.




On Thu, Feb 28, 2008 at 4:50 PM, Don L <[EMAIL PROTECTED]> wrote:

> Sam Farmer got me started with YSlow (performance tool), thanks, Sam.
>
> With this tool, one can tell, some of the major memory hoggers include:
> ext-core.js (77k)
> grid.js (53k) -- when one looks at all the "amenties", needed or not, one
> would know this thing is going to cost ya, now, if I may, it would be so
> desirable to have, say, two options, a) light version; b) heavy one (load
> whatever you want)...
> one wonders what designers are doing with their job (not targeting against
> Adobe team...)...
>
> fukEditor_gecko.js (152.7k)
>
> Here's some more detail
> App memory load (without FckEditor): 927k
>(with FckEditor):1338k
>
> The difference is pretty substantial.
>
> Now, the alernative for text editor could be, YUIEditor or tinyMCE, both
> works fine for simple, straight page/form, however, neither would work
> within complex CFWINDOW.
>
> And on js, Gzip components is recommended, does the current cf8 standard
> support that?  For instance, ext-core.js is called by cf server instance,
> not manually called by a developer.
>
> Thanks.
>
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300131
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Don L
Yes, I meant, client/browser side memory.  Ok, so, show me some trick on 
trimming down ext-core.js (repackaging vs ?) , and how not to load 
fukEditor-gecko.js.  Wny?  I want it to speed up.  Thanks. 

>So, use the CF8 components for rapid prototyping. Refactor with straight 
>Ext for final app, optimizing what you need when you need it, and packed 
>in any fashion you find appropriate.
>
>You said that App memory load with FckEditor was 1338k? I'm guessing you 
>mean your client side memory load on your browser? And that you mean 
>'load', not the amount of data transferred across the wire? OK, so 
>what's the problem? Have you seen how much memory Word or Excel or 
>something takes? Right this moment, on my desktop, Outlook is using 
>68000k, Eclipse:237700, and Thunderbird: 156000. 400k is negligible.
>
>Steve "Cutter" Blades
>Adobe Certified Professional
>Advanced Macromedia ColdFusion MX 7 Developer
>_
>http://blog.cutterscrossing.com
>
>D
>> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300130
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: How accurate is IP address / Geocode lookup?

2008-02-28 Thread Jeff Chastain
Accurate as in at the state level within the US and from what you have said
plus a few tests I have run, this does not seem to be the case.

Thanks was what I needed.

Thanks.


-Original Message-
From: Dae [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 4:41 PM
To: CF-Talk
Subject: Re: How accurate is IP address / Geocode lookup?

I don't know what your idea of accurate is and I've never tested a large
enough sample size to be sure, but I say it's not accurate.

I say this because when I checked my IP address, it said I was in NJ.
Grabbed another IP and it showed PA.  I'm in MD.  I checked a friends IP and
it nailed him to his town.

On Thu, Feb 28, 2008 at 5:28 PM, Jeff Chastain <[EMAIL PROTECTED]> wrote:

> I have a client that is looking to ascertain the state ( or country if not
> US based ) of the current visitor to their web site.  One possibility has
> been to use their IP address and a geocode lookup, which I have never done
> before.  So, how accurate is doing a geocode lookup based upon IP?  Does
> it
> really give the user's location or more often the ISP's location?
>
>
>
> Any feedback would be appreciated.
>
>
>
> Thanks.
>
>
>
> 



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300129
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: How accurate is IP address / Geocode lookup?

2008-02-28 Thread Ben Doom
 From what I understand, it's usually the ISP.  However, it is often the 
last hop before the actual client, so it would only be inaccurate if, 
say, the person was in TN and the ISP was in KY.

That said, at my last job, we were in KY, and we showed up as in (I 
think) PA, since that was where the router for static IPs was.  Alltel 
was our ISP, IIRC.

So it's a good approximation, but I would not rely on it for calculating 
sales tax.  :-)

--Doom

Jeff Chastain wrote:
> I have a client that is looking to ascertain the state ( or country if not
> US based ) of the current visitor to their web site.  One possibility has
> been to use their IP address and a geocode lookup, which I have never done
> before.  So, how accurate is doing a geocode lookup based upon IP?  Does it
> really give the user's location or more often the ISP's location?
> 
>  
> 
> Any feedback would be appreciated.
> 
>  
> 
> Thanks.
> 
> 
> 
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300128
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: How accurate is IP address / Geocode lookup?

2008-02-28 Thread Dae
I don't know what your idea of accurate is and I've never tested a large
enough sample size to be sure, but I say it's not accurate.

I say this because when I checked my IP address, it said I was in NJ.
Grabbed another IP and it showed PA.  I'm in MD.  I checked a friends IP and
it nailed him to his town.

On Thu, Feb 28, 2008 at 5:28 PM, Jeff Chastain <[EMAIL PROTECTED]> wrote:

> I have a client that is looking to ascertain the state ( or country if not
> US based ) of the current visitor to their web site.  One possibility has
> been to use their IP address and a geocode lookup, which I have never done
> before.  So, how accurate is doing a geocode lookup based upon IP?  Does
> it
> really give the user's location or more often the ISP's location?
>
>
>
> Any feedback would be appreciated.
>
>
>
> Thanks.
>
>
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300127
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: comparing data in a loop

2008-02-28 Thread Richard White
you guys have really helped me out, thanks!!! i didnt even realise that i could 
do a query on a query. this will help tidy my code and business logic up no 
end. i am trying to do a combination of some of your suggestions as follows:

<--- this is the unique column array --->



<--- massImport is the name of the query --->

   
<--- then simply run the query --->

  #sqlQuery#



i have tried various tests with the query on query and overall it is working 
fine except when i put the distinct part on the query it produces an error 
saying: 

java.lang.Long cannot be cast to java.lang.String

however if i run a similar piece of code in mysql, it works fine. can anyone 
see what i have done wrong

thanks again for your help


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300126
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Help with Rewrite Rule! (circuit.fuseaction)

2008-02-28 Thread Kay Smoljak
On Fri, Feb 29, 2008 at 1:46 AM, cf coder <[EMAIL PROTECTED]> wrote:
>  however none of the images on this page get displayed. I looked at an image 
> property and the src which had the following src: 
> http://mysite/offers/books/images/bookimage/somebook.gif
>  I want it to be
>  http://mysite/images/bookimage/somebook.gif

Try http://mysite/"; /> (in the head of your document).
That will cause all css, js, image and links on the page to use
http://mysite/ as the base of relative requests.

-- 
Kay Smoljak
business: www.cleverstarfish.com
standards: kay.zombiecoder.com
coldfusion: kay.smoljak.com
personal: goatlady.wordpress.com

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300125
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Tom McNeer
>  if I may, it would be so desirable to have, say, two options, a) light
> version; b) heavy one (load whatever you want)...


I believe that you can load only the js pieces you need. By default, they
all come in. But I believe you can import them separately.

Check the docs. I'm pretty sure you can lighten up the scripts.


-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300124
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


How accurate is IP address / Geocode lookup?

2008-02-28 Thread Jeff Chastain
I have a client that is looking to ascertain the state ( or country if not
US based ) of the current visitor to their web site.  One possibility has
been to use their IP address and a geocode lookup, which I have never done
before.  So, how accurate is doing a geocode lookup based upon IP?  Does it
really give the user's location or more often the ISP's location?

 

Any feedback would be appreciated.

 

Thanks.



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300123
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: comparing data in a loop

2008-02-28 Thread Richard White
thanks this is a good idea


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300120
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Cutter (CFRelated)
So, use the CF8 components for rapid prototyping. Refactor with straight 
Ext for final app, optimizing what you need when you need it, and packed 
in any fashion you find appropriate.

You said that App memory load with FckEditor was 1338k? I'm guessing you 
mean your client side memory load on your browser? And that you mean 
'load', not the amount of data transferred across the wire? OK, so 
what's the problem? Have you seen how much memory Word or Excel or 
something takes? Right this moment, on my desktop, Outlook is using 
68000k, Eclipse:237700, and Thunderbird: 156000. 400k is negligible.

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Don L wrote:
> Sam Farmer got me started with YSlow (performance tool), thanks, Sam.
> 
> With this tool, one can tell, some of the major memory hoggers include:
> ext-core.js (77k)
> grid.js (53k) -- when one looks at all the "amenties", needed or not, one 
> would know this thing is going to cost ya, now, if I may, it would be so 
> desirable to have, say, two options, a) light version; b) heavy one (load 
> whatever you want)...
> one wonders what designers are doing with their job (not targeting against 
> Adobe team...)...
> 
> fukEditor_gecko.js (152.7k)
> 
> Here's some more detail
> App memory load (without FckEditor): 927k
> (with FckEditor):1338k
> 
> The difference is pretty substantial.
> 
> Now, the alernative for text editor could be, YUIEditor or tinyMCE, both
> works fine for simple, straight page/form, however, neither would work within 
> complex CFWINDOW. 
> 
> And on js, Gzip components is recommended, does the current cf8 standard 
> support that?  For instance, ext-core.js is called by cf server instance, not 
> manually called by a developer.
> 
> Thanks.
> 
> 
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300122
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: comparing data in a loop

2008-02-28 Thread Richard White
hi,

thanks for all your replies

and thanks charlie this is a very elegant solution :) i didn't even know about 
this function, thanks again

richard 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300121
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


An effort to make cold fusion 8 standard edition more efficient

2008-02-28 Thread Don L
Sam Farmer got me started with YSlow (performance tool), thanks, Sam.

With this tool, one can tell, some of the major memory hoggers include:
ext-core.js (77k)
grid.js (53k) -- when one looks at all the "amenties", needed or not, one would 
know this thing is going to cost ya, now, if I may, it would be so desirable to 
have, say, two options, a) light version; b) heavy one (load whatever you 
want)...
one wonders what designers are doing with their job (not targeting against 
Adobe team...)...

fukEditor_gecko.js (152.7k)

Here's some more detail
App memory load (without FckEditor): 927k
(with FckEditor):1338k

The difference is pretty substantial.

Now, the alernative for text editor could be, YUIEditor or tinyMCE, both
works fine for simple, straight page/form, however, neither would work within 
complex CFWINDOW. 

And on js, Gzip components is recommended, does the current cf8 standard 
support that?  For instance, ext-core.js is called by cf server instance, not 
manually called by a developer.

Thanks.


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300119
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: comparing data in a loop

2008-02-28 Thread Charlie Griefer
On Thu, Feb 28, 2008 at 12:16 PM, Richard White <[EMAIL PROTECTED]> wrote:
> hi,
>
>  i know there must be a simple answer to this but i am braindead right now 
> and cannot think of it. this is more of a logic question, and i am lacking it 
> right now :) i would appreciate your help please
>
>  i have data in a query, e.g.
>
>  col1   col2   col3
>  ---
>  1  2  3
>  1  2  4
>  1  3  1
>  etc
>
>  i need to be able to check that no 2 rows have the same data
>  the problem is, is that i dont know how many columns there will be and i 
> dont know what the unique columns will be. but i have the query and i have an 
> array of unique columns
>
>  for example i have 'col1' and 'col2' in an array called uniqueColumns()
>
>  so i need to somehow search through the query to ensure that no 2 rows 
> contain the same data - but only in the unique columns.
>
>  so on the above example if i did have col1 and col2 in the uniqueColumns 
> array then when searching through the query i need it to tell me that row 1 
> and 2 have matching unique columns as they both contain:
>
>  col1 = 1
>  col2 = 2

create a valueList for each column in the array.  use a compare() or
compareNoCase() on the resulting lists.


-- 
Evelyn the dog, having undergone further modification pondered the
significance of short-person behaviour in pedal depressed,
pan-chromatic resonance, and other highly ambient domains. "Arf," she
said.

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300118
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: comparing data in a loop

2008-02-28 Thread Mark Fuqua
Combine the columns using an alias and query for DISTINCT?

-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 28, 2008 3:16 PM
To: CF-Talk
Subject: comparing data in a loop


hi,

i know there must be a simple answer to this but i am braindead right now
and cannot think of it. this is more of a logic question, and i am lacking
it right now :) i would appreciate your help please

i have data in a query, e.g.

col1   col2   col3
---
1  2  3
1  2  4
1  3  1
etc

i need to be able to check that no 2 rows have the same data
the problem is, is that i dont know how many columns there will be and i
dont know what the unique columns will be. but i have the query and i have
an array of unique columns

for example i have 'col1' and 'col2' in an array called uniqueColumns()

so i need to somehow search through the query to ensure that no 2 rows
contain the same data - but only in the unique columns.

so on the above example if i did have col1 and col2 in the uniqueColumns
array then when searching through the query i need it to tell me that row 1
and 2 have matching unique columns as they both contain:

col1 = 1
col2 = 2

i would be very grateful of your help

thanks

richard



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300117
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: comparing data in a loop

2008-02-28 Thread Sonny Savage
Copy and paste error:


On Thu, Feb 28, 2008 at 3:37 PM, Sonny Savage <[EMAIL PROTECTED]> wrote:

> It might be useful to know that you can reference query objects like a
> struct of arrays: QueryName['ColumnName'][1]
>
> So
> 
> 
> 
>  QueryName[ColNameA][QueryName.CurrentRow]>
> 
> 
> 
>
> This might be something that would be accomplished better in the SQL
> statement though.  A more specific description of the issue would be
> helpful.
>
>
> On Thu, Feb 28, 2008 at 3:16 PM, Richard White <[EMAIL PROTECTED]> wrote:
>
> > hi,
> >
> > i know there must be a simple answer to this but i am braindead right
> > now and cannot think of it. this is more of a logic question, and i am
> > lacking it right now :) i would appreciate your help please
> >
> > i have data in a query, e.g.
> >
> > col1   col2   col3
> > ---
> > 1  2  3
> > 1  2  4
> > 1  3  1
> > etc
> >
> > i need to be able to check that no 2 rows have the same data
> > the problem is, is that i dont know how many columns there will be and i
> > dont know what the unique columns will be. but i have the query and i have
> > an array of unique columns
> >
> > for example i have 'col1' and 'col2' in an array called uniqueColumns()
> >
> > so i need to somehow search through the query to ensure that no 2 rows
> > contain the same data - but only in the unique columns.
> >
> > so on the above example if i did have col1 and col2 in the uniqueColumns
> > array then when searching through the query i need it to tell me that row 1
> > and 2 have matching unique columns as they both contain:
> >
> > col1 = 1
> > col2 = 2
> >
> > i would be very grateful of your help
> >
> > thanks
> >
> > richard
> >
> > 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300116
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: comparing data in a loop

2008-02-28 Thread Sonny Savage
It might be useful to know that you can reference query objects like a
struct of arrays: QueryName['ColumnName'][1]

So








This might be something that would be accomplished better in the SQL
statement though.  A more specific description of the issue would be
helpful.

On Thu, Feb 28, 2008 at 3:16 PM, Richard White <[EMAIL PROTECTED]> wrote:

> hi,
>
> i know there must be a simple answer to this but i am braindead right now
> and cannot think of it. this is more of a logic question, and i am lacking
> it right now :) i would appreciate your help please
>
> i have data in a query, e.g.
>
> col1   col2   col3
> ---
> 1  2  3
> 1  2  4
> 1  3  1
> etc
>
> i need to be able to check that no 2 rows have the same data
> the problem is, is that i dont know how many columns there will be and i
> dont know what the unique columns will be. but i have the query and i have
> an array of unique columns
>
> for example i have 'col1' and 'col2' in an array called uniqueColumns()
>
> so i need to somehow search through the query to ensure that no 2 rows
> contain the same data - but only in the unique columns.
>
> so on the above example if i did have col1 and col2 in the uniqueColumns
> array then when searching through the query i need it to tell me that row 1
> and 2 have matching unique columns as they both contain:
>
> col1 = 1
> col2 = 2
>
> i would be very grateful of your help
>
> thanks
>
> richard
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300115
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: SOT - SQL Union Problem

2008-02-28 Thread Sonny Savage
Did that work for you Mark?

On Thu, Feb 28, 2008 at 11:26 AM, Sonny Savage <[EMAIL PROTECTED]>
wrote:

> This should do it.  There's a union and a left outer join.  I hope this
> works in Access, I've never used it...
> /* First Get Centennial Members */
> SELECT FirstName
> , LastName
> , Address1
> , Address2
> , City
> , Country
> FROM tblCentennialMembers
>
> /* Now Get Members who are in the Foundation but aren't Centennial Members
> */
> UNION
> SELECT m.FirstName1 AS FirstName
> , m.SurName1 AS LastName
> , m.Add1 AS Address1
> , m.Add2 AS Address2
> , m.City
> , m.Country
> FROM tblMain m
> LEFT OUTER JOIN tblCentennialMembers cm
> ON m.FirstName1 =  cm.FirstName
> AND m.SurName1 = cm.LastName
> WHERE m.Foundation = Yes
> AND cm.FirstName IS NULL /* Removes Centennial Members Records from result
> */
>
>
> On Wed, Feb 27, 2008 at 9:11 PM, Mark Henderson <[EMAIL PROTECTED]> wrote:
>
> > OK, so that was working, and those are the only two fields I want to
> > union on, which is fine. But now I also want to add the address fields
> > to the query result, without doing a  union on those additional fields.
> > Some addresses aren't entered quite right, and this will then create
> > duplicates even though the query doesn't see them as such - does that
> > make sense?
> >
> > So, for instance, when I do:
> >
> > SELECT FirstName1 AS FirstName, Surname1 AS LastName
> > FROM tblMain
> > WHERE foundation = Yes
> > UNION
> > SELECT FirstName, LastName
> > FROM tblCentennialMembers;
> >
> > I get the result set I want. But if I do
> >
> > SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City,
> > Country
> > FROM tblMain
> > WHERE foundation = Yes
> > UNION
> > SELECT FirstName, LastName, Address1, Address2, City, Country
> > FROM tblCentennialMembers;
> >
> > It returns almost everything including the duplicates since add1 doesn't
> > always match address1, even though the first and last names match.
> >
> > So, how to get the extra fields into the original result set while only
> > doing a union on first and last names?
> >
> >
> > Mark
> >
> >
> > 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300114
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


comparing data in a loop

2008-02-28 Thread Richard White
hi, 

i know there must be a simple answer to this but i am braindead right now and 
cannot think of it. this is more of a logic question, and i am lacking it right 
now :) i would appreciate your help please

i have data in a query, e.g.

col1   col2   col3
---
1  2  3
1  2  4
1  3  1
etc

i need to be able to check that no 2 rows have the same data
the problem is, is that i dont know how many columns there will be and i dont 
know what the unique columns will be. but i have the query and i have an array 
of unique columns

for example i have 'col1' and 'col2' in an array called uniqueColumns()

so i need to somehow search through the query to ensure that no 2 rows contain 
the same data - but only in the unique columns.

so on the above example if i did have col1 and col2 in the uniqueColumns array 
then when searching through the query i need it to tell me that row 1 and 2 
have matching unique columns as they both contain:

col1 = 1
col2 = 2

i would be very grateful of your help

thanks

richard 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300113
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Interesting idea for next CF - thoughts...

2008-02-28 Thread s. isaac dealey
> Lol.  You got me.  I meant implements="", not extends="".
> 
> That was the one CF8 introduced.  :)

Oh interfaces... that makes more sense. 

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

http://onTap.riaforge.org/blog



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300112
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Interesting idea for next CF - thoughts...

2008-02-28 Thread s. isaac dealey
> I've actually gone further and created my own comment tag and parsing
> engine for CFC development... probably "worse" that this to many
> people but it works wonders for me and allows me to self-document my
> code pretty darn well.

Not all that far-out for those of us who've worked with Fusedocs for
example. There's a similar XML dialect called SPEC that I created & used
for documenting functions and such in the onTap framework, though the
dialect itself was designed with the intention of being independent of
the language or framework, so you could use SPEC to document Java (or
create SPEC docs from JavaDocs) if you wanted. I use it in the framework
as a skeleton for displaying language reference in HTML format. 


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

http://onTap.riaforge.org/blog



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300111
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFLDAP & Security groups

2008-02-28 Thread Ian Skinner
Dan beauchemin wrote:
>  name="auth2"
> attributes="samaccountname"
> start="CN=Students,OU=_Groups,OU=_Users,DC=xx,DC=xx"
> filter="samaccountname=dbeauchemin"

You are only returning the 'samAccountName' attribute which is just the 
account name of the Group itself.  You either need to query the qroup 
record (as you are) and examine its 'member' attribute to see if 
contains the desired user or query the user record and examine its 
'memberOf' attribute to see if it contains the desired group.





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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300110
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: CFLDAP & Security groups

2008-02-28 Thread Dawson, Michael
Rather than querying the Students group, query the user account.

The attribute you want is "memberOf".  It will give you a list of groups
to which the user belongs.

Then, search that list for "Students".

m!ke 

-Original Message-
From: Dan beauchemin [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 12:34 PM
To: CF-Talk
Subject: CFLDAP & Security groups

Hi - 

Trying to query a security group in Active Directoy to determine if a
person belongs to it. I am getting no results when I run the below code
- but I know they are a memember of the "Students" group.

Any ideas appreciated.

Dan B

 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300109
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CFLDAP & Security groups

2008-02-28 Thread Dan beauchemin
Hi - 

Trying to query a security group in Active Directoy to determine if a person 
belongs to it. I am getting no results when I run the below code - but I know 
they are a memember of the "Students" group.

Any ideas appreciated.

Dan B

 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300108
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Help with CFLDAP and AD

2008-02-28 Thread Bonnie Woods
Thanks to you both for setting me on the right path. I figured out what I 
needed to do, and I'm now able to authorize users depending on their OUs. I 
really appreciate the help!
Bonnie

> Hi:
> I'm having trouble getting CFLDAP to work with my Active Directory. 
> Here's what I have so far:
> 
> Server name: server.xxx.yyy.edu
> Active directory structure: 
> 
> xxx
  
> OU1 (organizational unit, not security group)

> User1
  
> OU2

> User2
> 
> I want to set up the CFLDAP tag so that it only authenticates users in 
> OU1 NOT anyone outside of OU1 (so User1 would authenticate, but User 2 
> would not). Here's my code:
> 
>action="query" 
>   name="qryUser" 
>   start="ou=OU1,dc=xxx,dc=yyy,dc=edu"
>   scope="subtree" 
>   attributes="*" filter="ou=OU1"

> server="server.xxx.yyy.edu" 
>   port="389" 
>   username="xxx\#Trim(user1)#" 
>   password="user1password">
> 
> The authentication works, but it will authenticate users in OU2 as 
> well as OU1. 
> Please help! Thanks.



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300107
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Help with CFLDAP and AD

2008-02-28 Thread Bonnie Woods
Thanks to you both for setting me on the right path. I figured out what I 
needed to do, and I'm now able to authorize users depending on their OUs. I 
really appreciate the help!
Bonnie 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300106
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Does Java version matter with cf8 (standard) performance?

2008-02-28 Thread Don L
Thank you for your thoughtful follow-up, Tom.

Don

>Don,
>
>Unfortunately, the answer is the usual: "it depends." Certainly, it depends
>on your application(s). And to some extent, it may depend on who you talk
>to.
>

>So how much of a problem the Java bug is -- or whether it's a problem for
>you at all -- depends very much on your situation.
>
>
>-- 
>Thanks,
>
>Tom
>
>Tom McNeer
>MediumCool
>http://www.mediumcool.com
>1735 Johnson Road NE
>Atlanta, GA 30306
>404.589.0560 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300105
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Does Java version matter with cf8 (standard) performance?

2008-02-28 Thread Tom McNeer
Don,

On Thu, Feb 28, 2008 at 11:36 AM, Don L <[EMAIL PROTECTED]> wrote:

> Per Mark Mandel's following piece,
> http://www.compoundtheory.com/?action=displayPost&ID=270
>
> Your thoughts/experience?


Unfortunately, the answer is the usual: "it depends." Certainly, it depends
on your application(s). And to some extent, it may depend on who you talk
to.

The issues Mark refers to are easily seen if you're using a lot of framework
stuff, and in particular, with Transfer. There's a lot of class loading
going on, and that can kill the performance. I ran into the issue in
deploying a client site, and we went through two hosting services before
Mark and Sean Corfleld blogged about this problem, and we realized it wasn't
the host's fault. There was a fair amount of discussion about the problem on
the Transfer list.

On the other hand, many people (including, of course, Adobe), say that it's
the combination of CF8 and Java 1.6 that provides the huge performance gains
shown in Adobe's benchmarking for CF8. So evidently, in most CF
non-framework-driven applications, the issue is overcome by other
performance gains.

When I ran into the problem, I discussed it with a contact I have at
CrystalTech, and they actually discussed the issue with Adobe. As Mark
suggests, both Adobe and Sun are aware of the problem. Sun just hasn't fixed
the bug yet. But CrystalTech (and other hosting services I've talked to) are
not willing to downgrade the Java version because it will hurt performance
for many/most of their customers.

In my case, I moved to a VPS where I was free to change the Java version,
and it made a gigantic difference. Of course, the VPS made a difference in a
lot of other ways.

So how much of a problem the Java bug is -- or whether it's a problem for
you at all -- depends very much on your situation.


-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300104
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Interesting idea for next CF - thoughts...

2008-02-28 Thread Jim Davis
>Jim Davis said: 
>> I know it won't validate, but can't you do that now?
>> 
>> I would expect CF to ignore any unknown attributes.
>
>Way back when, CF5 and prior, it would throw errors on attributes it
>didn't recognize. When CF6 was introduced they allowed you to add
>whatever arbitrary attributes you want to cfcomponent, cffunction,
>cfargument and cfproperty tags so you could use that metadata via
>getMetaData() -- with other tags I'm not sure, haven't tried it. But
>it's likely that the server might already ignore unrecognized attributes
>on tags by default. So yeah, you could possibly get away with it,
>although I tend to agree with Dave Watts' comments regarding its
>usefulness. 

As do I, personally.  But I'm also of two minds on the issue:

While I wouldn't use such a feature (for all the reasons already stated) some 
people clearly might.  In the end consistency and workability is more important 
to me.  If this guy finds this useful and, most importantly, is consistent with 
his usage then great.

Anything that lets us remember what the hell we were thinking a year later 
can't be all bad.  ;^)

Of course there are other considerations.  I think the most important one is 
"are you inflicting this system on others?"  If so, and they DON'T understand 
then your consistency means nothing - you must be consistent within your 
workgroup for anything like this to truly work.

I've actually gone further and created my own comment tag and parsing engine 
for CFC development... probably "worse" that this to many people but it works 
wonders for me and allows me to self-document my code pretty darn well.

In any case any documentation, whether it's via strict comments, code markup, 
naming conventions, etc is definately more good than bad.  But it only works 
really when everybody involved works together.

Jim Davis 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300103
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


schedule tasks gone missing?

2008-02-28 Thread Nick Tong
Hi All,

I've just been shocked by looking in my schedule tasks (after a cf upgrade)
to find no schedule tasks showing.  Now the tasks are running but i just
can't see them to administer them?  Does anyone know how i can access these
or make them show again?  A quick web search didn't return anything helpful.

Thanks in advance.

-- 
Nick Tong

web: http://talkwebsolutions.co.uk
blog: http://succor.co.uk
f..works:http://cfframeworks.com
short urls:  http://wapurl.co.uk
green link: http://wapurl.co.uk/?4Z2YDLX


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300102
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: unoffical ahphosting thread

2008-02-28 Thread CF Developer
>I am not going to blame Greg for SWSoft's F-up
 
Is AHP just one guy? What were you guys expecting? Greg chose to use SWSoft 
software. They may be at fault but he is responsible. Also if he makes an 
upgrade and doesn't have enough help if things go wrong, that is also his 
fault. SWSoft isn't to blame for over a week of downtime. That was Greg.
 
> Subject: re: unoffical ahphosting thread> From: [EMAIL PROTECTED]> To: 
> cf-talk@houseoffusion.com> Date: Wed, 27 Feb 2008 11:14:04 -0600> > I a have 
> been with them for a while and don't plan on leaving anytime soon.> While 
> this is a major ouch...I too have enjoyed the one on one relationship> with 
> greg and the speed at which he normally gets things done. My sites are> all 
> still down as of last night. He is normally very quick to address> problems 
> when they occur. Much like I don't blame MS for hardware> manufacturer's 
> failings, I am not going to blame Greg for SWSoft's F-up> ;-). THough I do 
> agree with some of theother comments...it would be nice to> have emails sent 
> out periodically even if just to say it's still broke, but> I am working on 
> it. Doing that would provide a good diversion from trying> to fix the 
> code...sometimes that helps get it done faster.> > Eric> > > 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Mark Kruger
Dave,

What's your take on heavy use of cfexecute and the shell - at least in
Windows we have found it to be a little dicey. Sometimes command shells are
left in the process space without terminating.

-Mark 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 10:36 AM
To: CF-Talk
Subject: RE: Sending File Data Over Webservice

> I have never used the symlink idea - although I've heard him mention 
> it before.  I'd be interested in a code snippet on how to do this "on 
> the fly" in Linux. Would you have to pass arguments to a shell script 
> Dave?

Yes, or in Windows, to a batch file that runs the Sysinternals tool
junction.exe. I suppose you could just invoke junction.exe directly with
CFEXECUTE, but I haven't tried that.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300100
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Help with Rewrite Rule! (circuit.fuseaction)

2008-02-28 Thread cf coder
Here's an example, I have a rule that translates 

http://mysite/index.cfm?offers.books&bookid=1 

to

http://mysite/offers/books/somebook

however none of the images on this page get displayed. I looked at an image 
property and the src which had the following src: 
http://mysite/offers/books/images/bookimage/somebook.gif 

I want it to be 

http://mysite/images/bookimage/somebook.gif 

where "images" is a virtual directory. Can anybody please suggest how this can 
be done?

Regards,

cfcoder 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300099
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Robert Rawlins - Think Blue
I wonder if this can also be done using underlying JAVA classes and things
like that? Might be worth looking around for some libraries.

Rob

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 28 February 2008 16:36
To: CF-Talk
Subject: RE: Sending File Data Over Webservice

> I have never used the symlink idea - although I've heard him 
> mention it before.  I'd be interested in a code snippet on 
> how to do this "on the fly" in Linux. Would you have to pass 
> arguments to a shell script Dave?

Yes, or in Windows, to a batch file that runs the Sysinternals tool
junction.exe. I suppose you could just invoke junction.exe directly with
CFEXECUTE, but I haven't tried that.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300098
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Does Java version matter with cf8 (standard) performance?

2008-02-28 Thread Don L
Per Mark Mandel's following piece,
http://www.compoundtheory.com/?action=displayPost&ID=270

Your thoughts/experience?

Thks. 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300097
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT - URL Rewriting, how many rules?

2008-02-28 Thread Barney Boisvert
mod_rewrite is a drop in a bucket compared to the ocean of a JEE
stack, let alone one with CF on it.

Using .htaccess is going to be more of a performance penalty, because
of all the extra per-request file IO.  Unless you have a compelling
reason (like shared hosting), you should put all your config in the
main config files.  If you want to version your rewriting config with
your app (usually what you want), then use an Include directive
instead of .htaccess.

I've used hundrends (maybe thousands?) of rewrite rules with no issue
and used rewrite maps with thousands of entries, both with no
discernible performance penalty.  Rewriting queries still provided the
best bang for your buck speeding things up.

cheers,
barneyb

On Thu, Feb 28, 2008 at 8:29 AM, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Sorry, very quick OT.
>
>  I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is
>  this too many?
>
>  Can anyone claim to have more and do you notice any performance hit?
>
>  Any links to info on this subject?
>
>  Thanks.
>
>  Adrian
>
>
>  

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300096
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: OT - URL Rewriting, how many rules?

2008-02-28 Thread Barney Boisvert
mod_rewrite is a drop in a bucket compared to the ocean of a JEE
stack, let alone one with CF on it.

Using .htaccess is going to be more of a performance penalty, because
of all the extra per-request file IO.  Unless you have a compelling
reason (like shared hosting), you should put all your config in the
main config files.  If you want to version your rewriting config with
your app (usually what you want), then use an Include directive
instead of .htaccess.

I've used hundrends (maybe thousands?) of rewrite rules with no issue
and used rewrite maps with thousands of entries, both with no
discernible performance penalty.  Rewriting queries still provided the
best bang for your buck speeding things up.

cheers,
barneyb

On Thu, Feb 28, 2008 at 8:29 AM, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> Sorry, very quick OT.
>
>  I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is
>  this too many?
>
>  Can anyone claim to have more and do you notice any performance hit?
>
>  Any links to info on this subject?
>
>  Thanks.
>
>  Adrian
>
>
>  

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300095
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JRun Clustering problem - Instance shutting down

2008-02-28 Thread James Buckingham
Right here's hoping that this doesn't start another thread as this is getting 
embrassing!!!

That second set are logs are obviously related to the drop of the instance and 
JRun starting to hand the sessions across to the other server. Not very helpful 
but still more information I can work on.

Yes you're right we do have another instance on that server and yeah it is 
strange that out of four instances only one is failing. Or what I should say is 
that the vast majority of fails are coming from there, we do get a few others 
"here and there" but nothing worth highlighting as an issue and related to this.

We're going to move the code from the other instance over to this one in the 
hope that this might fix it. The idea being that we might have a mismatch 
somewhere that is causing a problem so this would eliminate it this. Stab in 
the dark really though :-(.

Don't know about the shared VM side of things, I'll need to ask the System's 
guys about that one but again that kind of opens up the field to anything while 
we've definately got a lead with the JRun logs at the moment.

Thanks for your efforts though Brad, it's appreciated.

Cheers,
James



>Interesting.  I've got to give credit to someone at Macromedia for using
>the work "breakage".  :)  
>Well, it seems clear that IIS and the JRun connector are losing contact
>with the instance and subsequently removing it from the cluster.  What
>we don't know is why.  Did I understand that you have at least one other
>CF instance on the same physical box which does not experience this
>problem?  That would rule out OS and general connectivity problems.  I
>think you said it was on a VM.  Is that instance along on the VM, or are
>there more than one instance on that VM.  I don't know where to tell you
>to go from here.  Maybe someone else will chime in with an idea.
>
>Just ignore my comment about the "dedicated IIS box".  For some reason I
>had gotten it in my head that you had a separate physical server for
>IIS.  I guess I've got the load-balancing diagram stuck in my head that
>was posted yesterday on the list.  :)
>
>~Brad
>
>down"
>
>The log file was from the failing instance. It was residing in the
>C:\JRuns\Logs\ folder.
>
>IIS is sitting on both boxes so I'm not sure if that classes as a
>"dedicated IIS box". We have round robin on the DNS as well so requests
>are being passed to both boxes.
>
>I actually didn't know about those logs. You learn something new every
>day :-)
>
>Just looking at the same time as those previous logs these start 2
>milliseconds after the failure notice. Nothing was happening in these
>logs for a few hours before this...
>
>C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 
>
>2008-02-27 10:50:43 jrISAPI[2192:6480]  Sticky session breakage, a host
>for 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300094
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: OT - URL Rewriting, how many rules?

2008-02-28 Thread Dave Watts
> I have 20 odd rules in my .htaccess file and it may grow to 
> 40 or 60. Is this too many?
> 
> Can anyone claim to have more and do you notice any performance hit?
> 
> Any links to info on this subject?

The most I've seen in a production application was about 300, and it didn't
cause any noticeable problem. However, we didn't load test to ensure that.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300093
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


OT - URL Rewriting, how many rules?

2008-02-28 Thread Adrian Lynch
Sorry, very quick OT.

I have 20 odd rules in my .htaccess file and it may grow to 40 or 60. Is
this too many?

Can anyone claim to have more and do you notice any performance hit?

Any links to info on this subject?

Thanks.

Adrian


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300092
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Dave Watts
> I have never used the symlink idea - although I've heard him 
> mention it before.  I'd be interested in a code snippet on 
> how to do this "on the fly" in Linux. Would you have to pass 
> arguments to a shell script Dave?

Yes, or in Windows, to a batch file that runs the Sysinternals tool
junction.exe. I suppose you could just invoke junction.exe directly with
CFEXECUTE, but I haven't tried that.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300091
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT - SQL Union Problem

2008-02-28 Thread Sonny Savage
This should do it.  There's a union and a left outer join.  I hope this
works in Access, I've never used it...
/* First Get Centennial Members */
SELECT FirstName
, LastName
, Address1
, Address2
, City
, Country
FROM tblCentennialMembers

/* Now Get Members who are in the Foundation but aren't Centennial Members
*/
UNION
SELECT m.FirstName1 AS FirstName
, m.SurName1 AS LastName
, m.Add1 AS Address1
, m.Add2 AS Address2
, m.City
, m.Country
FROM tblMain m
LEFT OUTER JOIN tblCentennialMembers cm
ON m.FirstName1 =  cm.FirstName
AND m.SurName1 = cm.LastName
WHERE m.Foundation = Yes
AND cm.FirstName IS NULL /* Removes Centennial Members Records from result
*/

On Wed, Feb 27, 2008 at 9:11 PM, Mark Henderson <[EMAIL PROTECTED]> wrote:

> OK, so that was working, and those are the only two fields I want to
> union on, which is fine. But now I also want to add the address fields
> to the query result, without doing a  union on those additional fields.
> Some addresses aren't entered quite right, and this will then create
> duplicates even though the query doesn't see them as such - does that
> make sense?
>
> So, for instance, when I do:
>
> SELECT FirstName1 AS FirstName, Surname1 AS LastName
> FROM tblMain
> WHERE foundation = Yes
> UNION
> SELECT FirstName, LastName
> FROM tblCentennialMembers;
>
> I get the result set I want. But if I do
>
> SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City,
> Country
> FROM tblMain
> WHERE foundation = Yes
> UNION
> SELECT FirstName, LastName, Address1, Address2, City, Country
> FROM tblCentennialMembers;
>
> It returns almost everything including the duplicates since add1 doesn't
> always match address1, even though the first and last names match.
>
> So, how to get the extra fields into the original result set while only
> doing a union on first and last names?
>
>
> Mark
>
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300090
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: unofficial ahphosting thread

2008-02-28 Thread Charlie Griefer
I got a heads-up email on feb 15th with a subject of "AHPHosting
Maintentance event - VPS Upgrade Notice".

On Thu, Feb 28, 2008 at 8:01 AM, Eric Roberts
<[EMAIL PROTECTED]> wrote:
> My heads up was a buddy of mine telling me my sites were down
>
>  Eric
>
>  /*-Original Message-
>  /*From: Azadi Saryev [mailto:[EMAIL PROTECTED]
>  /*Sent: Wednesday, February 27, 2008 8:34 PM
>  /*To: CF-Talk
>  /*Subject: Re: unoffical ahphosting thread
>  /*
>  /*hmm... i never got any heads-up at all...
>  /*
>  /*Azadi Saryev
>  /*Sabai-dee.com
>  /*http://www.sabai-dee.com/
>  /*
>  /*Rick Faircloth wrote:
>  /*> Yes, I got the notice, too.
>  /*>
>  /*>
>  /*>> -Original Message-
>  /*>> From: Terry Schmitt [mailto:[EMAIL PROTECTED]
>  /*>> Sent: Wednesday, February 27, 2008 2:38 PM
>  /*>> To: CF-Talk
>  /*>> Subject: Re: unoffical ahphosting thread
>  /*>>
>  /*>> Greg did send out an upgrade email.
>  /*>>
>  /*>>> 3) to notify all clients of planned upgrades in advance, especially
>  /*>>> upgrades to something like virtualization software, like most hosting
>  /*>>> providers do
>  /*>
>  /*
>  /*
>
>  

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300089
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JRun Clustering problem - Instance keeps &quot;shutting down&quot;

2008-02-28 Thread Brad Wood
Interesting.  I've got to give credit to someone at Macromedia for using
the work "breakage".  :)  
Well, it seems clear that IIS and the JRun connector are losing contact
with the instance and subsequently removing it from the cluster.  What
we don't know is why.  Did I understand that you have at least one other
CF instance on the same physical box which does not experience this
problem?  That would rule out OS and general connectivity problems.  I
think you said it was on a VM.  Is that instance along on the VM, or are
there more than one instance on that VM.  I don't know where to tell you
to go from here.  Maybe someone else will chime in with an idea.

Just ignore my comment about the "dedicated IIS box".  For some reason I
had gotten it in my head that you had a separate physical server for
IIS.  I guess I've got the load-balancing diagram stuck in my head that
was posted yesterday on the list.  :)

~Brad

-Original Message-
From: James Buckingham [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 9:30 AM
To: CF-Talk
Subject: Re: JRun Clustering problem - Instance keeps "shutting
down"

The log file was from the failing instance. It was residing in the
C:\JRuns\Logs\ folder.

IIS is sitting on both boxes so I'm not sure if that classes as a
"dedicated IIS box". We have round robin on the DNS as well so requests
are being passed to both boxes.

I actually didn't know about those logs. You learn something new every
day :-)

Just looking at the same time as those previous logs these start 2
milliseconds after the failure notice. Nothing was happening in these
logs for a few hours before this...

C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 

2008-02-27 10:50:43 jrISAPI[2192:6480]  Sticky session breakage, a host
for 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300088
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: unofficial ahphosting thread

2008-02-28 Thread Eric Roberts
My heads up was a buddy of mine telling me my sites were down

Eric

/*-Original Message-
/*From: Azadi Saryev [mailto:[EMAIL PROTECTED]
/*Sent: Wednesday, February 27, 2008 8:34 PM
/*To: CF-Talk
/*Subject: Re: unoffical ahphosting thread
/*
/*hmm... i never got any heads-up at all...
/*
/*Azadi Saryev
/*Sabai-dee.com
/*http://www.sabai-dee.com/
/*
/*Rick Faircloth wrote:
/*> Yes, I got the notice, too.
/*>
/*>
/*>> -Original Message-
/*>> From: Terry Schmitt [mailto:[EMAIL PROTECTED]
/*>> Sent: Wednesday, February 27, 2008 2:38 PM
/*>> To: CF-Talk
/*>> Subject: Re: unoffical ahphosting thread
/*>>
/*>> Greg did send out an upgrade email.
/*>>
/*>>> 3) to notify all clients of planned upgrades in advance, especially
/*>>> upgrades to something like virtualization software, like most hosting
/*>>> providers do
/*>
/*
/*

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300087
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Interesting idea for next CF - thoughts...

2008-02-28 Thread Brad Wood
Lol.  You got me.  I meant implements="", not extends="".

That was the one CF8 introduced.  :)

~Brad

-Original Message-
From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 8:48 AM
To: CF-Talk
Subject: Re: Interesting idea for next CF - thoughts...

You mean 'extends=' didn't actually extend a CFC? Wow, then my code was 
working through magic and incantation all that time! Hot Damn, call the 
Enquirer!  ;)

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300086
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


cffile and security

2008-02-28 Thread Mark Fuqua
Good Morning,

I have been working with cffile for the first time and in the process, read
several places that you should upload files to a temp location outside your
webroot for security reasons.  My original problem was with trying to
eliminate spaces from file names...so now this is the process I'm
using...upload to a temp file, remove spaces and replace with _ then move
the file (code below)

My question is, why do I have to go to a temp file first and is this secure
in it's final version/location?

Also, how do I deal with naming conflicts...does move allow for the same
options as upload...rename, overwrite ect.?  It doesn't seem to allow for a
result struc.






select jobfoldername
from jobs
where jobId = #session.jobId#





























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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300085
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JRun Clustering problem - Instance keeps &amp;quot;shutting down&amp;quot;

2008-02-28 Thread James Buckingham
And why do I keep getting my replies in separate entries :-(

Sorry people!!



> The log file was from the failing instance. It was residing in the 
> C:\JRuns\Logs\ folder.
> 
> IIS is sitting on both boxes so I'm not sure if that classes as a 
> "dedicated IIS box". We have round robin on the DNS as well so 
> requests are being passed to both boxes.
> 
> I actually didn't know about those logs. You learn something new every 
> day :-)
> 
> Just looking at the same time as those previous logs these start 2 
> milliseconds after the failure notice. Nothing was happening in these 
> logs for a few hours before this...
> 
> C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 
> 
> 2008-02-27 10:50:43 jrISAPI[2192:6480]  Sticky session breakage, a 
> host for serving session 503042d9e2ad1a7e34287c18369f231a287aTR; 
> __utma=228107678.392619640.1204109239.1204109239.1204109239.1; 
> __utmb=228107678; __utmc=228107678; __utmz=228107678.1204109239.1.1.
> utmccn=(referral)|utmcsr=us.f352.mail.yahoo.
> com|utmcct=/ym/ShowLetter|utmcmd=referral not available.  Failing over 
> to another server, but above session is broken.
> 2008-02-27 10:50:45 jrISAPI[4052:6480]  Sticky session breakage, a 
> host for serving session 50302bd60c2496e669ee2155771f16362587TR not 
> available.  Failing over to another server, but above session is 
> broken.
> 2008-02-27 10:50:52 jrISAPI[9760:6480]  Sticky session breakage, a 
> host for serving session 5030b494a4dd95871bb572701d10113ba365TR; 
> __utma=228107678.629465025.1204106629.1204106629.1204106629.1; 
> __utmb=228107678; __utmc=228107678; __utmz=228107678.1204106629.1.1.
> utmccn=(direct)|utmcsr=(direct)|utmcmd=(none) not available.  Failing 
> over to another server, but above session is broken.
> 
> C:\JRun4\lib\wsconfig\wsconfig.log - I'm not seeing anything on the 
> 27th at that time.
> 
> Does that help at all?
> 
> Cheers for all your help,
> James
> 
> 
> 
> >I just poked around my server a bit...
> >
> >Exactly what log file did you past from in the OP.
> >If you have a dedicated IIS box and depending on your OS, I'm not 
> sure
> >if the directories will be the same, but do you have anything useful 
> in
> >these logs:
> >C:\JRun4\lib\wsconfig\wsconfig.log
> >C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard00.log
> >
> >In the last log, the "1" directory corresponds to the clusters set up 
> in
> >C:\JRun4\lib\wsconfig\wsconfig.properties.  I obviously have IIS6, 
> and
> >the number on the end of the file name is auto-incrementing.
> >
> >~Brad
> >
> >down"
> >
> >Is it possible there is a connectivity issue which is causing the 
> JRun
> >connectors (which are loaded on the IIS box and control load 
> balancing)
> >to think that instance is down?
> >
> >I don't know off the top of my head if there is a log file on the 
> IIS
> >box.
> >
> >~Brad 


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300084
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: SOT - SQL Union Problem

2008-02-28 Thread Ben Doom
I'm not an SQL guru, so take this with a grain of salt:

You could do a join on table1.firstname=table2.firstname and 
table1.firstname = table2.lastname to get all the results that match.

You could union this to two unioned selects where there's an entry in 
table1 but not table2 and vice versa.  You'll have to select empty 
strings for the columns that are only present in one or the other table.

This should give you a result set where you either have the addresses 
from one, or the other, or both.  You can make display (or further 
processing) decisions based on that.

--Ben Doom

Mark Henderson wrote:
> OK, so that was working, and those are the only two fields I want to
> union on, which is fine. But now I also want to add the address fields
> to the query result, without doing a  union on those additional fields.
> Some addresses aren't entered quite right, and this will then create
> duplicates even though the query doesn't see them as such - does that
> make sense?
> 
> So, for instance, when I do:
> 
> SELECT FirstName1 AS FirstName, Surname1 AS LastName 
> FROM tblMain 
> WHERE foundation = Yes
> UNION 
> SELECT FirstName, LastName 
> FROM tblCentennialMembers;
> 
> I get the result set I want. But if I do
> 
> SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City,
> Country
> FROM tblMain 
> WHERE foundation = Yes
> UNION 
> SELECT FirstName, LastName, Address1, Address2, City, Country 
> FROM tblCentennialMembers;
> 
> It returns almost everything including the duplicates since add1 doesn't
> always match address1, even though the first and last names match.
> 
> So, how to get the extra fields into the original result set while only
> doing a union on first and last names?
> 
> 
> Mark
> 
> 
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300083
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: JRun Clustering problem - Instance keeps &quot;shutting down&quot;

2008-02-28 Thread James Buckingham
The log file was from the failing instance. It was residing in the 
C:\JRuns\Logs\ folder.

IIS is sitting on both boxes so I'm not sure if that classes as a "dedicated 
IIS box". We have round robin on the DNS as well so requests are being passed 
to both boxes.

I actually didn't know about those logs. You learn something new every day :-)

Just looking at the same time as those previous logs these start 2 milliseconds 
after the failure notice. Nothing was happening in these logs for a few hours 
before this...

C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard080227.log - 

2008-02-27 10:50:43 jrISAPI[2192:6480]  Sticky session breakage, a host for 
serving session 503042d9e2ad1a7e34287c18369f231a287aTR; 
__utma=228107678.392619640.1204109239.1204109239.1204109239.1; 
__utmb=228107678; __utmc=228107678; 
__utmz=228107678.1204109239.1.1.utmccn=(referral)|utmcsr=us.f352.mail.yahoo.com|utmcct=/ym/ShowLetter|utmcmd=referral
 not available.  Failing over to another server, but above session is broken.
2008-02-27 10:50:45 jrISAPI[4052:6480]  Sticky session breakage, a host for 
serving session 50302bd60c2496e669ee2155771f16362587TR not available.  Failing 
over to another server, but above session is broken.
2008-02-27 10:50:52 jrISAPI[9760:6480]  Sticky session breakage, a host for 
serving session 5030b494a4dd95871bb572701d10113ba365TR; 
__utma=228107678.629465025.1204106629.1204106629.1204106629.1; 
__utmb=228107678; __utmc=228107678; 
__utmz=228107678.1204106629.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none) 
not available.  Failing over to another server, but above session is broken.

C:\JRun4\lib\wsconfig\wsconfig.log - I'm not seeing anything on the 27th at 
that time.

Does that help at all?

Cheers for all your help,
James



>I just poked around my server a bit...
>
>Exactly what log file did you past from in the OP.
>If you have a dedicated IIS box and depending on your OS, I'm not sure
>if the directories will be the same, but do you have anything useful in
>these logs:
>C:\JRun4\lib\wsconfig\wsconfig.log
>C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard00.log
>
>In the last log, the "1" directory corresponds to the clusters set up in
>C:\JRun4\lib\wsconfig\wsconfig.properties.  I obviously have IIS6, and
>the number on the end of the file name is auto-incrementing.
>
>~Brad
>
>down"
>
>Is it possible there is a connectivity issue which is causing the JRun
>connectors (which are loaded on the IIS box and control load balancing)
>to think that instance is down?
>
>I don't know off the top of my head if there is a log file on the IIS
>box.
>
>~Brad 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300082
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent users from voting twice.

2008-02-28 Thread Ben Doom
George Linderman wrote:
> Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to 
> work...but didn't know that they were *that* unreliable.

Well, think about this:

Everyone in my office is behind the same router.  So there are 7 people 
in this office who would show up as a single IP.  Add to that that if I 
go home or use a proxy (like a free internet proxy, or the TOR system) I 
could vote many times.

You can never completely eliminate the possibility of someone voting 
early and voting often, but using a registration system or cookies can 
make it more reliable.

--Ben Doom


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300081
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: emails stop being sent by CF

2008-02-28 Thread Claude Schneegans
 >>For no apparent reason, emails stop being sent by CF. 

I'm having this problem about once a year.
The problem is cause by an invalid file in the spool. I mean a file that 
contains no information that could
make a valid message. This causes the spooler to loop indefinitely on 
the problem.
The solution is to delete the first file in the spooler, then the rest 
should be sent.

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


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300080
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


CF scheduled jobs just stop running...

2008-02-28 Thread Piet Bruins
CF scheduled jobs that have run fine for days will sometimes just stop being 
run. 
There are no errors that we can find when this happens and the only indication 
of the issue (other than the jobs just not running) is that the scheduler.log 
file no longer shows "[job name] Executing..." lines for the job. 

Please advice. 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300079
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Interesting idea for next CF - thoughts...

2008-02-28 Thread Cutter (CFRelated)
You mean 'extends=' didn't actually extend a CFC? Wow, then my code was 
working through magic and incantation all that time! Hot Damn, call the 
Enquirer!  ;)

Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com

Brad Wood wrote:
> They didn't use an empty value.  They put in cfc names and/or notes as
> to what other component that component extended.  Of course, the values
> they had been putting in there were not valid for CF8.  The empty quotes
> were the lines your imagination was supposed to go between.
> 
> ~Brad


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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300078
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread Brad Wood
I just poked around my server a bit...

Exactly what log file did you past from in the OP.
If you have a dedicated IIS box and depending on your OS, I'm not sure
if the directories will be the same, but do you have anything useful in
these logs:
C:\JRun4\lib\wsconfig\wsconfig.log
C:\JRun4\lib\wsconfig\1\LogFiles\jrun_iis6_wildcard00.log

In the last log, the "1" directory corresponds to the clusters set up in
C:\JRun4\lib\wsconfig\wsconfig.properties.  I obviously have IIS6, and
the number on the end of the file name is auto-incrementing.

~Brad

-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 8:21 AM
To: CF-Talk
Subject: RE: JRun Clustering problem - Instance keeps "shutting
down"

Is it possible there is a connectivity issue which is causing the JRun
connectors (which are loaded on the IIS box and control load balancing)
to think that instance is down?

I don't know off the top of my head if there is a log file on the IIS
box.

~Brad

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: ColdFusion 8 ODBC Server ErrorCode=2300 connection unexpectedly closed by peer

2008-02-28 Thread Jochem van Dieten
Piet Bruins wrote:
> The description for Event ID ( 0 ) in Source ( ColdFusion 8 ODBC Server ) 
> cannot be found. The local computer may not have the necessary registry 
> information or message DLL files to display messages from a remote computer. 
> You may be able to use the /AUXSOURCE= flag to retrieve this description; see 
> Help and Support for details. The following information is part of the event: 
> ColdFusion 8 ODBC [EMAIL PROTECTED],ErrorCode=2300,ErrorMessage=Network 
> problem, connection unexpectedly closed by peer.

Don't use ODBC.


JDBC-ODBC bridge
...
Adobe does not recommend this driver type unless your application 
requires DBMS-specific features.

http://livedocs.adobe.com/coldfusion/8/htmldocs/datasources_ADV_MJS_02.html#1261469

Jochem

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300076
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: How do I change my localhost setting in CF 8?

2008-02-28 Thread Rick Faircloth
Got it working, Dave... thanks!

Rick

> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, February 27, 2008 11:54 PM
> To: CF-Talk
> Subject: RE: How do I change my localhost setting in CF 8?
> 
> > I tried changing the web-inf/jrun-web.xml file to add a
> > virtual directory mapping.
> > I decided to try that first rather than move the entire wwwroot.
> >
> > I created the following entry:
> >
> > 
> > /webroot/*
> > E:/Inetpub/webroot
> > 
> >
> > But I get a browser message that the page can't be displayed
> > when I try both http://webroot/his-anointing/index.cfm
> > or http://webroot:8500/his-anointing/index.cfm
> >
> > If I move the his-anointing directory under the wwwroot
> > directory in the ColdFusion 8 directory then I can bring up the page.
> >
> > Does this mean I'm going to have to change the resource path
> > for "localhost" and relocate the CFIDE files, etc, now in the
> > ColdFusion 8 directory, to be able to resolve:
> > http://localhost:8500/his-anointing/index.cfm?
> 
> If your web root directory is e:\inetpub\wwwroot, you don't want to create a
> virtual directory mapping pointing to that, because those refer to
> subdirectories of the web root, not the root itself. In your URLs above,
> "webroot" is not a hostname, so that won't resolve. The virtual mapping you
> created would map this URL:
> 
> http://localhost:8500/webroot/
> 
> to the directory:
> 
> e:\inetpub\wwwroot
> 
> I don't think that's what you want.
> 
> As for relocating the CFIDE files, etc, you could simply create virtual
> directories pointing to those, if you didn't want to move them.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> http://training.figleaf.com/
> 
> WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> http://www.webmaniacsconference.com/
> 
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300075
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Interesting idea for next CF - thoughts...

2008-02-28 Thread Brad Wood
They didn't use an empty value.  They put in cfc names and/or notes as
to what other component that component extended.  Of course, the values
they had been putting in there were not valid for CF8.  The empty quotes
were the lines your imagination was supposed to go between.

~Brad

-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 8:24 AM
To: CF-Talk
Subject: Re: Interesting idea for next CF - thoughts...

> Watch out for that though.  I remember someone on this list who used
to
> use the extends="" attribute in their cfcomponent tags.  That worked
> great until CF8 when Adobe actually implemented that attribute and all
> their code broke.  :)

You mean with an empty value? 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300074
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Interesting idea for next CF - thoughts...

2008-02-28 Thread s. isaac dealey
> Watch out for that though.  I remember someone on this list who used to
> use the extends="" attribute in their cfcomponent tags.  That worked
> great until CF8 when Adobe actually implemented that attribute and all
> their code broke.  :)

You mean with an empty value? 

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

http://onTap.riaforge.org/blog



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300073
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread Brad Wood
Is it possible there is a connectivity issue which is causing the JRun
connectors (which are loaded on the IIS box and control load balancing)
to think that instance is down?

I don't know off the top of my head if there is a log file on the IIS
box.

~Brad

-Original Message-
From: James Buckingham [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 7:17 AM
To: CF-Talk
Subject: Re: JRun Clustering problem - Instance keeps "shutting
down"

Thanks AJ. Is that the "give it a kick" approach :-)

We actually had a phase before all this started where IIS stopped
processing requests and then "very kindly" jammed up both server
instances, stopping the site completely. It wasn't until we restarted it
or the server that it would release the other instance.

We've not had an IIS-related problem now since the 24th of January so I
don't think this is related to that. That and the fact that JRun is
actually telling us that it's dropping the instance while IIS shows
normal activity. 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300072
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread Brad Wood
That is probably because the JRun connector loaded in IIS is what
divvies up the requests.

~Brad

-Original Message-
From: AJ Mercer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 6:38 AM
To: CF-Talk
Subject: Re: JRun Clustering problem - Instance keeps "shutting down"

I don't know if it is of any help, but when one of our instances stops
receiving any requests, it takes a IIS restart to pick it up again.

Bouncing the instance has no effect

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300071
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Interesting idea for next CF - thoughts...

2008-02-28 Thread Brad Wood
Watch out for that though.  I remember someone on this list who used to
use the extends="" attribute in their cfcomponent tags.  That worked
great until CF8 when Adobe actually implemented that attribute and all
their code broke.  :)

~Brad

-Original Message-
From: s. isaac dealey [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 27, 2008 10:28 PM
To: CF-Talk
Subject: Re: Interesting idea for next CF - thoughts...


When CF6 was introduced they allowed you to add
whatever arbitrary attributes you want to cfcomponent, cffunction,
cfargument and cfproperty tags so you could use that metadata via
getMetaData() 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300070
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent users from voting twice.

2008-02-28 Thread Adam Reynolds
Well ask yourself at what level would you like to be uniquely identified 
when visiting any website? I certainly don't want them to know my MAC 
address.

Have a look at the cfcookie tag. Also be aware that cfcookie cannot be 
used with cflocation.

The concept with cookies is :
1) Landing page checks that there is no "votemade" cookie set. Sets a 
"cansetcookies" cookie and redirects to voting page.
2) Voting page checks for the "cansetcookies" (redirects to the we use 
cookies page" and that "votemade" is not set.
3) Vote is made and on the thank you page the "votemade" cookie is set.




George Linderman wrote:
> Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to 
> work...but didn't know that they were *that* unreliable.
>
> How exactly would I implement the cookie option? I don't have any experience 
> with cookies, aside from knowing that they are little files on the user's 
> computer. Would I want to make a new cookie for each vote? Or would that 
> clutter up the user's system in a bad way?
>
> In other words, can you point me in the right direction code-wise regarding 
> these cookies?
>
> Also, for theoretical purposes, is there any other way at all to uniquely 
> identify the user? I mean, do we as coders have access to logging the user's 
> MAC address on the NIC, or something like that? Or to make it more secure I'd 
> just have to make it with a log in and such.
>
>   
>> The simplest way to do this is through a cookie. You can't lock down an 
>> IP as this is something that may not be unique to them. (e.g. AOL)
>>
>> If they block cookies don't let them vote. If they vote, clear cookies, 
>> vote again, so be it.
>>
>> If you want to prevent that, ask them to login/register (with email 
>> confirm) but expect a far lower voting numbers (but better quality).
>>
>> You just cannot rely on an IP though. You can have the situation that 
>> the IP number changes between voting page display and actual vote being 
>> submitted.
>>
>> Adam
>>
>> George Linderman wrote:
>> 
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300069
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Signature Capture

2008-02-28 Thread E C list
Just a note for future searchers- I am still looking
into the PDF solution,
but I found something that might do the trick.  I am
using the applet
mentioned and linked below to collect a signature. It
will basically hand
out a series of coordinates representing the
signature.  These coordinates
can be saved in the database and easily reconstituted
using CF 8's image
manipulation functions (ImageDrawLines(myImage,x,y))
to recreate the
coordinates as an image which can be rolled into a
PDF, printed, whatever...

This seems to work pretty well.

E 
 

-Original Message-
From: E C list [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 27, 2008 1:13 PM
To: CF-Talk
Subject: RE: Signature Capture

Thanks Gerald, Chris and Dave.  I am not sure what
route I am going to go
with this, but both ideas are helpful.  I downloaded
that java applet and it
works great...pretty cool and simple...it works well
in firefox, I am not
sure why, but it wouldn't load in Internet Explorer,
probably some security
thing.

E  

-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Monday, February 25, 2008 2:14 PM
To: CF-Talk
Subject: Re: Signature Capture

Here it is

http://www.planet-source-code.com/URLSEO/vb/scripts/ShowCode!asp/txtCodeId!1
10/lngWid!9/anyname.htm

On Mon, Feb 25, 2008 at 1:25 PM, Chris Jordan
<[EMAIL PROTECTED]>
wrote:

> I'm about to do a project where we'll be capturing
signatures, and one 
> member of the team says that he found a java applet
that will capture 
> signatures. We'll be running it on a PDA. I know
nothing else about it 
> (not even what it's called), I just know that my guy
says he's found one.
>
> The point of this being that you may just want to
look for something 
> like what I'm describing here as another
alternative.
>
> Good luck!
> Chris
>
> Dave Watts wrote:
> >> Has anyone come up with any good solutions that
would let you embed 
> >> a signature capture field in a form?  This is for
ColdFusion 8.  
> >> The widget would appear at the bottom of a form
contract and the 
> >> hope would be that after the form was submitted
it could be saved 
> >> to  a file on the server or made
> >> a part of a pdf.   There is also talk of using
something like
> >> this to draw basic diagrams to attach to a
contact's record.
> >>
> >
> > You would need to use a PDF form to capture the
signature. The PDF 
> > form containing the signature field can be
appended to another PDF 
> > form containing the other form fields, if you want
to do that, using
> CFPDFFORM.
> > To work effectively with signatures, your PDF
would have to post 
> > itself,
> not
> > just the form data it contains, to your CF server.
Then, in the 
> > action
> page,
> > you'd be able to reference the PDF scope.
> >
> > This exact thing is covered in this class:
> >
http://training.figleaf.com/Courses/movingtocoldfusion8.cfm
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> >
> > Fig Leaf Training: Adobe/Google/Paperthin
Certified Partners 
> > http://training.figleaf.com/
> >
> > WebManiacs 2008: the ultimate conference for
CF/Flex/AIR developers!
> > http://www.webmaniacsconference.com/
> >
> >
>
> 





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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300068
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Prevent users from voting twice.

2008-02-28 Thread Daniel Kessler
The problem with using IPs or cookies to assure only one vote is that  
you're not assuring only one person vote, by one machine vote.  When  
a machine is in a shared environment (school labs, libraries, one  
machine for a family), that machine will only get one vote.  If  
that's fits your audience then that's okay.  I've often wondered if  
then I should replace any vote with a new vote.  In other words, make  
the most recent vote the one that is kept, rather than the first vote.

Otherwise, you could have them enter an email address, which is  
closer to unique though still shared at times.  Or log in using a  
unique id.


-- 

Daniel Kessler

University of Maryland College Park
School of Public Health
3302E HHP Building
College Park, MD  20742-2611
Phone: 301-405-2545
http://sph.umd.edu




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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300067
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread James Buckingham
Thanks AJ. Is that the "give it a kick" approach :-) 

We actually had a phase before all this started where IIS stopped processing 
requests and then "very kindly" jammed up both server instances, stopping the 
site completely. It wasn't until we restarted it or the server that it would 
release the other instance. 

We've not had an IIS-related problem now since the 24th of January so I don't 
think this is related to that. That and the fact that JRun is actually telling 
us that it's dropping the instance while IIS shows normal activity. 

Cheers,
James

>I don't know if it is of any help, but when one of our instances stops
>receiving any requests, it takes a IIS restart to pick it up again.
>
>Bouncing the instance has no effect
>On Thu, Feb 28, 2008 at 7:02 PM, James Buckingham <[EMAIL PROTECTED]>
>wrote:
>
>> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300066
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread James Buckingham
Thanks AJ. Is that the "give it a kick" approach :-)

We actually had a phase before all this started where IIS stopped processing 
requests and then "very kindly" jammed up both server instances, stopping the 
site completely. It wasn't until we restarted it or the server that it would 
release the other instance.

We've not had an IIS-related problem now since the 24th of January so I don't 
think this is related to that. That and the fact that JRun is actually telling 
us that it's dropping the instance while IIS shows normal activity. 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300065
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread AJ Mercer
I don't know if it is of any help, but when one of our instances stops
receiving any requests, it takes a IIS restart to pick it up again.

Bouncing the instance has no effect
On Thu, Feb 28, 2008 at 7:02 PM, James Buckingham <[EMAIL PROTECTED]>
wrote:

> Hi there,
>
> We've been having a lot of problems recently with one of our Cluster
> instances whereby it keeps either shutting itself down or starts to reject
> threads. There isn't a set pattern to when this happens but it is only
> happening on one instance (we have four in total separated 50/50 on two
> servers).
>
> When JRun starts rejecting requests we're seeing this kind of thing in the
> logs:
>
> 27/02 10:44:01 metrics Web threads (busy/total): 0/10 Sessions: 4520 Total
> Memory=65472 Free=8732
> 27/02 10:45:01 metrics Web threads (busy/total): 0/11 Sessions: 4515 Total
> Memory=56320 Free=8533
> 27/02 10:46:01 metrics Web threads (busy/total): 1/10 Sessions: 4512 Total
> Memory=57600 Free=7505
> 27/02 10:47:01 metrics Web threads (busy/total): 0/10 Sessions: 4518 Total
> Memory=57920 Free=6622
> 27/02 10:48:01 metrics Web threads (busy/total): 1/10 Sessions: 4503 Total
> Memory=57216 Free=9725
> 27/02 10:49:01 metrics Web threads (busy/total): 0/10 Sessions: 4501 Total
> Memory=54976 Free=7224
> 27/02 10:50:01 metrics Web threads (busy/total): 0/9 Sessions: 4431 Total
> Memory=61376 Free=12289
> 27/02 10:50:41 info Clusterable service JRunProxyClusterHelper
> successfully removed a peer when that peer left the cluster
> 27/02 10:51:01 metrics Web threads (busy/total): 0/9 Sessions: 4413 Total
> Memory=56832 Free=11473
> 27/02 10:52:01 metrics Web threads (busy/total): 0/9 Sessions: 4377 Total
> Memory=56064 Free=11637
> 27/02 10:53:01 metrics Web threads (busy/total): 0/9 Sessions: 4341 Total
> Memory=53504 Free=11657
> 27/02 10:54:02 metrics Web threads (busy/total): 0/9 Sessions: 4300 Total
> Memory=53568 Free=11636
> 27/02 10:55:02 metrics Web threads (busy/total): 0/9 Sessions: 4263 Total
> Memory=53568 Free=11543
> 27/02 10:56:02 metrics Web threads (busy/total): 0/1 Sessions: 4213 Total
> Memory=53504 Free=11598
> 27/02 10:57:02 metrics Web threads (busy/total): 0/1 Sessions: 4173 Total
> Memory=52544 Free=11585
> 27/02 10:58:02 metrics Web threads (busy/total): 0/1 Sessions: 4132 Total
> Memory=52608 Free=11501
> 27/02 10:59:02 metrics Web threads (busy/total): 0/1 Sessions: 4089 Total
> Memory=52608 Free=11370
> 27/02 11:00:02 metrics Web threads (busy/total): 0/1 Sessions: 4051 Total
> Memory=52608 Free=11454
> 27/02 11:01:02 metrics Web threads (busy/total): 0/1 Sessions: 4014 Total
> Memory=52096 Free=11537
> 27/02 11:02:02 metrics Web threads (busy/total): 0/1 Sessions: 3967 Total
> Memory=52096 Free=11190
>
> .so note that JRun rejects the instance from the cluster but the logs
> carry on. Also note that the Web Threads just carry on as 0/1 until the
> instance is started up again. The frequency of this has started to increase
> and we're now getting this at least once a day.
>
> The server is a virtual machine, Win Server 2003, CF7.0 with multiserver
> JRun. We have it setup on Round Robin with sticky sessions.
>
> Just to give you a breakdown on what we've tried already
>
> The problem started on the 29th of Jan this year and looking at our logs
> nothing has changed on or around this time apart from an upgrade to our
> backup software on the other "working" server. So I wouldn't expect this to
> effect the one that is now faulty.
>
> We started to add Hotfixes to the server on the 5th of Feb but this hasn't
> resolved the problem. These included JRun Updater 7 and CF HotFix 3 which
> had stability fixes for clustering. This was applied to both servers.
>
> Checking logs in IIS I'm not seeing anything abnormal.
>
> We've compared the setup of the failing instance to the other server
> instance and apart from a few unique configuration settings both are
> identifical in JRun. We are considering the option of rebuilding the
> instance using the working one but to be honest that drawing at straws.
>
> Has anybody else had a similar kind of problem or can think of any other
> ideas as to what might be causing this.
>
> Your help would be appreciated and if there is anymore information you
> need please let me know.
>
> Cheers,
> James
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300064
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent users from voting twice.

2008-02-28 Thread George Linderman
Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to 
work...but didn't know that they were *that* unreliable.

How exactly would I implement the cookie option? I don't have any experience 
with cookies, aside from knowing that they are little files on the user's 
computer. Would I want to make a new cookie for each vote? Or would that 
clutter up the user's system in a bad way?

In other words, can you point me in the right direction code-wise regarding 
these cookies?

Also, for theoretical purposes, is there any other way at all to uniquely 
identify the user? I mean, do we as coders have access to logging the user's 
MAC address on the NIC, or something like that? Or to make it more secure I'd 
just have to make it with a log in and such.

>The simplest way to do this is through a cookie. You can't lock down an 
>IP as this is something that may not be unique to them. (e.g. AOL)
>
>If they block cookies don't let them vote. If they vote, clear cookies, 
>vote again, so be it.
>
>If you want to prevent that, ask them to login/register (with email 
>confirm) but expect a far lower voting numbers (but better quality).
>
>You just cannot rely on an IP though. You can have the situation that 
>the IP number changes between voting page display and actual vote being 
>submitted.
>
>Adam
>
>George Linderman wrote:
>> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300063
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Prevent users from voting twice.

2008-02-28 Thread Adam Reynolds
The simplest way to do this is through a cookie. You can't lock down an 
IP as this is something that may not be unique to them. (e.g. AOL)

If they block cookies don't let them vote. If they vote, clear cookies, 
vote again, so be it.

If you want to prevent that, ask them to login/register (with email 
confirm) but expect a far lower voting numbers (but better quality).

You just cannot rely on an IP though. You can have the situation that 
the IP number changes between voting page display and actual vote being 
submitted.

Adam

George Linderman wrote:
> Hey guys,
>
>
> I've been spending practically every free moment of my time the past few 
> months working on a project--and I've gotten some valuable help from the 
> community here. Anyway, here I am again to ask for help :)
>
> I'm not going to go and explain the project right now, but the part for which 
> I require assistance is the voting system. Basically, the user clicks on the 
> voting icon (sends them to the processor page), and by means of URL 
> querystring, the number of points is added to the database. Now, it would be 
> overly simple for the user to click on the three-points icon 200 times, and 
> totally mess up my results. Therefore, I obviously want to make some type of 
> system that can stop the user from voting more than once. It doesn't have to 
> be superbly secure--but as secure as possible. I was thinking by means of IP 
> address and/or cookies.
>
> What is your thought on this? Please tell me as well how I would code 
> whatever option you give me, as I was trying to do the IP adress option, but 
> I kept getting stuck. My thought was that the user's IP would be logged into 
> the database, and whenever they vote again, a query would get all the IP 
> addresses logged for that video. Then, it would check if the client's IP is 
> in the results of that query. But...I don't know how to check one IP against 
> all the IPs that have voted. I'm sure it's a basic syntax, but it just isn't 
> coming to me.
>
> Anyway, please give me your advice and code if possible for how to prevent a 
> user from voting twice. 
>
>
> Thanks,
> George L.
>
> P.S. This is kind of time sensitive. Any help you can give would be great. 
> Thanks! 
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300062
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: emails stop being sent by CF

2008-02-28 Thread Jose Diaz
Hi Piet

The spool may have stopped processing - I wrote a UDF for such a problem
give this a whurl.

http://www.cflib.org/udf.cfm?id=1511

HTH

Jose Diaz

On Thu, Feb 28, 2008 at 10:46 AM, Piet Bruins <[EMAIL PROTECTED]>
wrote:

> For no apparent reason, emails stop being sent by CF.
> This has happened on more than one server.
> This same issue was mentioned here as well:
>
>
> http://groups.google.com/group/macromedia.coldfusion.server_administration/browse_thread/thread/33edf401eb8a6f11/a4eb4efb1190589e
>
> Please advice.
>
> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300061
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Mark Kruger
Daves right... Although cfcontent won't be as bad as opening the file as
binary, encoding as base64 and then creating a vary large XML packet. 

I have never used the symlink idea - although I've heard him mention it
before.  I'd be interested in a code snippet on how to do this "on the fly"
in Linux. Would you have to pass arguments to a shell script Dave?

-Mark


-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 28, 2008 3:07 AM
To: CF-Talk
Subject: RE: Sending File Data Over Webservice

> What are the overheads like on using cfcontent to deliver a file 
> opposed to simply having it available in a web accessible directory?

Significant, in my past experience. The CFCONTENT request monopolizes a CF
thread for the duration of the download. As an alternative, you might
consider creating temporary URLs; you can easily do this on Unix using
symlinks. You can create symlinks to directories in Windows, and that might
be sufficient also.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300060
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Prevent users from voting twice.

2008-02-28 Thread George Linderman
Hey guys,


I've been spending practically every free moment of my time the past few months 
working on a project--and I've gotten some valuable help from the community 
here. Anyway, here I am again to ask for help :)

I'm not going to go and explain the project right now, but the part for which I 
require assistance is the voting system. Basically, the user clicks on the 
voting icon (sends them to the processor page), and by means of URL 
querystring, the number of points is added to the database. Now, it would be 
overly simple for the user to click on the three-points icon 200 times, and 
totally mess up my results. Therefore, I obviously want to make some type of 
system that can stop the user from voting more than once. It doesn't have to be 
superbly secure--but as secure as possible. I was thinking by means of IP 
address and/or cookies.

What is your thought on this? Please tell me as well how I would code whatever 
option you give me, as I was trying to do the IP adress option, but I kept 
getting stuck. My thought was that the user's IP would be logged into the 
database, and whenever they vote again, a query would get all the IP addresses 
logged for that video. Then, it would check if the client's IP is in the 
results of that query. But...I don't know how to check one IP against all the 
IPs that have voted. I'm sure it's a basic syntax, but it just isn't coming to 
me.

Anyway, please give me your advice and code if possible for how to prevent a 
user from voting twice. 


Thanks,
George L.

P.S. This is kind of time sensitive. Any help you can give would be great. 
Thanks! 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300059
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


emails stop being sent by CF

2008-02-28 Thread Piet Bruins
For no apparent reason, emails stop being sent by CF.  
This has happened on more than one server. 
This same issue was mentioned here as well:

http://groups.google.com/group/macromedia.coldfusion.server_administration/browse_thread/thread/33edf401eb8a6f11/a4eb4efb1190589e

Please advice. 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300058
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


ColdFusion 8 ODBC Server ErrorCode=2300 connection unexpectedly closed by peer

2008-02-28 Thread Piet Bruins
The description for Event ID ( 0 ) in Source ( ColdFusion 8 ODBC Server ) 
cannot be found. The local computer may not have the necessary registry 
information or message DLL files to display messages from a remote computer. 
You may be able to use the /AUXSOURCE= flag to retrieve this description; see 
Help and Support for details. The following information is part of the event: 
ColdFusion 8 ODBC [EMAIL PROTECTED],ErrorCode=2300,ErrorMessage=Network 
problem, connection unexpectedly closed by peer.

Please advice how we can get rid of these events. 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300057
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread James Buckingham
Hi there,

We've been having a lot of problems recently with one of our Cluster instances 
whereby it keeps either shutting itself down or starts to reject threads. There 
isn't a set pattern to when this happens but it is only happening on one 
instance (we have four in total separated 50/50 on two servers).

When JRun starts rejecting requests we're seeing this kind of thing in the logs:

27/02 10:44:01 metrics Web threads (busy/total): 0/10 Sessions: 4520 Total 
Memory=65472 Free=8732
27/02 10:45:01 metrics Web threads (busy/total): 0/11 Sessions: 4515 Total 
Memory=56320 Free=8533
27/02 10:46:01 metrics Web threads (busy/total): 1/10 Sessions: 4512 Total 
Memory=57600 Free=7505
27/02 10:47:01 metrics Web threads (busy/total): 0/10 Sessions: 4518 Total 
Memory=57920 Free=6622
27/02 10:48:01 metrics Web threads (busy/total): 1/10 Sessions: 4503 Total 
Memory=57216 Free=9725
27/02 10:49:01 metrics Web threads (busy/total): 0/10 Sessions: 4501 Total 
Memory=54976 Free=7224
27/02 10:50:01 metrics Web threads (busy/total): 0/9 Sessions: 4431 Total 
Memory=61376 Free=12289
27/02 10:50:41 info Clusterable service JRunProxyClusterHelper successfully 
removed a peer when that peer left the cluster
27/02 10:51:01 metrics Web threads (busy/total): 0/9 Sessions: 4413 Total 
Memory=56832 Free=11473
27/02 10:52:01 metrics Web threads (busy/total): 0/9 Sessions: 4377 Total 
Memory=56064 Free=11637
27/02 10:53:01 metrics Web threads (busy/total): 0/9 Sessions: 4341 Total 
Memory=53504 Free=11657
27/02 10:54:02 metrics Web threads (busy/total): 0/9 Sessions: 4300 Total 
Memory=53568 Free=11636
27/02 10:55:02 metrics Web threads (busy/total): 0/9 Sessions: 4263 Total 
Memory=53568 Free=11543
27/02 10:56:02 metrics Web threads (busy/total): 0/1 Sessions: 4213 Total 
Memory=53504 Free=11598
27/02 10:57:02 metrics Web threads (busy/total): 0/1 Sessions: 4173 Total 
Memory=52544 Free=11585
27/02 10:58:02 metrics Web threads (busy/total): 0/1 Sessions: 4132 Total 
Memory=52608 Free=11501
27/02 10:59:02 metrics Web threads (busy/total): 0/1 Sessions: 4089 Total 
Memory=52608 Free=11370
27/02 11:00:02 metrics Web threads (busy/total): 0/1 Sessions: 4051 Total 
Memory=52608 Free=11454
27/02 11:01:02 metrics Web threads (busy/total): 0/1 Sessions: 4014 Total 
Memory=52096 Free=11537
27/02 11:02:02 metrics Web threads (busy/total): 0/1 Sessions: 3967 Total 
Memory=52096 Free=11190

.so note that JRun rejects the instance from the cluster but the logs carry 
on. Also note that the Web Threads just carry on as 0/1 until the instance is 
started up again. The frequency of this has started to increase and we're now 
getting this at least once a day.

The server is a virtual machine, Win Server 2003, CF7.0 with multiserver JRun. 
We have it setup on Round Robin with sticky sessions.

Just to give you a breakdown on what we've tried already

The problem started on the 29th of Jan this year and looking at our logs 
nothing has changed on or around this time apart from an upgrade to our backup 
software on the other "working" server. So I wouldn't expect this to effect the 
one that is now faulty. 

We started to add Hotfixes to the server on the 5th of Feb but this hasn't 
resolved the problem. These included JRun Updater 7 and CF HotFix 3 which had 
stability fixes for clustering. This was applied to both servers.

Checking logs in IIS I'm not seeing anything abnormal.

We've compared the setup of the failing instance to the other server instance 
and apart from a few unique configuration settings both are identifical in 
JRun. We are considering the option of rebuilding the instance using the 
working one but to be honest that drawing at straws.

Has anybody else had a similar kind of problem or can think of any other ideas 
as to what might be causing this. 

Your help would be appreciated and if there is anymore information you need 
please let me know.

Cheers,
James 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300055
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


JRun Clustering problem - Instance keeps "shutting down"

2008-02-28 Thread James Buckingham
Hi there,

We've been having a lot of problems recently with one of our Cluster instances 
whereby it keeps either shutting itself down or starts to reject threads. There 
isn't a set pattern to when this happens but it is only happening on one 
instance (we have four in total separated 50/50 on two servers).

When JRun starts rejecting requests we're seeing this kind of thing in the logs:

27/02 10:44:01 metrics Web threads (busy/total): 0/10 Sessions: 4520 Total 
Memory=65472 Free=8732
27/02 10:45:01 metrics Web threads (busy/total): 0/11 Sessions: 4515 Total 
Memory=56320 Free=8533
27/02 10:46:01 metrics Web threads (busy/total): 1/10 Sessions: 4512 Total 
Memory=57600 Free=7505
27/02 10:47:01 metrics Web threads (busy/total): 0/10 Sessions: 4518 Total 
Memory=57920 Free=6622
27/02 10:48:01 metrics Web threads (busy/total): 1/10 Sessions: 4503 Total 
Memory=57216 Free=9725
27/02 10:49:01 metrics Web threads (busy/total): 0/10 Sessions: 4501 Total 
Memory=54976 Free=7224
27/02 10:50:01 metrics Web threads (busy/total): 0/9 Sessions: 4431 Total 
Memory=61376 Free=12289
27/02 10:50:41 info Clusterable service JRunProxyClusterHelper successfully 
removed a peer when that peer left the cluster
27/02 10:51:01 metrics Web threads (busy/total): 0/9 Sessions: 4413 Total 
Memory=56832 Free=11473
27/02 10:52:01 metrics Web threads (busy/total): 0/9 Sessions: 4377 Total 
Memory=56064 Free=11637
27/02 10:53:01 metrics Web threads (busy/total): 0/9 Sessions: 4341 Total 
Memory=53504 Free=11657
27/02 10:54:02 metrics Web threads (busy/total): 0/9 Sessions: 4300 Total 
Memory=53568 Free=11636
27/02 10:55:02 metrics Web threads (busy/total): 0/9 Sessions: 4263 Total 
Memory=53568 Free=11543
27/02 10:56:02 metrics Web threads (busy/total): 0/1 Sessions: 4213 Total 
Memory=53504 Free=11598
27/02 10:57:02 metrics Web threads (busy/total): 0/1 Sessions: 4173 Total 
Memory=52544 Free=11585
27/02 10:58:02 metrics Web threads (busy/total): 0/1 Sessions: 4132 Total 
Memory=52608 Free=11501
27/02 10:59:02 metrics Web threads (busy/total): 0/1 Sessions: 4089 Total 
Memory=52608 Free=11370
27/02 11:00:02 metrics Web threads (busy/total): 0/1 Sessions: 4051 Total 
Memory=52608 Free=11454
27/02 11:01:02 metrics Web threads (busy/total): 0/1 Sessions: 4014 Total 
Memory=52096 Free=11537
27/02 11:02:02 metrics Web threads (busy/total): 0/1 Sessions: 3967 Total 
Memory=52096 Free=11190

.so note that JRun rejects the instance from the cluster but the logs carry 
on. Also note that the Web Threads just carry on as 0/1 until the instance is 
started up again. The frequency of this has started to increase and we're now 
getting this at least once a day.

The server is a virtual machine, Win Server 2003, CF7.0 with multiserver JRun. 
We have it setup on Round Robin with sticky sessions.

Just to give you a breakdown on what we've tried already

The problem started on the 29th of Jan this year and looking at our logs 
nothing has changed on or around this time apart from an upgrade to our backup 
software on the other "working" server. So I wouldn't expect this to effect the 
one that is now faulty. 

We started to add Hotfixes to the server on the 5th of Feb but this hasn't 
resolved the problem. These included JRun Updater 7 and CF HotFix 3 which had 
stability fixes for clustering. This was applied to both servers.

Checking logs in IIS I'm not seeing anything abnormal.

We've compared the setup of the failing instance to the other server instance 
and apart from a few unique configuration settings both are identifical in 
JRun. We are considering the option of rebuilding the instance using the 
working one but to be honest that drawing at straws.

Has anybody else had a similar kind of problem or can think of any other ideas 
as to what might be causing this. 

Your help would be appreciated and if there is anymore information you need 
please let me know.

Cheers,
James 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300056
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Help with Rewrite Rule! (circuit.fuseaction)

2008-02-28 Thread cf coder
Hi guys,

I have one more questions on this topic. I've added a handful of rules and they 
work however all of the images on the site are broken. I have a virtual 
directory in IIS for my site called "images" and all the "img" tags on my pages 
start with for ex: "images/foldername/imagename.gif".

I don't want to change all the img  tags in my site to 
"http://domainname/images/etcetc..";

Is there a better solution..

Your help on this matter are much appreciated.

Regards,
cfcoder

>Oops... Didn't see Barney's reply... weird that when you click on the
>Archive link it only bring up a single message, not the whole thread.  
>
>Russ  
>
>> 

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300054
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Robert Rawlins - Think Blue
Thanks Dave,

Unix? What's that? Heh, I'm only pulling your leg, I know what Unix is.

I thought that cfcontent would be an intensive little monkey, it doesn't
surprise me to hear you've found that in the past, it's nice to have that
confirmation.

I think my real goal with this is to keep it as unintensive as possible, I
mean, keeping the files hidden from web access isn't the absolute end of the
world, if people view and download them it has no real consequence, other
than eating all my bandwidth, however, all the files are stored with a UUID
as the name so it's not as if people will stumble across them by accident.

One thing I'm considering as an option at the moment is maintaining the
theory of passing the binary data back over a webservice, however, cutting
out the compression, at least this makes the load on the server a little
less and it's just the bandwidth which is going to take a bit of a hit,
maybe 10-20% or something like that, quite manageable though.

What do you think, does that sound a solution? Or would you still look
around at the idea of making files temporarily accessible?

Robert

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: 28 February 2008 09:07
To: CF-Talk
Subject: RE: Sending File Data Over Webservice

> What are the overheads like on using cfcontent to deliver a 
> file opposed to simply having it available in a web 
> accessible directory?

Significant, in my past experience. The CFCONTENT request monopolizes a CF
thread for the duration of the download. As an alternative, you might
consider creating temporary URLs; you can easily do this on Unix using
symlinks. You can create symlinks to directories in Windows, and that might
be sufficient also.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/



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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300053
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Dave Watts
> What are the overheads like on using cfcontent to deliver a 
> file opposed to simply having it available in a web 
> accessible directory?

Significant, in my past experience. The CFCONTENT request monopolizes a CF
thread for the duration of the download. As an alternative, you might
consider creating temporary URLs; you can easily do this on Unix using
symlinks. You can create symlinks to directories in Windows, and that might
be sufficient also.

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

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300052
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Sending File Data Over Webservice

2008-02-28 Thread Robert Rawlins - Think Blue
Morning Mark,

That's an excellent and thorough answer, thanks. It's nice to see someone
who has tried this kind of approach themselves and got a little experience
with it.

I like this idea of issuing a token for the files, that's quite neat.
Another great little idea is delivering the files using cfcontent which
means they don't have to be web accessible, this is a very nice security
factor, I like it a great deal.

What are the overheads like on using cfcontent to deliver a file opposed to
simply having it available in a web accessible directory?

Cheers Mark,

Robert

-Original Message-
From: Mark Kruger [mailto:[EMAIL PROTECTED] 
Sent: 27 February 2008 21:19
To: CF-Talk
Subject: RE: Sending File Data Over Webservice

Robert,

We have a web service used for the state of California that wraps image
files up as base64 - exactly as you suggest below. The image files are
obviously much smaller than media files (mostly less than half a meg), but I
can tell you that you are on the right track thinking that it is a resource
intensive way to go.  If we were doing larger files we would probably use
something much "dumber" than a web service (also as you suggest) - a URL to
retrieve the file via HTTP.  Of course you can pass a token or something
that is good for only 1 retrieval and then serve the file from a location
outside the web root (for security).  You could also zip it. But after
zipping and using cfcontent and checking credentials you now have a second
request that could be resource intensive as  well. The bottom line is that
there is no great "low resource" way to securely send files around in an SOA
type architecture.

-Mark

Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
 

-Original Message-
From: Robert Rawlins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, February 27, 2008 2:48 PM
To: CF-Talk
Subject: Sending File Data Over Webservice

Hello Guys,

I'm after a little advice on refactoring a web service which I have running
on one of my applications. The webservice isnt a standard ColdFusion
webservice running over SOAP, this is a custom REST service which simply
recieves POST data into the FORM scope and then spits back an XML document
for the client to read.

Now, I basicly offer a bunch of multimedia content over this webservice,
anything from text, through to images, sound and video. With the current
setup, when a request is made to the service for a particular piece or set
of multimedia, the media is zipped on the server into an archive file, the
binary data of which is then read into a base64 encoded string and this is
then passed back to the client wrapped in some XML over the web service.

The challenge I meet with this is not knowing how to weigh up the cost of
bandwidth and security against the load hit this causes on the server. See,
at the moment, with zipping the content I'm saving a substantial amount of
bandwidth, also with zipping the files and sending them as a string I have
the ability to be able to produce a HASH key checksum for the file, then
when the file arrives the other end, the client can rebuild the file and
checksum to make sure all is alive and well after the transmition.

Now, the real downside to this option is that it must be hungry on the
system, all the checksumming and zipping must be making some form of
performance hit, right? especialy on what will likely become a very busy
little web service in the comming months.

My other planned method of attack is to not pass the files through the
webservice at all, but simply pass a web accessible path for them, the
client application could then simply loop through the returned XML and make
http requests to download the media, this would obviously up the bandwidth
but does offer less load involved with compressing the media.

I'm sorry the question isnt a little more specific about what I'm asking,
I'm just thinking out loud really, hoping somone will chime in and offer
thier thoughts.

How would you tackle this challenge? what would your priority be? bandwidth
or reducing the load on the server? is it plausable to offer a checksum
solution even if we're not sending the binary data over the service directly
so we can still offer that level of security without the overhead of the
zipping?

I'm looking for the best ballance.

I'd be interested to get your thoughts.

Rob 





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

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300051
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4