Resolution and Color Depth Data

[Jim Davis]

I'm really trying to get back into the swing of actually working on my site.
So, as a start, I've finally reworked the "Resolution Data" page that was
broken by my big redesign a (long) while ago.

Here's the page:



These charts collect a bit under four years of data.

Obviously this is only data for my site (not a very large audience I'm
afraid) but I still hope that the information is useful (or at least
interesting).  Next I'd like to find an elegant way to present the numbers
as functions of time.  This is more complex using my data source and might
not be performant so I might end up with simple six month "snap shots"
instead... but we'll see.

I'd love to hear any thoughts or suggestions!

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:299769
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: LDAP Query for group members

[Dawson, Michael]

Glad to help.
 
Regarding group membership, check back through the archives on this list. 
Specifically, look on Thurs, Jan 17, 2008 at 9:12 AM.
 
I posted a reply with the subject of "RE: CFLdap".  This reply contains the 
code that uses CFLDAP to add and remove domain group members.
 
If you can't find it, let me know and I'll repost it for you.
 
I learned most of this by combining Active Directory Users and Computers with 
LDAP.  I would make a change in ADU&C, then output all attributes via LDAP.  
Then, I would see which values would change.  That is how I mapped-out many of 
the attributes.
 
MSDN helped quite a bit, as well.  I also picked up some obscure help by 
Googling.
 
Other than knowing the multi-value attributes, and an odd binary attribute here 
and there, LDAP with Active Directory is cake.
 
I would suggest that you install the Active Directory Schema MMC plug in on a 
domain controller.  You can browse the schema and see which attributes are 
multi-values, which are indexed and find out the datatype/length of the 
attributes.
 
I you have any other LDAP questions, let me know.
 
M!ke

  _  

From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Fri 2/22/2008 1:09 PM
To: CF-Talk
Subject: RE: LDAP Query for group members



Michael-

AWESOME! Thank you so much for the help. Is it as simple to add users to
the group using the same method? Did you come up with this on your own
or find this info somewhere? Any other tips of things I can look out for
as I'm working with CFLDAP?

John




~|
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:299768
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: The unofficial ahphosting status thread

[Rick Faircloth]

But I will add that FusionLink's prices are "astronomical"
compared to AHP!


> -Original Message-
> From: Rick Faircloth [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 9:54 PM
> To: CF-Talk
> Subject: RE: The unofficial ahphosting status thread
> 
> I've had HTTP, FTP, RDC, haven't been able to access
> VCP for about two weeks, but don't use it much.
> 
> The biggest issue I have now is that CF 8 is going down
> at least once per day and I have to logon via RDC and
> restart it.
> 
> Anyone else with site running seeing this behavior?
> 
> Now as far as FusionLink offering to help with CF hosting...
> I don't mind the info.  After all, he did wait the better part
> of a week before saying anything.  And yes, I'm a big boy and
> I can certainly find my own host, but I can also appreciate
> John letting us know that he's ready to help.  No problem for me.
> 
> I feel like after this situation, I may have to have a backup host
> ready to go, even if I have to pay for it and not use it.  If I had
> fully migrated all my sites from my in-house server to AHP, I would
> have lost some of my best customers, who just happen to still be
> on my in-house server, thankfully.
> 
> I run daily backups of my MySQL DB's using Navicat, too (great tool,
> huh Mary Jo? :o) and have all my sites on my development PC and
> remote SVN, so I could have set up an entirely new host and would
> have if some of those "best clients" had been on AHP.
> 
> This has turned into a real issue...
> 
> Rick
> 




~|
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:299767
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Terry Schmitt]

That notion has crossed my mind, but that brings up a whole different set of 
issues.

My web sites are finally back up and working extremely fast I might add.
RDC and VCP are working.
Still no email or ftp though... Bummer!

>I am suprised y'all are hanging on this long. I would expext that some of
>you would have chipped in and got a dedicated box by now. The notion of a
>hosting collective just came to mind. Kinda like OSS but for hosting.
>
>And no, I haven't been following.
>
>Best of luck with this. I feel your pain.
>
>G
>
>
>
>On Fri, Feb 22, 2008 at 2:45 PM, J W <[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:299766
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: The unofficial ahphosting status thread

[Rick Faircloth]

I've had HTTP, FTP, RDC, haven't been able to access
VCP for about two weeks, but don't use it much.

The biggest issue I have now is that CF 8 is going down
at least once per day and I have to logon via RDC and
restart it.

Anyone else with site running seeing this behavior?

Now as far as FusionLink offering to help with CF hosting...
I don't mind the info.  After all, he did wait the better part
of a week before saying anything.  And yes, I'm a big boy and
I can certainly find my own host, but I can also appreciate
John letting us know that he's ready to help.  No problem for me.

I feel like after this situation, I may have to have a backup host
ready to go, even if I have to pay for it and not use it.  If I had
fully migrated all my sites from my in-house server to AHP, I would
have lost some of my best customers, who just happen to still be
on my in-house server, thankfully.

I run daily backups of my MySQL DB's using Navicat, too (great tool,
huh Mary Jo? :o) and have all my sites on my development PC and
remote SVN, so I could have set up an entirely new host and would
have if some of those "best clients" had been on AHP.

This has turned into a real issue...

Rick

> -Original Message-
> From: Gerald Guido [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 7:19 PM
> To: CF-Talk
> Subject: Re: The unofficial ahphosting status thread
> 
> I am suprised y'all are hanging on this long. I would expext that some of
> you would have chipped in and got a dedicated box by now. The notion of a
> hosting collective just came to mind. Kinda like OSS but for hosting.
> 
> And no, I haven't been following.
> 
> Best of luck with this. I feel your pain.
> 
> G
> 
> 
> 
> On Fri, Feb 22, 2008 at 2:45 PM, J W <[EMAIL PROTECTED]> wrote:
> 
> > Down since this AM... Again. I really hope they resolve this ASAP.
> >
> > Had VCP for a while, now thats dead.
> > NO HTTP
> > I have mail, or at least I am able to connect and check.
> > RDP is functioning...
> >
> > Sometimes, If I can get into the VCP I restart the container and sometimes
> > that brings up HTTP
> > If I can RDP in, I can restart that way. Sometimes that works...
> >
> > I am real lucky my clients are being understanding...right now... One of
> > mine runs a charter business and if we were in season right now, I would
> > have lost a client over this... Who knows what trickle down impact is
> > going
> > to occur now.
> >
> > Jeff
> >
> >
> >
> 
> 

~|
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:299765
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFImage Error... Unsupported Image Type??

[C. Hatton Humphrey]

Can't tell if it was CMYK or RGB.

Here's what I know from looking at the image:
File Size: 640k
440px x 250px (the size of the gallery viewer)
Resolution: 300dpi (grr... the bane of my existence)
Bit Depth: 24
Resolution Unit 2
Color Representation Unknown

That is what Vista has to say about the image.



On Fri, Feb 22, 2008 at 4:49 PM, Dennis Powers <[EMAIL PROTECTED]> wrote:
> >> it's a JPEG that she cropped in Photoshop.
>
>  She most likely saved it as a C  images?
>
>
>
>  Dennis Powers
>  UXB Internet - A website design and Hosting Company
>  http://www.uxbinternet.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:299764
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Free MS Software for Students - when will Adobe step up?

[Russ]

Do we have more information on this free licensing for students? 

Russ



> -Original Message-
> From: James Blaha [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 8:12 PM
> To: CF-Talk
> Subject: Re: Free MS Software for Students - when will Adobe step up?
> 
> Hi Russ,
> 
> CF is free to use for up to 2 IP's. Adobe also has free licensing for
> people working in education as well as students I believe.
> 
> -Jim
> 
> 
> 
> 

~|
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:299763
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Free MS Software for Students - when will Adobe step up?

[James Blaha]

Hi Russ,

CF is free to use for up to 2 IP's. Adobe also has free licensing for people 
working in education as well as students I believe.

-Jim



~|
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:299762
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Gerald Guido]

I am suprised y'all are hanging on this long. I would expext that some of
you would have chipped in and got a dedicated box by now. The notion of a
hosting collective just came to mind. Kinda like OSS but for hosting.

And no, I haven't been following.

Best of luck with this. I feel your pain.

G



On Fri, Feb 22, 2008 at 2:45 PM, J W <[EMAIL PROTECTED]> wrote:

> Down since this AM... Again. I really hope they resolve this ASAP.
>
> Had VCP for a while, now thats dead.
> NO HTTP
> I have mail, or at least I am able to connect and check.
> RDP is functioning...
>
> Sometimes, If I can get into the VCP I restart the container and sometimes
> that brings up HTTP
> If I can RDP in, I can restart that way. Sometimes that works...
>
> I am real lucky my clients are being understanding...right now... One of
> mine runs a charter business and if we were in season right now, I would
> have lost a client over this... Who knows what trickle down impact is
> going
> to occur now.
>
> Jeff
>
>
> 

~|
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:299761
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: The unofficial ahphosting status thread

[Michael E. Carluen]

You can do the same thing using the free MySQL Administrator (GUI) tool.



> -Original Message-
> From: Anthony Katgert [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 2:09 PM
> To: CF-Talk
> Subject: Re: The unofficial ahphosting status thread
> 
> Pfff
> 
> I was able to connect to the mysql database server and created a backup
> and extracted a mysql.sql file to my notebook
> 
> with Navicat
> 
> 
> 
> >> I do not follow you Tom.
> >>
> >> What did you mean with that remark.
> >> "
> >> > Not a lot of help now, but next time you'll make sure systems send
> >> you
> >> >
> >> > nightlies, yes ? :-)
> >
> >I'd assume "Nightly Backups".
> >
> >For example I've got a Virtual PC Server running here at home with
> >duplicates (my "Disaster Recovery" servers) of my production ColdFusion
> and
> >database servers.  I use a SQL Server DTS (Data Transformation Services)
> >package scheduled to run every night at 3am which copies all data from
> the
> >production database to the DR database.
> >
> >I don't actually do any backups for the CF server (since I only update it
> >from a development virtual server so it's always "backed up") but you
> could
> >easily script an FTP to copy any important files.  Of course there are
> easy
> >to use automated tools as well.
> >
> >You can also, of course, run an actual backup program in "difference"
> mode
> >which saves to a remote location - the initial backup would take a while
> >(even over broadband) but the nightly differences should be small.
> >
> >More sensitive data might require quicker backups (hourly or even "live")
> >but that of course consumes more resources as well.  Most databases have
> >methods for "subscribing" to data todo close-to-live backups (using log
> >shipping - which sends updates to one database's log files to another
> from
> >minute to minute is popular).
> >
> >The bottom line is that you have your data (or at least the vast majority
> of
> >it) when things like this happen.
> >
> >There are plenty of cheap or free options for all this stuff but it does
> >take some resources (time and sometimes equipment) but every pain will be
> >forgotten then first time that backup saves your hide.  ;^)
> >
> >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:299760
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: The unofficial ahphosting status thread

[Anthony Katgert]

Pfff

I was able to connect to the mysql database server and created a backup and 
extracted a mysql.sql file to my notebook

with Navicat



>> I do not follow you Tom.
>> 
>> What did you mean with that remark.
>> "
>> > Not a lot of help now, but next time you'll make sure systems send
>> you
>> >
>> > nightlies, yes ? :-)
>
>I'd assume "Nightly Backups".
>
>For example I've got a Virtual PC Server running here at home with
>duplicates (my "Disaster Recovery" servers) of my production ColdFusion and
>database servers.  I use a SQL Server DTS (Data Transformation Services)
>package scheduled to run every night at 3am which copies all data from the
>production database to the DR database.
>
>I don't actually do any backups for the CF server (since I only update it
>from a development virtual server so it's always "backed up") but you could
>easily script an FTP to copy any important files.  Of course there are easy
>to use automated tools as well.
>
>You can also, of course, run an actual backup program in "difference" mode
>which saves to a remote location - the initial backup would take a while
>(even over broadband) but the nightly differences should be small.
>
>More sensitive data might require quicker backups (hourly or even "live")
>but that of course consumes more resources as well.  Most databases have
>methods for "subscribing" to data todo close-to-live backups (using log
>shipping - which sends updates to one database's log files to another from
>minute to minute is popular).
>
>The bottom line is that you have your data (or at least the vast majority of
>it) when things like this happen.
>
>There are plenty of cheap or free options for all this stuff but it does
>take some resources (time and sometimes equipment) but every pain will be
>forgotten then first time that backup saves your hide.  ;^)
>
>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:299759
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

accepting/returning cookies with cfinvoke

[Brad Wood]

If I am using cfinvoke to consume a web service, will ColdFusion accept
and or return cookies set by the third party for authentication
purposes?

 

I'm thinking no, but how then does one do that?

 

~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:299758
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFImage Error... Unsupported Image Type??

[Dennis Powers]

>> it's a JPEG that she cropped in Photoshop.

She most likely saved it as a Chttp://www.uxbinternet.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:299757
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFC protect from SQL Injection?

[Mark Kruger]

 I just put a post on my blog with some CF examples of SQL injection using
character fields. Perhaps some of you could add additional cases.

http://www.coldfusionmuse.com

-mk

-Original Message-
From: Chris Norloff [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 2:35 PM
To: CF-Talk
Subject: RE: CFC protect from SQL Injection?

Good point, that's not a good example for ColdFusion, is it. But I figure
there's more to a SQL Injection attack than just the single-quote attack?

Thanks,
Chris 

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Friday, February 22, 2008 11:31 AM
To: CF-Talk
Subject: RE: CFC protect from SQL Injection?

My point is that this won't work in CF, because CF auto escapes single
quotes in variables... 

Russ

> -Original Message-
> From: Chris Norloff [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 11:15 AM
> To: CF-Talk



~|
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:299756
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: MS Source Fource Super Friends

[Billy Cox]

It's that chick in the white lab coat that I'm worried about. She look like
she about to go Rodney King on some fool. As for that Ben Kenobi guy giving
the Nazi salute, that is sooo 1937.

Btw, what Jedi worth his lightsaber wears gloves and a matching headband?



-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 10:00 AM
To: CF-Talk
Subject: Re: MS Source Fource Super Friends


On Friday 22 Feb 2008, Gerald Guido wrote:
> One word: Gaytarded

Who wouldn't want a mini-Forta or Camden on their key ring... :-)

-- 
Tom Chiverton
Helping to interactively iterate scalable m-commerce
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
list of members is available for inspection at the registered office. Any
reference to a partner in relation to Halliwells LLP means a member of
Halliwells LLP.  Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299755
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFImage Error... Unsupported Image Type??

[Jake Churchill]

Is there resizing going on?  If so, what are you using to resize it?  I made
a photo gallery plugin for Farcry 3 and had this error a few times.  If I
went into Fireworks and did "Save As" the image than worked fine.  The
images that I had problems with came from .TIF and we used a batch
conversion program to change them over.

_ 

Jake Churchill 
Team Leader
11204 Davenport, Ste. 100
Omaha, NE  68154 
http://www.cfwebtools.com 
402-408-3733 x103 


-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 2:59 PM
To: CF-Talk
Subject: CFImage Error... Unsupported Image Type??

I've just finished working on a photo gallery and now that the client
is using it she has an image that is coming up "Unsupported Image
Type"

Funny thing is that it's a JPEG that she cropped in Photoshop.

Any ideas?
Hatton



~|
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:299754
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFImage Error... Unsupported Image Type??

[C. Hatton Humphrey]

I've just finished working on a photo gallery and now that the client
is using it she has an image that is coming up "Unsupported Image
Type"

Funny thing is that it's a JPEG that she cropped in Photoshop.

Any ideas?
Hatton

~|
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:299753
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Chris Norloff]

Good point, that's not a good example for ColdFusion, is it. But I figure
there's more to a SQL Injection attack than just the single-quote attack?

Thanks,
Chris 

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 11:31 AM
To: CF-Talk
Subject: RE: CFC protect from SQL Injection?

My point is that this won't work in CF, because CF auto escapes single
quotes in variables... 

Russ

> -Original Message-
> From: Chris Norloff [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 11:15 AM
> To: CF-Talk
> Subject: RE: CFC protect from SQL Injection?
> 
> Great info, thanks Paul.
> 
> Here's a good link describing a SQL Injection attack during a 
> penetration test.  Good for those who say "I can't do it therefore no 
> attacker could do it."
> http://www.unixwiz.net/techtips/sql-injection.html
> 


~|
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:299752
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: "Unknown connection error" problem w/ ColdFusion 4.5

[Chris Norloff]

I don't have any solutions, though I'd try different versions of drivers,
and ask the DB folks to run a trace on it to see if you can get some data.
You might try different datasource connection settings (maintain
connections, or not ... etc.). It might take a bit of trial and error to
find something workable.  Also, try the web server logs to see if a
particular page is being called when you get the error.

good luck,
Chris 

-Original Message-
From: Meghan Belanger [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 12:17 PM
To: CF-Talk
Subject: "Unknown connection error" problem w/ ColdFusion 4.5



-
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = ()

Unknown connection error for the data source, 'CPAS_VASC.'

The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (51:2) to (51:76).

-



~|
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:299751
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Bobby Hartsfield]

Ha!

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




-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 2:54 PM
To: CF-Talk
Subject: RE: CFC protect from SQL Injection?

I 'member those days.  All data requests were handled by a http://William.Seiter.com

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 6:43 AM
To: CF-Talk
Subject: Re: CFC protect from SQL Injection?

On Friday 22 Feb 2008, Peterson, Chris wrote:
> Yea, using text files for data wouldn't be as exploitable either, but I
> don't think everyone will use that as a rationale to switch to text
> based data storage =)

I'm going back to pencil and paper data storage :-)

-- 
Tom Chiverton
Helping to enormously monetize network deliverables
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
list of members is available for inspection at the registered office. Any
reference to a partner in relation to Halliwells LLP means a member of
Halliwells LLP.  Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299750
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 to populate a table from a query?

[Bobby Hartsfield]

Lol it didn't. I was helping you ;-)


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




-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 2:49 PM
To: CF-Talk
Subject: RE: How to populate a table from a query?

I am glad that it helped you.

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 5:04 AM
To: CF-Talk
Subject: RE: How to populate a table from a query?

Number 3 of that blog will result in invalid html ( with no s)
anytime that the last row has exactly 4 items in it. Try this... I Changed 4
to 2 of course.




#data#


 
 
  
 





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



-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 21, 2008 11:04 PM
To: CF-Talk
Subject: RE: How to populate a table from a query?

I blogged on it here:
http://wsoncf.blogspot.com/2008/02/tips-tricks-many-times-on-informational.h
tml

It looks like you want #3 and just change the 'mod' to 2.

William


-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com

-Original Message-
From: Colman, Richard [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 21, 2008 7:49 PM
To: CF-Talk
Subject: How to populate a table from a query?

I wish to dynamically populate table across columns and rows, like:

++-+
|#query.row1#| #query.row2#|
++-+
|#query.row3#|#query.row4# |
++-+




~|
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:299749
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Free MS Software for Students - when will Adobe step up?

[Cutter (CFRelated)]

I thought they gave Flex, and a few other programs, to students already? 
Started about a year ago...

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

Russ wrote:
> MS DreamSpark - https://downloads.channel8.msdn.com/ has free Visual Studio
> 2008, Windows Server 2003, MS Expression Studio and XNA Game Studio 2.0 for
> students.  
> 
>  
> 
> This is exactly the type of marketing that I was talking about that Adobe
> should do.  
> 
>  
> 
> 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:299748
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFC protect from SQL Injection?

[William Seiter]

I 'member those days.  All data requests were handled by a http://William.Seiter.com

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 6:43 AM
To: CF-Talk
Subject: Re: CFC protect from SQL Injection?

On Friday 22 Feb 2008, Peterson, Chris wrote:
> Yea, using text files for data wouldn't be as exploitable either, but I
> don't think everyone will use that as a rationale to switch to text
> based data storage =)

I'm going back to pencil and paper data storage :-)

-- 
Tom Chiverton
Helping to enormously monetize network deliverables
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
list of members is available for inspection at the registered office. Any
reference to a partner in relation to Halliwells LLP means a member of
Halliwells LLP.  Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299747
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Calling web services via CF5

[Rey Bango]

Makes sense. Thanks for the suggestion Russ. :)

Rey

Russ wrote:
> I've used CFHTTP with problem web services (where cfinvoke wasn't working).
> If you have CF8 locally, you can try doing a cfinvoke and capturing the data
> using wireshark and then just replicating that with cfhttp. 
> 
> Russ
> 
>> -Original Message-
>> From: Rey Bango [mailto:[EMAIL PROTECTED]
>> Sent: Friday, February 22, 2008 12:23 PM
>> To: CF-Talk
>> Subject: Re: Calling web services via CF5
>>
>> That's what I'm thinking as Russ but since I've never done it, I wasn't
>> quite sure if it was even doable.
>>
>> Rey...
>>
>> Russ wrote:
>>> CFHTTP?
>>>
 -Original Message-
 From: Rey Bango [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 22, 2008 11:55 AM
 To: CF-Talk
 Subject: Calling web services via CF5

 Not sure if this is possible but can a web service be called via CF5? I
 know that its not built in like in CFMX but is there some other way of
 doing this?

 Rey...


>>>
>>
> 
> 

~|
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:299743
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: FckEditor kills FF2's built-in speller

[Dominic Watson]

Have you cleared your browsers cache? Any changes to the FCKEditor config
file require browswer cache flush to take effect...

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk


~|
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:299746
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[J W]

Down since this AM... Again. I really hope they resolve this ASAP.

Had VCP for a while, now thats dead.
NO HTTP
I have mail, or at least I am able to connect and check.
RDP is functioning...

Sometimes, If I can get into the VCP I restart the container and sometimes
that brings up HTTP
If I can RDP in, I can restart that way. Sometimes that works...

I am real lucky my clients are being understanding...right now... One of
mine runs a charter business and if we were in season right now, I would
have lost a client over this... Who knows what trickle down impact is going
to occur now.

Jeff


~|
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:299744
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 to populate a table from a query?

[William Seiter]

I am glad that it helped you.

William

-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 5:04 AM
To: CF-Talk
Subject: RE: How to populate a table from a query?

Number 3 of that blog will result in invalid html ( with no s)
anytime that the last row has exactly 4 items in it. Try this... I Changed 4
to 2 of course.




#data#


 
 
  
 





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



-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 21, 2008 11:04 PM
To: CF-Talk
Subject: RE: How to populate a table from a query?

I blogged on it here:
http://wsoncf.blogspot.com/2008/02/tips-tricks-many-times-on-informational.h
tml

It looks like you want #3 and just change the 'mod' to 2.

William


-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com

-Original Message-
From: Colman, Richard [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 21, 2008 7:49 PM
To: CF-Talk
Subject: How to populate a table from a query?

I wish to dynamically populate table across columns and rows, like:

++-+
|#query.row1#| #query.row2#|
++-+
|#query.row3#|#query.row4# |
++-+


~|
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:299745
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFImage watermark substitute

[Gerald Guido]

I used to use CFX_Image. You would have to get your ISP to register it
though. ImageCFC doesn't require that.

http://www.kolumbus.fi/jukka.manner/\\

G


On Fri, Feb 22, 2008 at 1:11 PM, Walter Conti <[EMAIL PROTECTED]> wrote:

> My ISP did not upgrade to CF8 yet.
> Is there anything that I can use instead of CFImage
>  Thank You
>
> 

~|
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:299742
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: LDAP Query for group members

[Burns, John D]

AWESOME! Thank you so much for the help. Is it as simple to add users to
the group using the same method? Did you come up with this on your own
or find this info somewhere? Any other tips of things I can look out for
as I'm working with CFLDAP?

John

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 12:08 PM
To: CF-Talk
Subject: RE: LDAP Query for group members

There are a couple of solutions to this issue, however, one is the best.
I'll save that for last, of course.

"Member" is a multi-value attribute in Active Directory.  By default, it
is a comma-delimited value.  As you have found, distinguished names are
also comma-delimted by nature.

You can solve this issue by using CFLDAP's SEPARATOR attribute.  If you
specify a tab char, chr(9), you will get back a tab-separated list of
member distinguished names.  You can then use CFLOOP to loop over each
member.  However, if you want to know the member's first name, you would
have to perform another LDAP query for each member.  That could, and
will, be very slow, if you have a large group.

You will also have a limitation of 1000 members.  Active Directory
returns only 1000 values in a multi-value attribute.  There is a
workaround for this, but it really sucks.  I don't even want to talk
about it.

Basically, this will get you close to what you are doing now, with the
only improvement of a tab-separated list of members.

The best solution comes now...  It is so simple, it will make you
giggle.

Rather than query a group's members, you are better off querying all
users who are a member of a group.

Basically, you will set your filter to be:
"(&(objectCategory=Person)(memberOf=DN=GroupName, OU=Org, DC=domain,
DC=com))"

Also, you need to specify the DELIMITER attribute in the CFLDAP tag.
Set it to a tab character chr(9).  You won't be passing any tabs in your
filter, however, this prevents any errors because of the commas in the
group's distinguished name.

Then, in your CFLDAP tag, you can specify all of the user attributes
that you need: givenName, sn, title, department, telephoneNumber, etc.
You will get it all back in one CF query object.

The best part is that you are not limited to the 1000-value limit that
you would have hit by using the first method.

However, you may hit another limit in the number of records that Active
Directory returns via LDAP queries.  By default, I think it may be 1000,
but you can modify your domain controllers to increase that limit.  I
increased our limit to 10,000 records.

If you have this problem, Google "ntdsutil and maxpagesize" or just
click here: http://support.microsoft.com/kb/315071

m!ke

~|
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:299741
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: LDAP Query for group members

[Burns, John D]

Michael-

AWESOME! Thank you so much for the help. Is it as simple to add users to
the group using the same method? Did you come up with this on your own
or find this info somewhere? Any other tips of things I can look out for
as I'm working with CFLDAP?

John

-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 12:08 PM
To: CF-Talk
Subject: RE: LDAP Query for group members

There are a couple of solutions to this issue, however, one is the best.
I'll save that for last, of course.

"Member" is a multi-value attribute in Active Directory.  By default, it
is a comma-delimited value.  As you have found, distinguished names are
also comma-delimted by nature.

You can solve this issue by using CFLDAP's SEPARATOR attribute.  If you
specify a tab char, chr(9), you will get back a tab-separated list of
member distinguished names.  You can then use CFLOOP to loop over each
member.  However, if you want to know the member's first name, you would
have to perform another LDAP query for each member.  That could, and
will, be very slow, if you have a large group.

You will also have a limitation of 1000 members.  Active Directory
returns only 1000 values in a multi-value attribute.  There is a
workaround for this, but it really sucks.  I don't even want to talk
about it.

Basically, this will get you close to what you are doing now, with the
only improvement of a tab-separated list of members.

The best solution comes now...  It is so simple, it will make you
giggle.

Rather than query a group's members, you are better off querying all
users who are a member of a group.

Basically, you will set your filter to be:
"(&(objectCategory=Person)(memberOf=DN=GroupName, OU=Org, DC=domain,
DC=com))"

Also, you need to specify the DELIMITER attribute in the CFLDAP tag.
Set it to a tab character chr(9).  You won't be passing any tabs in your
filter, however, this prevents any errors because of the commas in the
group's distinguished name.

Then, in your CFLDAP tag, you can specify all of the user attributes
that you need: givenName, sn, title, department, telephoneNumber, etc.
You will get it all back in one CF query object.

The best part is that you are not limited to the 1000-value limit that
you would have hit by using the first method.

However, you may hit another limit in the number of records that Active
Directory returns via LDAP queries.  By default, I think it may be 1000,
but you can modify your domain controllers to increase that limit.  I
increased our limit to 10,000 records.

If you have this problem, Google "ntdsutil and maxpagesize" or just
click here: http://support.microsoft.com/kb/315071

m!ke

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 9:30 AM
To: CF-Talk
Subject: LDAP Query for group members

I'm trying to find out if there's a simpler way to do this than what I'm
doing. Currently, I'm querying a group from LDAP and retrieving the
attribute called Member which gives me this ugly result set of one
record with all of these domain users' distinguished names instead of
just the AD username. I can parse this, but it's a mess because the
names look like this: CN=User.Name, OU=Users, OU=Location,
OU=Organization, DC=domain, DC=com, CN=User2.Name, OU=Users,.

The ldap code looks like this currently:



I'd like to find a way to query the names and have them return as a
result set with one row for each user. Obviously, the parsing of the
file would be difficult because of all the commas in a single record but
it's possible because of each record starting with CN. Anyone have a
better way of doing this? Is there some sort of LDAP function you can
pass to get it to return just the username instead of the full DN?
Eventually, I'm assuming I'll hit the same roadblock on querying a
user's groups to see if they're in a specific group. Any information to
make my life easier would be greatly appreciated. Thanks!

John Burns



~|
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:299740
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: FckEditor kills FF2's built-in speller

[Don L]

>Looks like there's an option, FCKConfig.FirefoxSpellChecker, in the
>fckconfig.js file that *should* control that.

Hmm, no luck for me, searched for it with fckconfig.js to no avail (the editor 
came with CF8 standard), commented out the following block for default IE 
speller
/*
FCKConfig.SpellChecker  = 'ieSpell' ;   // 'ieSpell' | 
'SpellerPages'
FCKConfig.IeSpellDownloadUrl= 'http://www.iespell.com/download.php' ;
// tried to comment out the following line; dl; 01/25/2008
FCKConfig.SpellerPagesServerScript = 'server-scripts/spellchecker.php' ;
// Available extension: .php .cfm .pl
// FCKConfig.SpellerPagesServerScript = = './server-scripts/spellchecker.cfm';
*/

added the following line,
FCKConfig.FirefoxSpellChecker = true; // outcome: still to no avail.

Do I have to restart cf server to make them take effect of the new settings?
Thought they are client side js, so, no need for cf server restart...

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:299739
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFImage watermark substitute

[Russ]

imageCFC

Russ

> -Original Message-
> From: Walter Conti [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 1:12 PM
> To: CF-Talk
> Subject: CFImage watermark substitute
> 
> My ISP did not upgrade to CF8 yet.
> Is there anything that I can use instead of CFImage
>  Thank You
> 
> 

~|
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:299738
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: MS Source Fource Super Friends

[s. isaac dealey]

> I'll bet if Apple did the same thing they'd be so "cute and kitschy"
> or "irreverent".  ;^)

Halo there! 

-- 
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:299737
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Daniel Roberts]

"Creating a report is single-threaded"

That is something I've been curious/worried about and would explain the huge 
change in performance.

That wouldn't be a problem and would probably improve performance for a lot of 
small reports, but the report I was testing with many sub-reports went from 
about 2 minutes to create up to 30 minutes.

I guess it is time to take another look at Crystal Reports. 

~|
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:299736
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

CFImage watermark substitute

[Walter Conti]

My ISP did not upgrade to CF8 yet. 
Is there anything that I can use instead of CFImage 
http://ad.doubleclick.net/clk;160198600;22374440;w

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

Recommend a Workflow Engine in CF

[Nathan Smith]

I'm looking for a state machine workflow engine written in (or easily consumed 
by) ColdFusion but I can't seem to find anything. Does anyone know of or 
(better yet) have experience using one? 

~|
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:299734
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: MS Source Fource Super Friends

[Dawson, Michael]

I believe his alter-ego was Scorpio Man.

m!ke 

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 11:42 AM
To: CF-Talk
Subject: RE: MS Source Fource Super Friends

Well I'll pass on seeing Forta in tights... what would his super hero
name be? Fusion-beard?

!k

~|
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:299733
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Modding Galleon Forums

[Dennis Powers]

>> encourage you to check out Galleon

I don't suppose it will run on CF5 will it?

>> Side effects include dizziness, nausea, and a slight
>> tingling feeling in your extremities.

I get this when I ask such questions.



Best Regards,

Dennis Powers
UXB Internet - A website design and Hosting Company
690 Wolcott Road
P.O. Box 6029
Wolcott, CT  06716
Tel: (203)879-2844
http://www.uxbinternet.com/
http://www.uxb.net/



~|
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:299732
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Free MS Software for Students - when will Adobe step up?

[Charlie Griefer]

On Fri, Feb 22, 2008 at 9:08 AM, Russ <[EMAIL PROTECTED]> wrote:
> MS DreamSpark - https://downloads.channel8.msdn.com/ has free Visual Studio
>  2008, Windows Server 2003, MS Expression Studio and XNA Game Studio 2.0 for
>  students.
>
>  This is exactly the type of marketing that I was talking about that Adobe
>  should do.

i'd wager that adobe is aware of what their competitors are doing, and
have taken all of this into consideration in making their decisions.
remember, just because we don't see any particular actions doesn't
mean adobe is ignoring it.  we don't know what goes on behind closed
doors.  i would put money on the fact that they're not completely
ignorant as to what's going on around them, and that there are factors
going into their decisions that we're not necessarily aware of.

would it be nice?  sure.  i'm not debating that at all.  but i put a
certain amount of faith into the fact that there's a whole lot going
on at adobe that we're not privvy to :)

-- 
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:299731
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

disaster planning [was: Re: The unofficial ahphosting status thread]

[Jochem van Dieten]

Russ wrote:
> How would you go about something like this?  Do you just pay for an extra
> host as a backup and not use it?  How do you synchronize your db, etc. 

For a simple site the 'things to move' usually breaks out to:
- code
Easy, will be in your repository on another location.
- email
Is only really a consideration if you store mail on the server instead 
of locally. Even then it is easy to backup and delaying or even loosing 
a few hours of email is usually survivable for a business. (The simplest 
way to do your backups is to set up another e-mail server and do a 
'forward and keep a copy' on your primary mailserver. That other server 
can even be at your own home since it is essentially  a write-only 
server you just do a bulk upload of .mbox files to your new host if you 
ever need to restore mail that was stored on the server).
- uploads
Easy to do a remote backup over FTP at the interval you are comfortable 
with.
- databases
Depends on database and hoster. Some databases (MySQL, PostgreSQL) allow 
for remote backups and you can do your own backups at the interval you 
are comfortable with. For MS SQL Server you depend on the hoster for 
backups because backups are written to the local filesystem and that is 
typically not accessible to you. (For our MS SQL Server shared hosting 
we do hourly backups and if customers want they can get a copy FTP'ed to 
their site FTP account.)


In order to move it you need:
- a place to host.
- control over DNS so you can point your site to the new host.

Something you should not forget is IP dependencies at business partners. 
If you are doing transactions with third parties that have a list of 
allowed IP addresses you need to make sure you can either update those 
IP addresses instantaneously or you register the fallback IP addresses 
beforehand.



A good way to start planning this is to go over the archive of all your 
communications with your current hoster and see what they had to do to 
get you set up, because your new host probably has to do the same for 
you. Once you have that, set up a mirror on a local development server 
and see what you run in to.

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:299730
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: MS Source Fource Super Friends

[Kevin Aebig]

Well I'll pass on seeing Forta in tights... what would his super hero name
be? Fusion-beard?

!k

-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 10:00 AM
To: CF-Talk
Subject: Re: MS Source Fource Super Friends

On Friday 22 Feb 2008, Gerald Guido wrote:
> One word: Gaytarded

Who wouldn't want a mini-Forta or Camden on their key ring... :-)

-- 
Tom Chiverton
Helping to interactively iterate scalable m-commerce
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and
Wales under registered number OC307980 whose registered office address is at
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A
list of members is available for inspection at the registered office. Any
reference to a partner in relation to Halliwells LLP means a member of
Halliwells LLP.  Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may
be confidential or legally privileged.  If you are not the addressee you
must not read it and must not use any information contained in nor copy it
nor inform any person other than Halliwells LLP or the addressee of its
existence or contents.  If you have received this email in error please
delete it and notify Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299729
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

"Unknown connection error" problem w/ ColdFusion 4.5

[Meghan Belanger]

I work for a large corporation that has a number of legacy systems, as large 
corporations do.  While we're running ColdFusion MX 7 locally, my department 
(me specifically) is supporting an application that was written years ago in 
ColdFusion 4.0.  I managed to update this app to ColdFusion 4.5.1 when we took 
over support, but any further upgrades are currently not an option, as we work 
in a regulated environment and so the time and money involved in taking on that 
kind of project is prohibitive for a system that will most likely be retired 
within the next couple of years.

That's my long-winded way of saying "I know that I could probably fix this 
issue by not running antiquated software on an antiquated server, but since I'm 
not able to do so, I'd appreciate other suggestions if you've got them!"  :)

The server on which this CF 4.5.1 app runs is Windows 2000, and we've got the 
Oracle 8.1.7 client installed.  When I originally set up the server, we had 
Oracle 9i drivers installed, but this caused a recurrent error in which the 
database connection seemed to be dropped after a period of inactivity, and 
could not be re-established.  I resolved that error by installing Oracle 8.1.7 
instead.  The database connected to this app is Oracle 9i.

So the problem is this: for almost as long as we've had this application up and 
running on its current server, the following error appears, in general, at 
least once per day:

-
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = ()

Unknown connection error for the data source, 'CPAS_VASC.'

The error occurred while processing an element with a general identifier of 
(CFQUERY), occupying document position (51:2) to (51:76).

-

The error seems to occur randomly (in the middle of people working on the 
system, it seems, but there is no rhyme or reason as to when it happens), and 
when it does, we are forced to either a) reboot the server, or b) bounce the 
ColdFusion service to get it back up.  If I log in to the web server while this 
message is occurring, everything appears fine.  I can access the ColdFusion 
Administrator, but if I go into the ODBC section and try to verify my data 
source, it will fail.  As I said before, bouncing the ColdFusion service will 
fix it.  We have the web server on a nightly reboot, because for a while that 
seemed to help. 

So the problem seems to be that ColdFusion loses its ability to connect with 
the database, even in the middle of people working, and cannot re-establish a 
connection until the service is restarted.  Why would this be?  I've tried 
Googling this over and over again, and have had no luck finding any reference 
to this kind of problem.  This has gone on for at least a year at this point.  
I'm trying to find answers again because for some reason this problem has 
gotten worse over the past couple of days.  On Wednesday, this happened four 
times within the span of about two hours.  The weird part is that the system 
can function correctly for long periods of time, and then this error will pop 
up.  So I know the ODBC is set up correctly, and it's not that it will never 
connect at all.

Are there any CF Administrator settings that I can modify to address this 
issue?  Has anyone ever heard of anything like this before?  I'm feeling quite 
desperate at this point.  They're looking to replace this system with something 
from an outside vendor, but the speed of corporate America is glacial, and I 
fear that I'll be dealing with this for years to come.

Meghan 

~|
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:299728
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Dennis Powers]

>> This won't work with an Acces database, 
>> so Access databases are not so evil ;-)

Other than the Jet drivers leak memory, will not handle very many concurrent
users/threads and are as slow as molasses when making complex queries. Maybe
not evil but they sure are painful in a production environment :)



Dennis Powers
UXB Internet - A website design and Hosting Company
http://www.uxbinternet.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:299727
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Calling web services via CF5

[Russ]

I've used CFHTTP with problem web services (where cfinvoke wasn't working).
If you have CF8 locally, you can try doing a cfinvoke and capturing the data
using wireshark and then just replicating that with cfhttp. 

Russ

> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 12:23 PM
> To: CF-Talk
> Subject: Re: Calling web services via CF5
> 
> That's what I'm thinking as Russ but since I've never done it, I wasn't
> quite sure if it was even doable.
> 
> Rey...
> 
> Russ wrote:
> > CFHTTP?
> >
> >> -Original Message-
> >> From: Rey Bango [mailto:[EMAIL PROTECTED]
> >> Sent: Friday, February 22, 2008 11:55 AM
> >> To: CF-Talk
> >> Subject: Calling web services via CF5
> >>
> >> Not sure if this is possible but can a web service be called via CF5? I
> >> know that its not built in like in CFMX but is there some other way of
> >> doing this?
> >>
> >> Rey...
> >>
> >>
> >
> >
> 
> 

~|
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:299726
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: LDAP Query for group members

[Dawson, Michael]

>Also, you need to specify the DELIMITER attribute in the CFLDAP tag.
Set it to a tab character chr(9).  You won't be passing any tabs in your
filter, however, this prevents any errors because of the commas in the
group's distinguished name.

Ignore this part of my message.  This is only needed if you are
specifying a distinguished name in the ATTRIBUTES attribute.  Since you
are specifying the group's DN in the FILTER attribute, you don't need
the DELIMITER attribute.

Sorry for the confusion.  I'm doing this from memory since I'm on a very
slow dial-up connection through my Treo and I don't have access to my
servers from here.

m!ke

~|
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:299724
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Calling web services via CF5

[Rey Bango]

That's what I'm thinking as Russ but since I've never done it, I wasn't 
quite sure if it was even doable.

Rey...

Russ wrote:
> CFHTTP?
> 
>> -Original Message-
>> From: Rey Bango [mailto:[EMAIL PROTECTED]
>> Sent: Friday, February 22, 2008 11:55 AM
>> To: CF-Talk
>> Subject: Calling web services via CF5
>>
>> Not sure if this is possible but can a web service be called via CF5? I
>> know that its not built in like in CFMX but is there some other way of
>> doing this?
>>
>> Rey...
>>
>>
> 
> 

~|
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:299725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Calling web services via CF5

[Russ]

CFHTTP?

> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 11:55 AM
> To: CF-Talk
> Subject: Calling web services via CF5
> 
> Not sure if this is possible but can a web service be called via CF5? I
> know that its not built in like in CFMX but is there some other way of
> doing this?
> 
> Rey...
> 
> 

~|
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:299723
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: LDAP Query for group members

[Dawson, Michael]

There are a couple of solutions to this issue, however, one is the best.
I'll save that for last, of course.

"Member" is a multi-value attribute in Active Directory.  By default, it
is a comma-delimited value.  As you have found, distinguished names are
also comma-delimted by nature.

You can solve this issue by using CFLDAP's SEPARATOR attribute.  If you
specify a tab char, chr(9), you will get back a tab-separated list of
member distinguished names.  You can then use CFLOOP to loop over each
member.  However, if you want to know the member's first name, you would
have to perform another LDAP query for each member.  That could, and
will, be very slow, if you have a large group.

You will also have a limitation of 1000 members.  Active Directory
returns only 1000 values in a multi-value attribute.  There is a
workaround for this, but it really sucks.  I don't even want to talk
about it.

Basically, this will get you close to what you are doing now, with the
only improvement of a tab-separated list of members.

The best solution comes now...  It is so simple, it will make you
giggle.

Rather than query a group's members, you are better off querying all
users who are a member of a group.

Basically, you will set your filter to be:
"(&(objectCategory=Person)(memberOf=DN=GroupName, OU=Org, DC=domain,
DC=com))"

Also, you need to specify the DELIMITER attribute in the CFLDAP tag.
Set it to a tab character chr(9).  You won't be passing any tabs in your
filter, however, this prevents any errors because of the commas in the
group's distinguished name.

Then, in your CFLDAP tag, you can specify all of the user attributes
that you need: givenName, sn, title, department, telephoneNumber, etc.
You will get it all back in one CF query object.

The best part is that you are not limited to the 1000-value limit that
you would have hit by using the first method.

However, you may hit another limit in the number of records that Active
Directory returns via LDAP queries.  By default, I think it may be 1000,
but you can modify your domain controllers to increase that limit.  I
increased our limit to 10,000 records.

If you have this problem, Google "ntdsutil and maxpagesize" or just
click here: http://support.microsoft.com/kb/315071

m!ke

-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 9:30 AM
To: CF-Talk
Subject: LDAP Query for group members

I'm trying to find out if there's a simpler way to do this than what I'm
doing. Currently, I'm querying a group from LDAP and retrieving the
attribute called Member which gives me this ugly result set of one
record with all of these domain users' distinguished names instead of
just the AD username. I can parse this, but it's a mess because the
names look like this: CN=User.Name, OU=Users, OU=Location,
OU=Organization, DC=domain, DC=com, CN=User2.Name, OU=Users,.

The ldap code looks like this currently:



I'd like to find a way to query the names and have them return as a
result set with one row for each user. Obviously, the parsing of the
file would be difficult because of all the commas in a single record but
it's possible because of each record starting with CN. Anyone have a
better way of doing this? Is there some sort of LDAP function you can
pass to get it to return just the username instead of the full DN?
Eventually, I'm assuming I'll hit the same roadblock on querying a
user's groups to see if they're in a specific group. Any information to
make my life easier would be greatly appreciated. Thanks!

John Burns

~|
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:299722
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Free MS Software for Students - when will Adobe step up?

[Russ]

MS DreamSpark - https://downloads.channel8.msdn.com/ has free Visual Studio
2008, Windows Server 2003, MS Expression Studio and XNA Game Studio 2.0 for
students.  

 

This is exactly the type of marketing that I was talking about that Adobe
should do.  

 

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:299721
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Russ]

What db is this supposed to work with?  Doesn't work for me in SQL server.
\' becomes part of the literal.  

select test from test where test='\'';drop table test;--'

Russ

> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 11:48 AM
> To: CF-Talk
> Subject: Re: CFC protect from SQL Injection?
> 
> On Friday 22 Feb 2008, Russ wrote:
> > any so far...
> 
> The last bits of http://www.unixwiz.net/techtips/sql-injection.html are
> quite
> fun i.e.
> "
> after input of __\'; DROP TABLE users; --__ is "protected" by doubling the
> quotes, we get:
> SELECT fieldlist
>   FROM customers
>  WHERE name = '\''; DROP TABLE users; --';
> "
> 
> (I've used __ to delimit the user entered data).
> 
> --
> Tom Chiverton
> Helping to professionally administrate interactive features
> on: http://thefalken.livejournal.com
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> 3EB.  A list of members is available for inspection at the registered
> office. Any reference to a partner in relation to Halliwells LLP means a
> member of Halliwells LLP.  Regulated by The Solicitors Regulation
> Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged.  If you are not the addressee
> you must not read it and must not use any information contained in nor
> copy it nor inform any person other than Halliwells LLP or the addressee
> of its existence or contents.  If you have received this email in error
> please delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.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:299720
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Jochem van Dieten]

Daniel Roberts wrote:
> We recently bought a new server--a dual 2gz quad-core 64bit xeon

> I ran a complex report on our new server and it ran at about 1/20th the speed 
> of our current web server that is maybe 3 years old, 4GB ram, and currently 
> under live load. This is very frustrating. In viewing Windows Task Manager 
> during report creation on our older live server I see that the processor 
> usage can get upto 30-50% while creating a complex report. However on the new 
> server the CPU usage never gets above 4% and it takes forever for the report 
> to complete.

Creating a report is single-threaded so CPU usage should get up to 6.25% 
(12.5% if you have hyperthreading disabled). If it is significantly 
slower then an older server that has an equal performance per thread you 
should get some stacktraces to see what it is doing. It might be that 
you are including images in your report and the processing is done in 
Java instead of in native code due to a 32-bit vs. 64-bit issue.

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:299718
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Calling web services via CF5

[Rey Bango]

Not sure if this is possible but can a web service be called via CF5? I 
know that its not built in like in CFMX but is there some other way of 
doing this?

Rey...

~|
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:299719
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: MS Source Fource Super Friends

[Jim Davis]

> -Original Message-
> From: Paul Vernon [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 10:47 AM
> To: CF-Talk
> Subject: RE: MS Source Fource Super Friends
> 
> Do you think they got Lego's or Lucasfilm's permission to use that look
> and
> those "blah the fource" slogans? Also, it says they are a "fearsome
> four"
> and then shows seven distinct characters including ones that look like
> Karate Kid and Mr Miagi... All topped off with a 60's Batman
> narrative...
> How many rip-offs can MS do on one page...

Dude... you've really gotta lighten up.  ;^)

Christ on a crutch: they're giving away toys.  Yes they're so evil.

(And, by the way - the page clearly says that this is the original "fource"
and "their amazing friends" - thus the 7 characters.  The 60's "Batman" only
spoofed the comic book conventions of the 50's, it didn't invent them and
Lucas doesn't own the word "Force" much less the word "Fource".  These guys
only vaguely look like Lego Minifigs and, in any case, where designed by a
marketing firm that creates custom toys not MS.)

I'll bet if Apple did the same thing they'd be so "cute and kitschy" or
"irreverent".  ;^)

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:299717
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC protect from SQL Injection?

[Tom Chiverton]

On Friday 22 Feb 2008, Russ wrote:
> any so far...

The last bits of http://www.unixwiz.net/techtips/sql-injection.html are quite 
fun i.e. 
"
after input of __\'; DROP TABLE users; --__ is "protected" by doubling the 
quotes, we get: 
SELECT fieldlist
  FROM customers
 WHERE name = '\''; DROP TABLE users; --';
"

(I've used __ to delimit the user entered data).

-- 
Tom Chiverton
Helping to professionally administrate interactive features
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299716
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Bobby Hartsfield]

It's obvious what not to do. Don't pass raw, unclean data to a query without
some type of insurance that it can't cause damage. Especially when the
column is numeric. I'd also advise anyone not to believe what you said about
cfquery 'automatically' protecting you 'most of the time' without
cfqueryparam since you didn't include 'as long as you use something else in
its place like val() on numeric fields'

You gave exmaples but are still begging for more so...


select username from users
where userid = #url.myvar#


I would think that this is a perfect example of a 'most of the time' case.

The first thing someone would do would be to assume that 'myvar' is also the
name of the db column. If they are correct, then things move right along. If
not, they will toss an invalid string in hopes to see an actual error
message complete with the full query. If they get it, they know the real
field(s), else they start guessing. If they are just passing by and trying,
they will most likely try a couple and move on if they don't get it. If it's
someone who has chosen the specific target, the odds are that they will keep
at it until they guess the column name(s).

If url.myvar is  [1], the query tries to find the record where userid is 1
blah blah etc etc...
If url.myvar is [0 or 0=0] or [0%20or%200=0] then you might have a problem
since it would find all records.

If you have admins in the same table then the very first record is most
likely the author and therefore most likely the admin with the most rights
yes?

If url.myvar is [0 or 0=0 order by userid] or
[0%20or%201=1%20order%20by%20userid] then the first record is the one CF is
looking at

What to do to prevent it in this case?

where userid = #val(url.myvar)#
or
where userid = 

if its being passed to a cfc, yes you can type it as an integer and be fine
but if you accidentally type it as a string then you are right back to the
same spot as you would be without typing it at all sicne CF is typeless and
will treat 0 as a string if that's what you tell it to do.

If you accidentally type an int to a varcahr in cfqueryparam, you'll still
be safe since cfqueryparam will not allow the string to be executed as a
statement.

And obviously, single quotes and semicolons aren't always needed for a sql
injection 'attack'.

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




-Original Message-
From: Russ [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 9:11 AM
To: CF-Talk
Subject: RE: CFC protect from SQL Injection?

> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 8:37 AM
> To: CF-Talk
> Subject: Re: CFC protect from SQL Injection?
> 
> On Friday 22 Feb 2008, Russ wrote:
> > CFqueryparam is not always beneficial.  Lets say you are doing a batch
> > insert with 1000 records.  The cfqueryparam method is going to be a LOT
> > slower.
> 
> It shouldn't be.
> 

It is, I've tested it.  There is a lot of overhead in passing that many
parameters. 

> > Additionally, everyone keeps talking about how you should use
> cfqueryparam
> > to avoid sql injection, but nobody has shown me an example of sql
> injection
> > without cfqueryparam.  I think I can get the same results from val.
> 
> But you don't get the cached execution plan benefits then.

This is true.  Most of the time, it will perform slightly better.  My point,
though, is that it's not necessary 100% of the time, and you should know how
to construct a query without it that doesn't have sql injection
vulnerabilities.  

This is why I want to start the conversation and get some real world
examples of what not to do.  Unfortunately, nobody has been able to provide
any so far... 

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:299714
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Matthew Williams]

I don't suppose you can set up a similar server, but install the 32-bit version 
of the OS (I know, memory will be an issue depending on your Windows license).  
Based on what MS has in this article (http://support.microsoft.com/kb/896456), 
I'd point the finger at the fact that you're running 32-bit binaries on a 
64-bit system.  This snip in particular from the KB, "Some 32-bit programs may 
run slower on these operating systems than they would on 32-bit versions of 
Windows Server 2003 and of Windows XP. "

But I've not had to deal with this issue first hand (yet).  Hopefully when 
Adobe release the 64-bit binaries it well help your situation.


Matthew Williams
Geodesic GraFX
www.geodesicgrafx.com/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:299715
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Daniel Roberts]

"What JVM are you using?"

"C:\JRun4\jre\bin\server\jvm.dll" reports version info:

Description: Java HotSpot(TM) Server VM
File Version: 6.0.10.6
Full Version: 1.6.0_01-b06 

~|
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:299713
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Mary Jo Sminkey]

> As a basic belt and braces for a low traffic site, emailing a DB dump 
> off site 
> may suffice, given you can probably set up new hosting* in less than a 
> day if 
> you don't have a load balanced or redundant site set up already.


Yeah, I have a daily backup of all my MySQL DBs set up in Navicat that runs 
every night...sure saved my butt this time around as I was able to get my site 
up somewhere else fairly quickly.



~|
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:299712
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Russ]

My point is that this won't work in CF, because CF auto escapes single
quotes in variables... 

Russ

> -Original Message-
> From: Chris Norloff [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 11:15 AM
> To: CF-Talk
> Subject: RE: CFC protect from SQL Injection?
> 
> Great info, thanks Paul.
> 
> Here's a good link describing a SQL Injection attack during a penetration
> test.  Good for those who say "I can't do it therefore no attacker could
> do it."
> http://www.unixwiz.net/techtips/sql-injection.html
> 
> Our problem is existing code with lots of Form and URL variables used in
> cfquerys - retrofitting is a hard sell, so we're looking at how much
> exposure we have, and how to mitigate the problem.
> 
> thanks,
> Chris
> 
> -- Original Message --
> From: "Paul Vernon" <[EMAIL PROTECTED]>
> Reply-To: cf-talk@houseoffusion.com
> Date:  Fri, 22 Feb 2008 14:47:24 -
> 
> >I know it's a bit late to join in on the conversation but, here goes...
> 
> 
> 
> 
> 
> 

~|
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:299711
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Problems with CF8 Enterprise on multi-core processors, especially reports

[Mark Kruger]

Daniel,

I've installed on a dual proc dual core many times and never seen this
message. It must have something to do with the "quad" core...

-mark
 

-Original Message-
From: Daniel Roberts [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 10:03 AM
To: CF-Talk
Subject: Re: Problems with CF8 Enterprise on multi-core processors,
especially reports

I looked through the hotfixes and they didn't appear to be relevant to my
situation.

The fact that CF install specifically stated that it was only going to use 2
of 8 processors lead me to believe that a licensing error was to blame for
the problems. 



~|
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:299710
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Tom Chiverton]

On Friday 22 Feb 2008, Daniel Roberts wrote:
> The fact that CF install specifically stated that it was only going to use
> 2 of 8 processors lead me to believe that a licensing error was to blame
> for the problems.

I'd be surprised if it was deliberately quadrupling your run time.

-- 
Tom Chiverton
Helping to collaboratively brand robust market-growth
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299709
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFC protect from SQL Injection?

[Chris Norloff]

Great info, thanks Paul.

Here's a good link describing a SQL Injection attack during a penetration test. 
 Good for those who say "I can't do it therefore no attacker could do it."
http://www.unixwiz.net/techtips/sql-injection.html

Our problem is existing code with lots of Form and URL variables used in 
cfquerys - retrofitting is a hard sell, so we're looking at how much exposure 
we have, and how to mitigate the problem.

thanks,
Chris

-- Original Message --
From: "Paul Vernon" <[EMAIL PROTECTED]>
Reply-To: cf-talk@houseoffusion.com
Date:  Fri, 22 Feb 2008 14:47:24 -

>I know it's a bit late to join in on the conversation but, here goes...





~|
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:299708
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Daniel Roberts]

"Are you running this server in 32-bit mode or 64-bit mode?  ColdFusion only 
runs as a 32-bit application (at this time)."

It is running in 32-bit mode using the "Windows-32-on-Windows-64 (WOW64) 
compatibility layer". I found the command for enabling WOW64 by way of a link 
Ben Forta posted a couple years ago: 
http://www.forta.com/blog/index.cfm/2006/2/6/Connecting-ColdFusion-MX-7-To-64bit-IIS-6

"Is the old server 32-bit, or 64-bit?"

32-bit 

~|
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:299707
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Daniel Roberts]

I looked through the hotfixes and they didn't appear to be relevant to my 
situation.

The fact that CF install specifically stated that it was only going to use 2 of 
8 processors lead me to believe that a licensing error was to blame for the 
problems. 

~|
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:299706
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: MS Source Fource Super Friends

[Chad Gray]

LOL... I want my Mini Forta and Camden!

I wonder if we can assemble a lego person that would come close?  Time to hit 
BrickLink.com.




-Original Message-
From: Tom Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 11:00 AM
To: CF-Talk
Subject: Re: MS Source Fource Super Friends

On Friday 22 Feb 2008, Gerald Guido wrote:
> One word: Gaytarded

Who wouldn't want a mini-Forta or Camden on their key ring... :-)


~|
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:299705
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: FckEditor kills FF2's built-in speller

[morgan l]

Looks like there's an option, FCKConfig.FirefoxSpellChecker, in the
fckconfig.js file that *should* control that.


~|
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:299704
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Terry Schmitt]

My setup so far, and I'm not comfortable with it, is...
I run nightly MySQL backups, zip em, encrypt em, and email to a google account.
My cf code is all in SVN on a different host, so I have all my code.
Email is another story. I don't really have a good off-site plan for that, 
although based on these events, I have moved some email to a different host.


>How would you go about something like this?  Do you just pay for an extra
>host as a backup and not use it?  How do you synchronize your db, etc. 
>
>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:299703
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: MS Source Fource Super Friends

[Tom Chiverton]

On Friday 22 Feb 2008, Gerald Guido wrote:
> One word: Gaytarded

Who wouldn't want a mini-Forta or Camden on their key ring... :-)

-- 
Tom Chiverton
Helping to interactively iterate scalable m-commerce
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299702
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: MS Source Fource Super Friends

[Gerald Guido]

One word: Gaytarded

On Fri, Feb 22, 2008 at 10:46 AM, Paul Vernon <
[EMAIL PROTECTED]> wrote:

> > -Original Message-
> > From: Chad Gray [mailto:[EMAIL PROTECTED]
> > Sent: Friday, February 22, 2008 2:53 PM
> > To: CF-Talk
> > Subject: OT: MS Source Fource Super Friends
> >
> > Come on Adobe, we need action figures too!  :)
> >
> > http://msdn.microsoft.com/events/hero/
> >
>
> Do you think they got Lego's or Lucasfilm's permission to use that look
> and
> those "blah the fource" slogans? Also, it says they are a "fearsome four"
> and then shows seven distinct characters including ones that look like
> Karate Kid and Mr Miagi... All topped off with a 60's Batman narrative...
> How many rip-offs can MS do on one page...
>
> Paul
>
>
>
> 

~|
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:299701
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: MS Source Fource Super Friends

[Tom Chiverton]

On Friday 22 Feb 2008, Paul Vernon wrote:
> How many rip-offs can MS do on one page...

This is MS. 
They'll rip you off, patent it, and then threaten to sue you if you use it.

-- 
Tom Chiverton
Helping to synergistically empower B2C experiences
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299700
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Matthew Williams]

I don't think you're looking in the right direction.  Are you running this 
server in 32-bit mode or 64-bit mode?  ColdFusion only runs as a 32-bit 
application (at this time).  Is the old server 32-bit, or 64-bit?  


Matthew Williams
Geodesic GraFX
www.geodesicgrafx.com/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:299699
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: MS Source Fource Super Friends

[Paul Vernon]

> -Original Message-
> From: Chad Gray [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 2:53 PM
> To: CF-Talk
> Subject: OT: MS Source Fource Super Friends
> 
> Come on Adobe, we need action figures too!  :)
> 
> http://msdn.microsoft.com/events/hero/
> 

Do you think they got Lego's or Lucasfilm's permission to use that look and
those "blah the fource" slogans? Also, it says they are a "fearsome four"
and then shows seven distinct characters including ones that look like
Karate Kid and Mr Miagi... All topped off with a 60's Batman narrative...
How many rip-offs can MS do on one page...

Paul



~|
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:299698
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Problems with CF8 Enterprise on multi-core processors, especially reports

[Tom Chiverton]

On Friday 22 Feb 2008, Daniel Roberts wrote:
> I ran a complex report on our new server and it ran at about 1/20th the
> speed of our current web server that is maybe 3 years old, 4GB ram, and

What JVM are you using ? Have you tried the not-quite-released yet updater 
and/or hotfixes ?

-- 
Tom Chiverton
Helping to completely initiate bleeding-edge metrics
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299697
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Problems with CF8 Enterprise on multi-core processors, especially reports

[Daniel Roberts]

We recently bought a new server--a dual 2gz quad-core 64bit xeon dell with 16GB 
ram. When I installed CF8-Ent in CF server mode I got a message that 8 
processors were detected and only two would be used per the CF license. However 
that shouldn't be the case according to the CF FAQ which states that license is 
for 2 physical processors  which we have, including all cores. I contact Adobe 
support about this issue and I'm still waiting to hear back.

I ran a complex report on our new server and it ran at about 1/20th the speed 
of our current web server that is maybe 3 years old, 4GB ram, and currently 
under live load. This is very frustrating. In viewing Windows Task Manager 
during report creation on our older live server I see that the processor usage 
can get upto 30-50% while creating a complex report. However on the new server 
the CPU usage never gets above 4% and it takes forever for the report to 
complete.

After reading more about the multi-server configuration option I un-installed 
CF and re-installed it with the multi-server configuration. I didn't receive 
the license message this time but the performance is no better so I believe it 
is still using just 1 core per processor.

Has anyone run into the problem before? Are there severe drawbacks I should be 
aware of about running ColdFusion, specifically report creation, on a 
multi-core processor? Does it sound like the licensing problem is to blame and 
once that is resolved all should be well? 

~|
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:299696
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

LDAP Query for group members

[Burns, John D]

I'm trying to find out if there's a simpler way to do this than what I'm
doing. Currently, I'm querying a group from LDAP and retrieving the
attribute called Member which gives me this ugly result set of one
record with all of these domain users' distinguished names instead of
just the AD username. I can parse this, but it's a mess because the
names look like this: CN=User.Name, OU=Users, OU=Location,
OU=Organization, DC=domain, DC=com, CN=User2.Name, OU=Users,.

The ldap code looks like this currently:



I'd like to find a way to query the names and have them return as a
result set with one row for each user. Obviously, the parsing of the
file would be difficult because of all the commas in a single record but
it's possible because of each record starting with CN. Anyone have a
better way of doing this? Is there some sort of LDAP function you can
pass to get it to return just the username instead of the full DN?
Eventually, I'm assuming I'll hit the same roadblock on querying a
user's groups to see if they're in a specific group. Any information to
make my life easier would be greatly appreciated. Thanks!

John Burns


~|
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:299695
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC protect from SQL Injection?

[Claude Schneegans]

 >>but I don't think everyone will use that as a rationale to switch to text
based data storage

My intention was not to give the advice to switch to anything, just to 
mention
that if someone is using an Access database, may be mostly for simplicity,
he might not worry that much about SQL injection and use solutions 
simpler that CFQUERYPARAM.

-- 
___
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:299694
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Modding Galleon Forums

[Raymond Camden]

Warning - Advertisement:
Anthony, I encourage you to check out Galleon
(http://galleon.riaforge.org). Not only is it a nice ColdFusion-based
forums application, it also whitens your teeth and lowers your blood
pressure. Side effects include dizziness, nausea, and a slight
tingling feeling in your extremities.

On Fri, Feb 22, 2008 at 3:12 AM, Anthony Katgert
<[EMAIL PROTECTED]> wrote:
> Hello
>
>  I just viewed this thread and wonder if ther is a true alternative for my 
> Vbulletin board. I have owned license but am always looking for newer better 
> alternatives if there are any.
>
>  I am not a savvy CF programmer nor PHP I would need a solution that can 
> easily be modified to fit our needs (looks).
>
>

-- 
===
Raymond Camden, Camden Media

Email : [EMAIL PROTECTED]
Blog : www.coldfusionjedi.com
AOL IM : cfjedimaster

Keep up to date with the community: http://www.coldfusionbloggers.org

~|
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:299693
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: The unofficial ahphosting status thread

[Jim Davis]

> -Original Message-
> From: Anthony Katgert [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 9:22 AM
> To: CF-Talk
> Subject: Re: The unofficial ahphosting status thread
> 
> I do not follow you Tom.
> 
> What did you mean with that remark.
> "
> > Not a lot of help now, but next time you'll make sure systems send
> you
> >
> > nightlies, yes ? :-)

I'd assume "Nightly Backups".

For example I've got a Virtual PC Server running here at home with
duplicates (my "Disaster Recovery" servers) of my production ColdFusion and
database servers.  I use a SQL Server DTS (Data Transformation Services)
package scheduled to run every night at 3am which copies all data from the
production database to the DR database.

I don't actually do any backups for the CF server (since I only update it
from a development virtual server so it's always "backed up") but you could
easily script an FTP to copy any important files.  Of course there are easy
to use automated tools as well.

You can also, of course, run an actual backup program in "difference" mode
which saves to a remote location - the initial backup would take a while
(even over broadband) but the nightly differences should be small.

More sensitive data might require quicker backups (hourly or even "live")
but that of course consumes more resources as well.  Most databases have
methods for "subscribing" to data todo close-to-live backups (using log
shipping - which sends updates to one database's log files to another from
minute to minute is popular).

The bottom line is that you have your data (or at least the vast majority of
it) when things like this happen.

There are plenty of cheap or free options for all this stuff but it does
take some resources (time and sometimes equipment) but every pain will be
forgotten then first time that backup saves your hide.  ;^)

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:299692
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT: MS Source Fource Super Friends

[Chad Gray]

Come on Adobe, we need action figures too!  :)

http://msdn.microsoft.com/events/hero/




~|
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:299691
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: CFC protect from SQL Injection?

[Paul Vernon]

I know it's a bit late to join in on the conversation but, here goes...

Firstly, to answer the original question, my experience is that type
checking in functions kills a lot but not all injection attacks but
cfqueryparam catches the more intricate injection attacks where the input is
a string however I do believe that even cfqueryparam is not perfect.

Where possible, if you can use a RegEx to validate the string based input
data so that they fit the exact format you are wanting and couple it with
type checking and cfqueryparam, you *should* be impervious but YMMV. The key
here is look for good input rather than bad input. It's easier to define
what is acceptable than second guess someone that is determined and skilled
enough to invent an new form of injection just for you!

The real issues with SQL injection these days fall under the banner term of
"blind sql injection" (http://www.google.co.uk/search?q=blind+SQL+injection)
and are particularly fun to play with.

IMO, with automated tools like SQLiX being freely available that scan for
easy SQL injection targets, it doesn't make sense to do anything but secure
your code to the best of your ability with a good knowledge of your chosen
language and make best use of the features it provides.

Other things to do if you can is to check your logs. I see multiple SQL
injection attempts every day on our servers. The clever ones try to cloak
themselves to... e.g. including sp_password in a query instantly tells SQL
Server not to log this query for security reasons. If that injection attempt
is done via a post mechanism, it won't show up in the web server logs
either... Fun!

Here are a few links to the highlights of what Google turned up when looking
into SQL Injection attacks and prevention thereof.

http://www.nextgenss.com/papers/advanced_sql_injection.pdf

http://www.nextgenss.com/papers/more_advanced_sql_injection.pdf

http://www.webappsec.org/projects/articles/091007.shtml

http://www.imperva.com/resources/adc/blind_sql_server_injection.html

There are some other good articles on the rest of imperva's site but
registration is required for most.
http://www.imperva.com/resources/whitepapers.html

Some SQL injection examples can be found here:

http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/

Other slightly "dark-side" of the net links include:

http://sla.ckers.org/forum/list.php?16

http://ha.ckers.org/

Amongst other things, this article documents detecting stored procedures and
possible injections that will work in some cases. I don't see why some of
these may work with CFQueryparam too...

http://www.blackhat.com/presentations/bh-usa-04/bh-us-04-hotchkies/bh-us-04-
hotchkies.pdf

For those that are interested, I also found a nice XSS cheat sheet.

http://ha.ckers.org/xss.html

Paul





~|
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:299690
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC protect from SQL Injection?

[Tom Chiverton]

On Friday 22 Feb 2008, Peterson, Chris wrote:
> Yea, using text files for data wouldn't be as exploitable either, but I
> don't think everyone will use that as a rationale to switch to text
> based data storage =)

I'm going back to pencil and paper data storage :-)

-- 
Tom Chiverton
Helping to enormously monetize network deliverables
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299689
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: The unofficial ahphosting status thread

[Tom Chiverton]

If the only backup you have is at the hosting centre, you are a bit stuck - 
it's not much work to have the system send you a dump every night.


-- 
Tom Chiverton
Helping to collaboratively improve prospective mindshares
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299688
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Anthony Katgert]

I do not follow you Tom.

What did you mean with that remark.
" 
> Not a lot of help now, but next time you'll make sure systems send you 
> 
> nightlies, yes ? :-)
> 
> -- 
> Tom Chiverton
> Helping to assertively revolutionize B2B bandwidth
> on: http://thefalken.livejournal.com
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in 
> England and Wales under registered number OC307980 whose registered 
> office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, 
> Manchester, M3 3EB.  A list of members is available for inspection at 
> the registered office. Any reference to a partner in relation to 
> Halliwells LLP means a member of Halliwells LLP.  Regulated by The 
> Solicitors Regulation Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above 
> and may be confidential or legally privileged.  If you are not the 
> addressee you must not read it and must not use any information 
> contained in nor copy it nor inform any person other than Halliwells 
> LLP or the addressee of its existence or contents.  If you have 
> received this email in error please delete it and notify Halliwells 
> LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.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:299687
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: CFC protect from SQL Injection?

[Tom Chiverton]

On Friday 22 Feb 2008, Russ wrote:
> > > insert with 1000 records.  The cfqueryparam method is going to be a LOT
> > > slower.
> > It shouldn't be.
> It is, I've tested it.  There is a lot of overhead in passing that many
> parameters.

I would have though they'd be about the same if making 1000 different text 
strings, but obviously not.

> > cfqueryparam
> > > to avoid sql injection, but nobody has shown me an example of sql
> > But you don't get the cached execution plan benefits then.
> This is true.  Most of the time, it will perform slightly better.  My
> point, though, is that it's not necessary 100% of the time

I'd say it's always a good idea to use it by default.
If you end up bottle necking on a particular query, then yes, it helps to know 
taking the cfqp out may help, and how to sanitise the data by hand.

-- 
Tom Chiverton
Helping to conveniently maintain attention-grabbing relationships
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299685
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Peterson, Chris]

Yea, using text files for data wouldn't be as exploitable either, but I
don't think everyone will use that as a rationale to switch to text
based data storage =)

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 22, 2008 9:21 AM
To: CF-Talk
Subject: Re: CFC protect from SQL Injection?

 >>Everyone keeps talking about SQL injection this, and SQL injection 
that, but
I would like to see some examples.

Exact, and also all the examples I've ever seen suppose that an extra 
SQL statement is added after some ; character.
This won't work with an Acces database, so Access databases are not so 
evil ;-)

-- 
___
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:299686
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Tom Chiverton]

On Friday 22 Feb 2008, Russ wrote:
> How would you go about something like this?  Do you just pay for an extra
> host as a backup and not use it?  How do you synchronize your db, etc.

Depends on your risks, how much data you can afford to lose, etc. etc.

As a basic belt and braces for a low traffic site, emailing a DB dump off site 
may suffice, given you can probably set up new hosting* in less than a day if 
you don't have a load balanced or redundant site set up already.

-- 
Tom Chiverton
* Gandi of DNS fame now do on-demand hosting too



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299684
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC protect from SQL Injection?

[Claude Schneegans]

 >>Everyone keeps talking about SQL injection this, and SQL injection 
that, but
I would like to see some examples.

Exact, and also all the examples I've ever seen suppose that an extra 
SQL statement is added after some ; character.
This won't work with an Acces database, so Access databases are not so 
evil ;-)

-- 
___
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:299683
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: The unofficial ahphosting status thread

[Russ]

How would you go about something like this?  Do you just pay for an extra
host as a backup and not use it?  How do you synchronize your db, etc. 

Russ

> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 8:39 AM
> To: CF-Talk
> Subject: Re: The unofficial ahphosting status thread
> 
> On Friday 22 Feb 2008, Terry Schmitt wrote:
> > That's sorta lame. I think we're all capable of making the decision to
> stay
> > or go and not to mention which host we would choose.
> 
> Never mind that services that want any form of resilience will already be
> hosting with two different providers in two different countries.
> 
> --
> Tom Chiverton
> Helping to assertively expedite innovative e-business
> on: http://thefalken.livejournal.com
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> 3EB.  A list of members is available for inspection at the registered
> office. Any reference to a partner in relation to Halliwells LLP means a
> member of Halliwells LLP.  Regulated by The Solicitors Regulation
> Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged.  If you are not the addressee
> you must not read it and must not use any information contained in nor
> copy it nor inform any person other than Halliwells LLP or the addressee
> of its existence or contents.  If you have received this email in error
> please delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.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:299682
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Russ]

> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 8:37 AM
> To: CF-Talk
> Subject: Re: CFC protect from SQL Injection?
> 
> On Friday 22 Feb 2008, Russ wrote:
> > CFqueryparam is not always beneficial.  Lets say you are doing a batch
> > insert with 1000 records.  The cfqueryparam method is going to be a LOT
> > slower.
> 
> It shouldn't be.
> 

It is, I've tested it.  There is a lot of overhead in passing that many
parameters. 

> > Additionally, everyone keeps talking about how you should use
> cfqueryparam
> > to avoid sql injection, but nobody has shown me an example of sql
> injection
> > without cfqueryparam.  I think I can get the same results from val.
> 
> But you don't get the cached execution plan benefits then.

This is true.  Most of the time, it will perform slightly better.  My point,
though, is that it's not necessary 100% of the time, and you should know how
to construct a query without it that doesn't have sql injection
vulnerabilities.  

This is why I want to start the conversation and get some real world
examples of what not to do.  Unfortunately, nobody has been able to provide
any so far... 

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:299681
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Tom Chiverton]

On Friday 22 Feb 2008, Anthony Katgert wrote:
> Well I have not been able to login to Helm4 sofar and our FTP access is
> down as well. All I need is just a backup right now.

Not a lot of help now, but next time you'll make sure systems send you 
nightlies, yes ? :-)

-- 
Tom Chiverton
Helping to assertively revolutionize B2B bandwidth
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299680
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: The unofficial ahphosting status thread

[Anthony Katgert]

>Things are looking brighter this morning.
> - Control Panel works.
> - http works but all sites return 503 - Service Unavailable
> - No FTP
> - No email


Well I have not been able to login to Helm4 sofar and our FTP access is down as 
well. All I need is just a backup right now.



~|
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:299679
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Tom Chiverton]

On Friday 22 Feb 2008, Terry Schmitt wrote:
> That's sorta lame. I think we're all capable of making the decision to stay
> or go and not to mention which host we would choose. 

Never mind that services that want any form of resilience will already be 
hosting with two different providers in two different countries.

-- 
Tom Chiverton
Helping to assertively expedite innovative e-business
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299678
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: The unofficial ahphosting status thread

[Terry Schmitt]

Things are looking brighter this morning.
 - Control Panel works.
 - http works but all sites return 503 - Service Unavailable
 - No FTP
 - No email

> Since there are quite a few concerned ahphosting customers here, I 
> thought I'd start this thread instead of using the lengthy "Holy 
> Grail" thread.
> 
> My current status on a VPS is:
> http up about 80% since Sunday.
> email down 100%.
> RDC comes and goes. Currently down.
> FTP down 100%.
> 


~|
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:299677
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFC protect from SQL Injection?

[Tom Chiverton]

On Friday 22 Feb 2008, Russ wrote:
> CFqueryparam is not always beneficial.  Lets say you are doing a batch
> insert with 1000 records.  The cfqueryparam method is going to be a LOT
> slower.

It shouldn't be.

> Additionally, everyone keeps talking about how you should use cfqueryparam
> to avoid sql injection, but nobody has shown me an example of sql injection
> without cfqueryparam.  I think I can get the same results from val.

But you don't get the cached execution plan benefits then.

-- 
Tom Chiverton
Helping to quickly reintermediate performance-oriented applications
on: http://thefalken.livejournal.com



This email is sent for and on behalf of Halliwells LLP.

Halliwells LLP is a limited liability partnership registered in England and 
Wales under registered number OC307980 whose registered office address is at 
Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB.  A list 
of members is available for inspection at the registered office. Any reference 
to a partner in relation to Halliwells LLP means a member of Halliwells LLP.  
Regulated by The Solicitors Regulation Authority.

CONFIDENTIALITY

This email is intended only for the use of the addressee named above and may be 
confidential or legally privileged.  If you are not the addressee you must not 
read it and must not use any information contained in nor copy it nor inform 
any person other than Halliwells LLP or the addressee of its existence or 
contents.  If you have received this email in error please delete it and notify 
Halliwells LLP IT Department on 0870 365 2500.

For more information about Halliwells LLP visit www.halliwells.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:299676
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFC protect from SQL Injection?

[Russ]

CFqueryparam is not always beneficial.  Lets say you are doing a batch
insert with 1000 records.  The cfqueryparam method is going to be a LOT
slower. 

Additionally, everyone keeps talking about how you should use cfqueryparam
to avoid sql injection, but nobody has shown me an example of sql injection
without cfqueryparam.  I think I can get the same results from val.  

There are only two cases I can think of where sql injection is possible.  


Select * from users
Where userId=#url.userId#


This is solved easily by using val


Select * from users
Where userId=#val(url.userId)#


Or type checking



Select * from users
Where userId=#val(url.userId)#


Case 2:



Select * from users
Where username=#PreserveSingleQuotes(url.userName)#


Here of course, I had to go through the trouble of making the query not
secure.  

Everyone keeps talking about SQL injection this, and SQL injection that, but
I would like to see some examples.  I think CF is a very powerfull language
and cfquery takes care of sql injection attacks automatically most of the
time even without cfqueryparam.  

Russ

> -Original Message-
> From: Tom Chiverton [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 22, 2008 4:59 AM
> To: CF-Talk
> Subject: Re: CFC protect from SQL Injection?
> 
> On Thursday 21 Feb 2008, Russ wrote:
> > Unfortunately, there are certain queries you can't use it in, such as
> > cached queries (unless of course you have CF8).
> 
> Nothing stops you from doing the caching yourself in earlier ColdFusion
> versions.
> I would argue that the benefits of cfqueryparam outweigh the time it takes
> to
> do so.
> 
> --
> Tom Chiverton
> Helping to centrally transition out-of-the-box materials
> on: http://thefalken.livejournal.com
> 
> 
> 
> This email is sent for and on behalf of Halliwells LLP.
> 
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> 3EB.  A list of members is available for inspection at the registered
> office. Any reference to a partner in relation to Halliwells LLP means a
> member of Halliwells LLP.  Regulated by The Solicitors Regulation
> Authority.
> 
> CONFIDENTIALITY
> 
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged.  If you are not the addressee
> you must not read it and must not use any information contained in nor
> copy it nor inform any person other than Halliwells LLP or the addressee
> of its existence or contents.  If you have received this email in error
> please delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> 
> For more information about Halliwells LLP visit www.halliwells.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:299675
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 to populate a table from a query?

[Bobby Hartsfield]

Number 3 of that blog will result in invalid html ( with no s)
anytime that the last row has exactly 4 items in it. Try this... I Changed 4
to 2 of course.




#data#


 
 
  
 





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



-Original Message-
From: William Seiter [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 21, 2008 11:04 PM
To: CF-Talk
Subject: RE: How to populate a table from a query?

I blogged on it here:
http://wsoncf.blogspot.com/2008/02/tips-tricks-many-times-on-informational.h
tml

It looks like you want #3 and just change the 'mod' to 2.

William


-- 
William E. Seiter
 
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
 
Web Developer / ColdFusion Programmer
http://William.Seiter.com

-Original Message-
From: Colman, Richard [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 21, 2008 7:49 PM
To: CF-Talk
Subject: How to populate a table from a query?

I wish to dynamically populate table across columns and rows, like:

++-+
|#query.row1#| #query.row2#|
++-+
|#query.row3#|#query.row4# |
++-+
|#query.row5#| etc. etc.

where the number of rows returned by the query is uncertain, but I want a 2
col by X rows display of the results.

I am not sure how to do this. I think it might be something like

[do the query]

[stick the results into an ordered list so I can reference individual
members of the list]

[loop over the list]

[output the results like:

++-+
|#list1# | #list2# |
++-+
|#list3# | #list4# |
++-+
|#list5# | etc. etc.

but this seems needlessly complex. Why not just loop over the query, but I
am not sure how to spread the results across two columns as shown above. 

Is there a simpler way to approach it?

Rick Colman





~|
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:299674
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: The unofficial ahphosting status thread

[Terry Schmitt]

That's sorta lame. I think we're all capable of making the decision to stay or 
go and not to mention which host we would choose.
I'm sure that any host out there is happy to provide service. What makes you so 
special? (don't bother answering here)

>If any one who is a AHP Hosting customer that is facing these problems.
>Please feel free to email me off list. FusionLink is happy to help provide
>additional and /or new hosting services.
>
>John Mason
>[EMAIL PROTECTED]
>770.337.8363
> 
>www.FusionLink.com - ColdFusion and Flex hosting
>Now offering ColdFusion 8 Enterprise hosting
>FREE Subversion hosting
>
>I've been totally dead since 4:30pm EST.
>I just finished setting up new DNS servers and moved my email to a email
>hosting company... 5 days without email was my limit. 

~|
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:299673
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Get time zone for address?

[Andrew Powell]

As far as I know, there is a shapefile that defines timezones which  
will work with ESRI's ArcMAP.  So this, along with ArcGIS, lets you  
get the lat/lon from the address then get the tz from the shapefile.   
There is no guaranteed easy way (or cheap way) to do this.

ap


On Feb 22, 2008, at 12:33 AM, Mike Kear wrote:

> You bet time zones arent universal.
>
> The famous Indian Pacific train, which goes between Perth in Western
> Australia and the Australian east coast has its own time zone.
>
> There's even a group of tiny towns near the border of South Australia
> and Western Australia that have their own time zone, called Central WA
> time. It's set between Adelaide's Australian Central Time and Perth's
> Australian Western Time.
>
> Towns following this zone include Madura, Mundrabilla, Eucla and
> Border Village in South Australia. The total population of the area is
> estimated at 200 people.   They are all living a LONG way from anyone,
> and got hacked off with having to have their clocks set in Adelaide
> time, which didnt suit their situation are so far from Adelaide, yet
> at the same time even further from Perth - the Nullabor Plain is just
> hundreds of miles of nothing for as far as the eye can see.  Add to
> the fact that whether or not to have Daylight Savings was a debate
> that raged back and forth for years in WA, they just got jack of the
> whole thing and decided to go their own way.
>
> Then add in the to-ing and fro-ing over daylight savings and you'll
> have an almost impossible task to program it.   For example, only for
> the sake of the 200 Olympics and the desires of NBC to get better
> shots on the tv, the NSW government brought forward the change to
> summer time by a couple of months.   Other states have changed the
> date of switching for other reasons for longer or shorter periods.
>
> If you persist with trying to make sense of time zones and relative
> times, you'll hurt your brain.
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> Adobe Certified Advanced ColdFusion Developer
> AFP Webworks
> http://afpwebworks.com
> ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month
>
>
>
> On 2/22/08, Paul Hastings <[EMAIL PROTECTED]> wrote:
>> On Thu, 21 Feb 2008 16:03:52 -, "Adrian Lynch"  
>> <[EMAIL PROTECTED]> wrote:
>>> The address has a longitude of 28 so you know it's in time zone 3.
>>
>> tz rules aren't universal, they depend on countries (ie  
>> politicians), even states/regions within a country (even more  
>> politicians). a list of cities/locations w/tz IDs & a simple  
>> proximity search might be more accurate. if you're into GIS,  
>> here's a free global tz dataset:
>>
>
> 

~|
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:299672
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Check for cfwindow

[gayan balasooriya]

Thanks Azadi Saryev.
It worked well. 

~|
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:299671
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Check for cfwindow

[gayan balasooriya]

Thank you very much Azadi Saryev.
It worked really well. :) 

~|
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:299670
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4