RE: credit card fraud

[Debbie Morris]

And accessible. I'm in the processing of switching all of my forms on our site 
to use CFFormProtect. Captcha was in place when I took over a few years ago, so 
I never paid it much attention, until a few weeks ago when we got an email from 
a constituent that let us know he couldn't submit feedback on one of our 
projects because the letters and numbers on the form couldn't be detected by 
his screen reading software.

Debbie


-Original Message-
From: Sebastiaan Naafs - van Dijk [mailto:seb...@hotmail.com] 
Sent: Thursday, August 23, 2012 11:09 AM
To: cf-talk
Subject: Re: credit card fraud


There's of course always CFFormProtect
(http://cfformprotect.riaforge.com/) - has worked for me for years and years.
Great to stop bots, works 99,99% of the time. And it is unobtrusive for the end 
user.

Sebastiaan 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352286
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Query with no results is not defined

[Debbie Morris]

Did you apply the 9.0.1 update after upgrading? It sounds very similar to an 
issue that was fixed in that update.

Debbie

-Original Message-
From: Brian Cain [mailto:bcc9...@gmail.com] 
Sent: Wednesday, August 22, 2012 5:51 PM
To: cf-talk
Subject: Re: Query with no results is not defined


It is not in a CFC

 SELECT 
r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved,
Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) as AmountDue FROM 
Receipts r LEFT JOIN LineItems li ON li.ReceiptID = r.ID WHERE r.SubscriberID = 
#session.stUser.ID# AND r.Approved = 1 AND r.DatePaid is null AND 
IsNull(r.HideMyAccount, 0) <> 1 GROUP By r.ID, r.InvoiceDate, r.DueByDate, 
r.DatePaid, r.Approved HAVING Sum(li.Quantity*li.Cost) - 
Sum(li.Quantity*li.Discount) > 0 ORDER BY r.Approved DESC, r.InvoiceDate DESC 
IT ERRORS RIGHT HERE!


This is copied and pasted directly form the cfm page.  The condition to look 
and the record count attribute was literally the next line of code before I 
added the IsDefined check.

On Wed, Aug 22, 2012 at 4:46 PM, Cameron Childress wrote:

>
> On Wed, Aug 22, 2012 at 5:38 PM, Brian Cain  wrote:
>
> > Has anyone encountered this behavior, or have any idea why this is 
> > occurring?
>
>
> Is it in a CFC? Smells like an improperly scoped query. Show some code?
>
> -Cameron
>
> --
> Cameron Childress
> --
> p:   678.637.5072
> im: cameroncf
> facebook  | 
> twitter |
> google+ 
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352281
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration

[Debbie Morris]

Yes, it's Server 2008 R2.

I did modify the firewall settings the other day, so it's possible that might 
be why it's working now. I'm not necessarily sure that I made the *correct* 
changes though. Right now I have it turned off for the Domain and Private 
profiles and turned on for Public. Domain is the one I turned off the other day.

This server is inside the firewall, connected to our network, with CF using a 
domain account to logon. Is there a better way I should have these firewall 
profiles configured?



-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Friday, August 12, 2011 9:38 AM
To: cf-talk
Subject: Re: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration


are you running windows 2008 by any chance?
If so don;t forget that the firewall is enabled by default, this has caught
me out several times now as I am still maining maintaining windows 2003
servers, and has been the cause of things not working as services or
applications get blocked.

Russ

--

Russ Michaels

www.bluethunderinternet.com  : Business hosting services & solutions
www.cfmldeveloper.com: ColdFusion developer community
www.michaels.me.uk   : my blog
www.cfsearch.com : ColdFusion search engine
**
*skype me* : russmichaels


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346720
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration

[Debbie Morris]

I have separate application pools for each site/instance and they're all set up 
to use the same user account, so I would think either all would work or none. 
Regardless, when I decided to try tackling this again yesterday afternoon, I 
was able to access each of the sites from my PC, so at least that part is 
straightened out (I think).

Straightened out the last issue with the cfusion instance this morning, so I 
think I'm good to go now. Thanks for all the suggestions!!

Debbie


-Original Message-
From: Russ Michaels [mailto:r...@michaels.me.uk] 
Sent: Wednesday, August 10, 2011 7:57 PM
To: cf-talk
Subject: Re: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration


If it is an IIS problem then you need to make sure that the application pool
also has correct permissions, and that the user is a member of the IISURS or
IWAM group (I forget which)

On Wed, Aug 10, 2011 at 9:27 PM, Mark A. Kruger wrote:

>
> Debbie,
>
> I'll check but you may need your IIS services to run as the same user as
> well. Also, take a look at the *instance*-out.log for any issues when
> starting the instance
>
> -Mark
>
> -----Original Message-
> From: Debbie Morris [mailto:dmor...@sussexcountyde.gov]
> Sent: Wednesday, August 10, 2011 3:25 PM
> To: cf-talk
> Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance
> configuration
>
>
> I have all of my instances running as Windows services, so I changed it on
> all 4 of those (cfusion, intranet, intranetDev, and wwwDev). All 4 services
> are using the same domain account, which is also a member of the local
> administrators group. I just double-checked the security on the folders for
> each of the sites and the local administrators group has permissions for
> all
> those directories as well as the JRun4 directory.
>
>
> -Original Message-
> From: Mark A. Kruger [mailto:mkru...@cfwebtools.com]
> Sent: Wednesday, August 10, 2011 4:12 PM
> To: cf-talk
> Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance
> configuration
>
>
> Debbie,
>
> Which services did you change accounts on? If you changed CF services to
> run
> under an account then that user account will need permissions to various
> folders on the server (like the jrun4 folder for example).
>
> -Mark
>
>
> Mark A. Kruger, MCSE, CFG
> (402) 408-3733 ext 105
> www.cfwebtools.com
> www.coldfusionmuse.com
> www.necfug.com
>
>
> -Original Message-
> From: Debbie Morris [mailto:dmor...@sussexcountyde.gov]
> Sent: Wednesday, August 10, 2011 2:51 PM
> To: cf-talk
> Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance
> configuration
>
>
> To add a little more info, I'm able to access all three sites through the
> browser on the server console, so CF works fine locally for all three
> sites.
> It's just when I try to access the sites on ports 81 and 82 from the
> network
> that I get the error. Does that mean it's an IIS or IP configuration issue?
>
> Thanks,
> Debbie
>
> -Original Message-
> From: Debbie Morris [mailto:dmor...@sussexcountyde.gov]
> Sent: Wednesday, August 10, 2011 3:14 PM
> To: cf-talk
> Subject: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance
> configuration
>
>
> I've got a server (west-intranet, 10.2.1.46) running CF 9.01 on Windows
> Server 2008 R2 with IIS 7. I previously had multiple instances running, but
> I had to change my service properties to a user account so that I could
> access network printers, and now everything has gone to heck in a
> handbasket.
>
> At this point, the only site that I'm able to access is the Intranet site
> running on port 80. When trying to access the sites on other ports, I get a
> connection timeout error.  I've even managed to muck it up enough so that I
> can't even get into the cfusion server to look at the instances defined.
> Any
> suggestions on what I can look at to straighten this out?
>
> IIS:
> Intranet - port 80
> intranetDev-port 81
> wwwDev-port 82
>
> wsconfig:
> [ localhost:intranet ] Internet Information Server (IIS) : intranet
> [ localhost:intranetDev ] Internet Information Server (IIS) : intranetDev
> [ localhost:wwwDev ] Internet Information Server (IIS) : wwwDev
>
>
>
>
>
>
>
>
>
>
>
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346717
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration

[Debbie Morris]

I have all of my instances running as Windows services, so I changed it on all 
4 of those (cfusion, intranet, intranetDev, and wwwDev). All 4 services are 
using the same domain account, which is also a member of the local 
administrators group. I just double-checked the security on the folders for 
each of the sites and the local administrators group has permissions for all 
those directories as well as the JRun4 directory.


-Original Message-
From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] 
Sent: Wednesday, August 10, 2011 4:12 PM
To: cf-talk
Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration


Debbie,

Which services did you change accounts on? If you changed CF services to run
under an account then that user account will need permissions to various
folders on the server (like the jrun4 folder for example).  

-Mark


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


-Original Message-
From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] 
Sent: Wednesday, August 10, 2011 2:51 PM
To: cf-talk
Subject: RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance
configuration


To add a little more info, I'm able to access all three sites through the
browser on the server console, so CF works fine locally for all three sites.
It's just when I try to access the sites on ports 81 and 82 from the network
that I get the error. Does that mean it's an IIS or IP configuration issue?

Thanks,
Debbie

-Original Message-----
From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] 
Sent: Wednesday, August 10, 2011 3:14 PM
To: cf-talk
Subject: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration


I've got a server (west-intranet, 10.2.1.46) running CF 9.01 on Windows
Server 2008 R2 with IIS 7. I previously had multiple instances running, but
I had to change my service properties to a user account so that I could
access network printers, and now everything has gone to heck in a
handbasket.

At this point, the only site that I'm able to access is the Intranet site
running on port 80. When trying to access the sites on other ports, I get a
connection timeout error.  I've even managed to muck it up enough so that I
can't even get into the cfusion server to look at the instances defined. Any
suggestions on what I can look at to straighten this out?

IIS:
Intranet - port 80
intranetDev-port 81
wwwDev-port 82

wsconfig:
[ localhost:intranet ] Internet Information Server (IIS) : intranet
[ localhost:intranetDev ] Internet Information Server (IIS) : intranetDev
[ localhost:wwwDev ] Internet Information Server (IIS) : wwwDev










~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346657
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration

[Debbie Morris]

To add a little more info, I'm able to access all three sites through the 
browser on the server console, so CF works fine locally for all three sites. 
It's just when I try to access the sites on ports 81 and 82 from the network 
that I get the error. Does that mean it's an IIS or IP configuration issue?

Thanks,
Debbie

-Original Message-----
From: Debbie Morris [mailto:dmor...@sussexcountyde.gov] 
Sent: Wednesday, August 10, 2011 3:14 PM
To: cf-talk
Subject: CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration


I've got a server (west-intranet, 10.2.1.46) running CF 9.01 on Windows Server 
2008 R2 with IIS 7. I previously had multiple instances running, but I had to 
change my service properties to a user account so that I could access network 
printers, and now everything has gone to heck in a handbasket.

At this point, the only site that I'm able to access is the Intranet site 
running on port 80. When trying to access the sites on other ports, I get a 
connection timeout error.  I've even managed to muck it up enough so that I 
can't even get into the cfusion server to look at the instances defined. Any 
suggestions on what I can look at to straighten this out?

IIS:
Intranet - port 80
intranetDev-port 81
wwwDev-port 82

wsconfig:
[ localhost:intranet ] Internet Information Server (IIS) : intranet
[ localhost:intranetDev ] Internet Information Server (IIS) : intranetDev
[ localhost:wwwDev ] Internet Information Server (IIS) : wwwDev






~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346655
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

CF9.01 / Windows Server 2008 R2 / IIS7 multi-instance configuration

[Debbie Morris]

I've got a server (west-intranet, 10.2.1.46) running CF 9.01 on Windows Server 
2008 R2 with IIS 7. I previously had multiple instances running, but I had to 
change my service properties to a user account so that I could access network 
printers, and now everything has gone to heck in a handbasket.

At this point, the only site that I'm able to access is the Intranet site 
running on port 80. When trying to access the sites on other ports, I get a 
connection timeout error.  I've even managed to muck it up enough so that I 
can't even get into the cfusion server to look at the instances defined. Any 
suggestions on what I can look at to straighten this out?

IIS:
Intranet - port 80
intranetDev-port 81
wwwDev-port 82

wsconfig:
[ localhost:intranet ] Internet Information Server (IIS) : intranet
[ localhost:intranetDev ] Internet Information Server (IIS) : intranetDev
[ localhost:wwwDev ] Internet Information Server (IIS) : wwwDev




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346653
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: SQL query question

[Debbie Morris]

I'm 100% with you guys on this as well. Replacing the hundreds of "select *" 
from all the existing code here is one of my seemingly never ending tasks. I 
should have addressed that first before attempting to add anything else to the 
mix.

I'm done installing my Windows updates for the evening, so I'll tackle this 
again in the morning. Thanks for the help!

Debbie

-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz] 
Sent: Tuesday, February 01, 2011 5:41 PM
To: cf-talk
Subject: Re: SQL query question


>
> The evil of using * in SELECT clauses.
>

I'm with Ian on this 100%. Often times developers think that using * will be
faster, and easier and allow more flexibility. However that couldn't be
further from the truth as you are seeing now. Take Ian's advice and define
each column you want from your query. The added bonus is that there's no
extra overhead associated with returning columns you aren't using.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341807
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

SQL query question

[Debbie Morris]

Since everyone should be in a SQL Join state of mind...here's another one.

I have a weird issue that I haven't been able to narrow down yet. I'm trying to 
add a new field to one of my tables to store some additional information, but 
once I add the column, my previously working query breaks.

Here's the query (obviously the person that originally wrote it is in the 'the 
fewer characters, the better' camp):

SELECT p.*, pt.*, pm.Type AS mtype, s.fname AS sfname, s.lname AS slname, 
pa.DateActive AS PenAmountDate, pa.MonthlyAmount AS PenAmt, pa.Note AS 
PenAmtNote, s.SSN AS sssn, s.DOB AS sdob, spm.Type AS smt

FROM   PensionerMedicalType spm
INNER JOIN PensionerSpouse s ON spm.MedicalID = s.MedicalType 
RIGHT OUTER JOIN PensionersActive p 
INNER JOIN PensionerType pt ON p.PensionerType = pt.PensionerTID 
LEFT OUTER JOIN PensionAmounts pa ON p.PenActID = pa.PenID 
LEFT OUTER JOIN PensionerMedicalType pm ON p.MedicalType = pm.MedicalID ON 
s.SpouseID = p.Spouse
WHERE  (p.PenActID =  AND 
pa.active = 1)  


As soon as I add a column named 'lifeInsType' to the PensionersActive (p) 
table, I get the following error when the same query runs:

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type.

What am I overlooking? 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341801
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: why is cf_builder so expensive?

[Debbie Morris]

Agreed. Pretty much everything else is included in the Master Collection (I 
wasn't even aware I had Flash Builder after my CS5 upgrade!), so why not 
CFBuilder as well?

Deb

>It would be nice if CFBuilder came bundled with Creative Suite as homesite
>was.
>It is a good product, but I don't do enough dev work these days to warrant
>spending $300, DW does the job for me. 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341351
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Leading space added with CF9.0.1

[Debbie Morris]

Thanks for all the help, Matt!

I'll have to take a look around to see where all of these functions are being 
used. Quite a few of them seem to be set to "remote"...


-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Monday, December 20, 2010 2:34 PM
To: cf-talk
Subject: Re: Leading space added with CF9.0.1


Oh, as an aside, I noticed that you have access="remote" set on your
MapFormat function.  Unless you are directly exposing that CFC and method to
a web service or are hitting it directly via URL (e.g.
http://yoursite.com/your.cfc?method=MapFormat), you will want to set that to
"public" instead.




~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340175
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Leading space added with CF9.0.1

[Debbie Morris]

That actually does take care of the space issue. Thanks!

So what exactly does that attribute do? I read the docs but I'm still not clear.

I checked the other pages that use the MapFormat function and they all still 
seem to function correctly, so it seems I should be safe leaving it set to 
false?


-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com] 
Sent: Monday, December 20, 2010 1:52 PM
To: cf-talk
Subject: Re: Leading space added with CF9.0.1


Since you say the extra whitespace disappears if you assign a variable
first, I don't think this is the solution to your problem, but for kicks and
grins, try setting output="false" on your MapFormat .


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340169
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Leading space added with CF9.0.1

[Debbie Morris]

I'm in the process of building a new CF9.0.1 server to replace our existing 
7.0.2 production server. I'm confused about the behavior I'm seeing when 
testing one section of the site.

There is a link that is generated to point to a PDF of a map. On the new 
server, the link is incorrectly generated with a space preceding the map number 
(11.00).
/dept/assessment/mapping/pdfs/330/Map_330- 11.00.pdf

Original code to generate the link:

…
Map of Property

The mapFormat code from propInfo.cfc:

   

   

   

   



If I output the session.map value prior to the link, it shows "1100", which is 
correct. If I check the length of the variable, it says there are 4 characters.

If I change the code to apply the MapFormat function to the string prior to 
including it in the link, it works fine (no leading space in front of 11.00):

Map of Property

I'm sure I'm overlooking something silly, but after looking at this for so 
long, I'm still clueless. Why would the code work correctly on 7.0.2 but not 
9.0.1? The code is exactly the same (FTP’d from production to test server). 
The only thing that should be different (and potentially the problem) would be 
a more recent version of the JTOpen driver I have on the new server. 

FWIW, the MapFormat function is used in several other places within this 
section of the site, but none of them have this issue.

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340154
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: Getting AD logged in user

[Debbie Morris]

I had to make the changes in this article in order to have auto login work in 
Firefox:
http://sivel.net/2007/05/firefox-ntlm-sso/

Deb

-Original Message-
From: Mahcsig [mailto:mahc...@mahcsig.com] 
Sent: Monday, November 15, 2010 9:15 AM
To: cf-talk
Subject: Re: Getting AD logged in user


I have the same thing going on my intranet, I have the login file
authentication set like this:

anonymous - off
integrated windows auth - on
digest - off
basic - on
.net - off
domain - local domain name
realm - can be any text

with this setup IE and Chrome auto login, Firefox still always asks though.

~Mahcsig



On Sat, Nov 13, 2010 at 2:37 AM, Robert Filipovich wrote:

>
> So what I want to do is see the logged in AD username from an intranet user
> hitting my page, so that I can make queries based on that information
> without them having to log in again.  I have done several things that I
> thought should work.  I have Annonymous off and windows auth turned on in
> IIS.  I have set NTFS permissions on the directory.  The Intranet user is
> allowed to the site and non are not, but the AUTH_USER is never populated
> unless I force them to log in with browser prompt.  I know there are ways to
> do it as we have a 3rd party CFML app in our environment that recognizes you
> and passes you through.  Any ideas on the process to take to do this.  I
> have tried also redirets to other pages to see if it populates it then.
>
> Thanks in advance,
> /Robert
>
> 



~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339232
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: RegEx help

[Debbie Morris]

Thank you (and everyone else)!! This one did the trick!

Now I just need to finish the logic around it so that it doesn't break when 
there aren't any comments that match, and I can get this off my plate before I 
leave for vacation!

Thanks again!

Deb

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: Tuesday, June 08, 2010 11:40 AM
To: cf-talk
Subject: RE: RegEx help


Debbie,

Where 'testString' is your content, try this:



#mid(testString, test.pos[2], test.len[2])#

----

From: "Debbie Morris" 
Sent: Tuesday, June 08, 2010 10:24 AM
To: "cf-talk" 
Subject: RE: RegEx help

Thanks for the help, Jason and Andy. Turns out the character apparently 
isn't a tab though. Viewing it in WireShark, it looks like there is a 
carriage return (0d), a line feed (0a) and a space (20) between the age and 
gender strings.

Sorry to be so dumb, but I've managed to avoid regular expressions for the 
most part, so I'm really clueless now that I need it. I've tried reading 
through the documentation but it all seems like Greek to me. How can I test 
for the combination of those three characters?

Deb

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: Monday, June 07, 2010 4:27 PM
To: cf-talk
Subject: RE: RegEx help

Assuming that those are tabs between the elements, the following will 
expand on Andy's suggestion.



#mid(testString, test.pos[2], test.len[2])#



From: "Andy Matthews" 
Sent: Monday, June 07, 2010 3:32 PM
To: "cf-talk" 
Subject: RE: RegEx help

If you can always depend on Age: before the desired string, and what looks
like a tab afterwards, then it's trivial:

Age:[0-9a-Z]+\t

That assumes that the age will be any combination of letters and numbers,
and also allows for upper and lower case.

andy

-Original Message-
From: Debbie Morris [mailto:ddicker...@macromedia.com] 
Sent: Monday, June 07, 2010 1:51 PM
To: cf-talk
Subject: RegEx help

I need to extract a particular piece of data from one of my query fields 
and
I'm not sure how to go about it.

We have incidents in one table that can have comments in another table
associated with them.

Here's an example of one of the comments in my query results that I need 
to
grab data from:

Case Information   Problem:diff breathing   Patients:1   Four commandment
Information   Age:2 months   Gender:Female   Conscious:Yes   Brea

I need to get the Age information for any comments that contain it. The 
Age
field always begins as shown above and the Gender field always immediately
follows it, so I'm assuming I can work from that, but I just don't know 
how
to go about writing it. Any thoughts would be greatly appreciated!!

Deb 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334369
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: RegEx help

[Debbie Morris]

Thanks for the help, Jason and Andy. Turns out the character apparently isn't a 
tab though. Viewing it in WireShark, it looks like there is a carriage return 
(0d), a line feed (0a) and a space (20) between the age and gender strings.

Sorry to be so dumb, but I've managed to avoid regular expressions for the most 
part, so I'm really clueless now that I need it. I've tried reading through the 
documentation but it all seems like Greek to me. How can I test for the 
combination of those three characters?

Deb

-Original Message-
From: Jason Fisher [mailto:ja...@wanax.com] 
Sent: Monday, June 07, 2010 4:27 PM
To: cf-talk
Subject: RE: RegEx help


Assuming that those are tabs between the elements, the following will 
expand on Andy's suggestion.



#mid(testString, test.pos[2], test.len[2])#



From: "Andy Matthews" 
Sent: Monday, June 07, 2010 3:32 PM
To: "cf-talk" 
Subject: RE: RegEx help

If you can always depend on Age: before the desired string, and what looks
like a tab afterwards, then it's trivial:

Age:[0-9a-Z]+\t

That assumes that the age will be any combination of letters and numbers,
and also allows for upper and lower case.

andy

-Original Message-
From: Debbie Morris [mailto:ddicker...@macromedia.com] 
Sent: Monday, June 07, 2010 1:51 PM
To: cf-talk
Subject: RegEx help

I need to extract a particular piece of data from one of my query fields 
and
I'm not sure how to go about it.

We have incidents in one table that can have comments in another table
associated with them.

Here's an example of one of the comments in my query results that I need 
to
grab data from:

Case Information   Problem:diff breathing   Patients:1   Four commandment
Information   Age:2 months   Gender:Female   Conscious:Yes   Brea

I need to get the Age information for any comments that contain it. The 
Age
field always begins as shown above and the Gender field always immediately
follows it, so I'm assuming I can work from that, but I just don't know 
how
to go about writing it. Any thoughts would be greatly appreciated!!

Deb 





~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334360
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RegEx help

[Debbie Morris]

I need to extract a particular piece of data from one of my query fields and 
I'm not sure how to go about it.

We have incidents in one table that can have comments in another table 
associated with them.

Here's an example of one of the comments in my query results that I need to 
grab data from:

Case Information   Problem:diff breathing   Patients:1   Four commandment 
Information   Age:2 months   Gender:Female   Conscious:Yes   Brea

I need to get the Age information for any comments that contain it. The Age 
field always begins as shown above and the Gender field always immediately 
follows it, so I'm assuming I can work from that, but I just don't know how to 
go about writing it. Any thoughts would be greatly appreciated!!

Deb 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334344
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

RE: CF 9 Install/Migration Hangs

[Debbie Morris]

Check your adminconfig.xml file. There are several setup/migration settings in 
there.

Debbie Morris

-Original Message-
From: Phillip Duba [mailto:phild...@gmail.com]
Sent: Thursday, January 14, 2010 11:51 AM
To: cf-talk
Subject: CF 9 Install/Migration Hangs


I installed CF 9 as the Developer edition on my laptop yesterday and every
time I go to the administrator URL, it attempts to complete the
installation/migration/configuration and I get a "The request has exceeded
the allowable time limit Tag: cfoutput". I thought there was a way to
disable the migration in on of the .xml files, but I don't recall where
that's at or if that was even an option. Anyone else experience this and/or
know where that flag is? Thanks,

Phil




~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329684
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4