Re: imap.cfc
Or you could upgrade to CF9 for the new CFIMAP tag. ;-) -Adam On Fri, Jan 29, 2010 at 2:36 AM, Richard Meredith-Hardy r...@flymicro.comwrote: OK, thanks, I'll take a look. -Original Message- From: denstar [mailto:valliants...@gmail.com] Sent: 27 January 2010 19:56 To: cf-talk Subject: Re: imap.cfc On Wed, Jan 27, 2010 at 7:06 AM, Richard Meredith-Hardy wrote: Before I start messing with it, can someone tell me if the imap.cfc at http://www.opensourcecf.com/CFOpenMail/imapcfc_view.cfm is the latest version and works OK on CF8? That one really needs work to be functional. There's something similar that Rick and I have done some work on, that has unit tests that work with GMail (getting folders, sending mail using TLS, etc.). If it does not work with CF8, making it work should be a pretty simple matter of making sure that var scoped variables are at the top, and using structNew() vs. any cf9 structure creation syntax, etc .. If I can find my cf8 libs, I can give it a whirl, as there's some other stuff I want to test too, but if you get it to work before then, send me the changes and I'll commit them. As for the number of folders, I think the only limit is at the SMTP server. With the cfjavamail source, it should be pretty easy to add caching and whatnot for folder lookups and what have you. http://trac.getrailo.org/railotags/wiki/CfJavaMail :den -- We are celebrating the feast of the Eternal Birth which God the Father has borne and never ceases to bear in all eternity... But if it takes not place in me, what avails it? Everything lies in this, that it should take place in me. Meister Eckhar ~| 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:330252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfmail with gmail - second question
According to http://mail.google.com/support/bin/answer.py?hl=enanswer=13287 http://mail.google.com/support/bin/answer.py?hl=enanswer=13287 gmail requires either SSL or TLS to send email from a client I tried your code, but added the following and it worked: port=465 useSSL=true I haven't tried it, but if you want to use TLS instead of SSL, you can do port=587 useTLS=true TechInfo wrote: Did you try putting ALL the attributes into the attributeCollection? Even the port and useSSL ?? I just read that it is an all or nothing collection. Jevo Matthew Smith wrote: I posted earlier about using cfmail with google hosted mail. I was told it would require cf8. We ended up upgrading the account to cf8, but I still can't get it to work. Here is what I have. The page runs without error, I just don't ever receive the test mail: cfset mailAttributes = { server=smtp.gmail.com, username=webs...@website.com, password=password, from=webs...@website.com, to=rece...@gmail.com, subject=Eat my shorts } / cfmail port=465 useSSL=true attributeCollection=#mailAttributes# port 465, SSL enabled/cfmail cfmail port=587 useTLS=true attributeCollection=#mailAttributes# port 587, TLS enabled/cfmail cfmail port=465 useSSL=true useTLS=true attributeCollection=#mailAttributes# port 465, SSL and TLS enabled/cfmail ~| 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:330253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF9 cfquery not giving same insert results as CF7
Use SCOPE_IDENTITY(). @@Identity returns the id for the last record inserted. If an another insert into that table occurs between your insert and the select @@identity (2 different people making inserts into the db for example) you will get the id for the other record that was inserted. Scope identity only pulls the last record for the current scope. Sort of like putting something in a transaction. It all sticks together. (however putting a query in a transaction with @@identity will not solve the problem above). As for the SET NOCOUNT ON and SET NOCOUNT OFF, they have no effect on these. The only thing that does is prevent extra network traffic by stopping the extra reporting of how many rows were affected for each piece of the query. Of course I'm assuming that this is MSSQL. Steve -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Thursday, January 28, 2010 9:10 PM To: cf-talk Subject: Re: CF9 cfquery not giving same insert results as CF7 I've found a query that used Select @@Identity as NewAgentID without having a Set NoCount on or off. This query still worked and did not have to be altered at all. That brings up the question if NoCount is needed and if it is needed, do both the @@identity and the SCOPE_IDENTITY() methods need it? What is the difference between the two methods? Select NewAgentID = SCOPE_IDENTITY() Select @@Identity as NewAgentID Thanks -- Michael Dinowitz On Wed, Jan 27, 2010 at 8:19 PM, Brook Davies cft...@logiforms.com wrote: I am curious, does the query use the NOCOUNT and @@identity SQL commands?? cfquery name=addAgent SET NOCOUNT ON insert into users_printprofiles ( ) values( ) select newid=@@identity SET NOCOUNT OFF /cfquery Brook -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: January-27-10 1:26 PM To: cf-talk Subject: Re: CF9 cfquery not giving same insert results as CF7 OK, so it turns out that this is a known issue that came into effect between CF 7 and CF 8. I can do one of three things here. 1. replace the name attribute with the result attribute: cfquery name=AddAgent becomes cfquery result=AddAgent 2. add a result attribute of the same name to the cfquery cfquery name=AddAgent becomes cfquery name=AddAgent result=AddAgent 3. use a 'generic' result value to the cfquery cfquery name=AddAgent becomes cfquery name=AddAgent result=QueryResult The problem that I see is that I don't know everywhere that the query results will be used. Is anything returned to the 'name' variable of the query? If not, then will removing it cause some other unforeseen effect? (experiments so far say no) Will the use of both a name and a result conflict? (experiments so far say no) How will all this interact with Fusebox? Is the results of a query in an act_ page supposed to be 'exposed' to the dsp_ page? If anyone has a clue or two on which way I should go on this, please let me know. I've got to fix this in almost 700 places (the client site is a royal mess of backed up and copied code) and a single, standard approach is what I need. Luckily, the RegEx to find all of the locations took 60 seconds to write. Literally. The hard is fast, the easy is slow. How standard for me. :) -- Michael I just ran into this and while it's new to me, I'm sure it's old news to others here. I'm looking at someones code from CF 7 where they have a cfquery inserting a record. The cfquery tag only has a name and a datasource. Immediately after the tag, there is a cfset that makes use of the query's name and the name of the identity field of the table that the data was inserted into. cfquery name=testquery datasource=test insert ... /cfquery cfset newid = testquery.identityfield In CF 7, the newid would be the id of the newly inserted record. In CF 9 all I get is an error. If I use a result attribute rather than a name attribute, I get a structure with the identity result buried in it. So here's the question. If it worked in 7 and not in 9, is there a simple fix to make it work like it did in 7 again? I'd rather not have to recode a whole slew of insert statements. Thanks -- Michael ~| 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:330254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF9 cfquery not giving same insert results as CF7
Thanks. This gives me a bit of extra information on top of the research I've done on the topic. Now comes a few extended questions. :) 1. When a cfquery has a result attribute defined, it will return data about the query and in the case of an insert, the id of the inserted item. The assumption is that under the hood CF is using scope_identity() (for MSSQL). Do you have any idea if this is the case? Just trivia and something I should test anyway. 2. From what you say of NoCount, I assume that there would be a minor performance benefit for sql insert, update, and delete operations to use it, correct? Thanks -- Michael Dinowitz On Fri, Jan 29, 2010 at 9:24 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Use SCOPE_IDENTITY(). @@Identity returns the id for the last record inserted. If an another insert into that table occurs between your insert and the select @@identity (2 different people making inserts into the db for example) you will get the id for the other record that was inserted. Scope identity only pulls the last record for the current scope. Sort of like putting something in a transaction. It all sticks together. (however putting a query in a transaction with @@identity will not solve the problem above). As for the SET NOCOUNT ON and SET NOCOUNT OFF, they have no effect on these. The only thing that does is prevent extra network traffic by stopping the extra reporting of how many rows were affected for each piece of the query. Of course I'm assuming that this is MSSQL. Ste ~| 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:330255 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF9 cfquery not giving same insert results as CF7
I don't know what CF9 is doing under the hood. What I do is put all the queries in stored procedures. At the beginning of the procedure I always put SET NOCOUNT ON and I always end with SET NOCOUNT OFF. If you have a procedure that is doing a lot of stuff it can reduce a lot of back and forth and network traffic. I had one procedure that did a lot of data pulls and combining of data, without using the nocount, the amount of messages about xx rows affected was way larger than the actual data that was returned. Sometimes it's the other way around. When I'm testing something I leave them off so I can see what is happening. Think of it sort of like turning off debug in production for cf. It's not really critical data, but if you don't do it you get a lot of overhead. Steve -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Friday, January 29, 2010 9:37 AM To: cf-talk Subject: Re: CF9 cfquery not giving same insert results as CF7 Thanks. This gives me a bit of extra information on top of the research I've done on the topic. Now comes a few extended questions. :) 1. When a cfquery has a result attribute defined, it will return data about the query and in the case of an insert, the id of the inserted item. The assumption is that under the hood CF is using scope_identity() (for MSSQL). Do you have any idea if this is the case? Just trivia and something I should test anyway. 2. From what you say of NoCount, I assume that there would be a minor performance benefit for sql insert, update, and delete operations to use it, correct? Thanks -- Michael Dinowitz ~| 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:330256 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfscript's cfabort
I have some CFScript running and each time I set a variable I run a function to check if there is an error. If there is an error I would like to CFAbort the scripting so it does not continue. Can you abort the rest of the script if the error function is called? I tried break; in the function, but that does not seem to work. Kinda like this: cfscript TK = createObject(COM,APToolkit.Object,expandPath('APToolkitNET.dll')); varReturn = TK.stitchPDF(expandPath(pdf),1,0,0,546,546,0); if (varReturn 1) { error(stichPDF); } TK.CloseOutputFile(); ReleaseComObject(TK); function error(method) { errMsg = #method# failed with a #varReturn#; ReleaseComObject(TK); ??CFAbort?? } /cfscript cfoutput#errMsg#/cfoutpu ~| 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:330257 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfscript's cfabort
CF9? If so, use abort; On Fri, Jan 29, 2010 at 9:07 AM, Chad Gray cg...@careyweb.com wrote: I have some CFScript running and each time I set a variable I run a function to check if there is an error. If there is an error I would like to CFAbort the scripting so it does not continue. Can you abort the rest of the script if the error function is called? I tried break; in the function, but that does not seem to work. Kinda like this ~| 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:330258 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF9 cfquery not giving same insert results as CF7
As for the SET NOCOUNT ON and SET NOCOUNT OFF, they have no effect on these. The only thing that does is prevent extra network traffic by stopping the extra reporting of how many rows were affected for each piece of the query. In CF8 it did have an effect on cfquery's in some situations. Specifically the simple INSERT followed by SELECT scope_identity() scenario. I do not about CF9. Though I will say the results in CF8 varied greatly depending on a number of conditions (statement used, driver version, etcetera). A lot of the issues were related to how the generated keys feature was implemented. http://www.mischefamily.com/nathan/index.cfm/2008/1/28/Problems-with-CF-8s-Generated-Keys-Feature ~| 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:330259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript's cfabort
Nope CF8. I will put this on the list of reasons to upgrade though. -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Sent: Friday, January 29, 2010 10:30 AM To: cf-talk Subject: Re: cfscript's cfabort CF9? If so, use abort; ~| 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:330260 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfscript's cfabort
Nope CF8. I will put this on the list of reasons to upgrade though. You could wrap the the cfabort in a cffunction. Then call it from cfscript. I believe there is a udf at cflib.org that does that.. ~| 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:330261 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfscript's cfabort
Interesting idea... I could just take my function and put the entire thing in it. Then call it. I will try it out. Thanks Chad -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Friday, January 29, 2010 10:44 AM To: cf-talk Subject: RE: cfscript's cfabort Nope CF8. I will put this on the list of reasons to upgrade though. You could wrap the the cfabort in a cffunction. Then call it from cfscript. I believe there is a udf at cflib.org that does that.. ~| 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:330262 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Running CF as a specific user
I haven't seen this discussed in years, and the Adobe Knowledge Base article is more than three years old. So I'd like to see if someone has recent experience with setting a specific user account for CF, rather than running it as System. The server in question is Win Server 2008 running CF Standard. My specific question involves the fact that Adobe says that the CF User must have full control of the OS directories (windows and system32 in the KB article). My concern is that giving that user account full control of those directories is a little scary. Does anyone know if full control is really required? Or does anyone have any specific advice in this regard? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| 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:330263 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
createObject COM and ReleaseComObject
If anyone has been following my posts I am working with a COM object to create PDFs. I place images, text etc on the PDF at exact places (x/y coordinates) using ActivePDF. Now I am reading up on using COM objects and there is the releaseComObject function that I can call to dump the resources of the object. The documentation says I dont have to use it that the garbage collection will eventually clean things up. I want to break my code into a CFC with many functions. CreateBlankPDF, PlaceImage, PlaceText, SavePDF etc. All the time the COM object (probably saved as a session variable) will be activated and my CFC functions will have access to the COM objects methods (at least that is what I want to do, we will see if it works). If the COM object is not killed and I have two people working on the website will their PDFs collide? One user will get their peanut butter in the other users chocolate and one will get their chocolate in the other users peanut butter (reeses cup reference for those youngsters)? I will start breaking it up and try setting it as a session variable and see what happens, but if anyone has any clue let me know. If I cant get the COM object to store as a session or application variable I will probably end up storing the created PDF name as a session variable and each function will go open that PDF and add the image, text etc then save the PDF back down. Probably a safer way of doing things. Thanks, Chad ~| 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:330264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Running CF as a specific user
I haven't seen this discussed in years, and the Adobe Knowledge Base article is more than three years old. So I'd like to see if someone has recent experience with setting a specific user account for CF, rather than running it as System. The server in question is Win Server 2008 running CF Standard. My specific question involves the fact that Adobe says that the CF User must have full control of the OS directories (windows and system32 in the KB article). My concern is that giving that user account full control of those directories is a little scary. Does anyone know if full control is really required? Or does anyone have any specific advice in this regard? Full control of those directories is NOT required. In fact, you can run CF as a very limited user. It will need control over its own directories, and at least read/execute over your web content (more if you plan to use CFFILE, etc). Presumably, you'd need additional privileges if you use the CFREGISTRY tag, but otherwise CF is pretty well separated from Windows in general. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:330265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: createObject COM and ReleaseComObject
Now I am reading up on using COM objects and there is the releaseComObject function that I can call to dump the resources of the object. The documentation says I dont have to use it that the garbage collection will eventually clean things up. You probably will have to use that function, if you're using it from CF. Using COM can be problematic under the best conditions, and CF isn't the best conditions' for COM. If the COM object is not killed and I have two people working on the website will their PDFs collide? One user will get their peanut butter in the other users chocolate and one will get their chocolate in the other users peanut butter (reeses cup reference for those youngsters)? This depends on the threading model (if any) for the COM object, but in the absence of that information I would assume the worst. If I cant get the COM object to store as a session or application variable I will probably end up storing the created PDF name as a session variable and each function will go open that PDF and add the image, text etc then save the PDF back down. Probably a safer way of doing things. You could also treat the COM object as a singleton, by locking access to it so that only one request can use it at a time, and you don't have overlapping requests performing multiple concurrent operations. But in any case, you will almost certainly have to handle this yourself, rather than relying on the good graces of the COM object in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or o ~| 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:330266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Running CF as a specific user
Hi Dave, I was hoping you'd jump in, since you always know more about server configuration than the rest of us combined. So just to make sure I'm clear: On Fri, Jan 29, 2010 at 11:42 AM, Dave Watts dwa...@figleaf.com wrote: Full control of those directories is NOT required. In fact, you can run CF as a very limited user. It will need control over its own directories, and at least read/execute over your web content (more if you plan to use CFFILE, etc). So as long as I have the correct permissions on the CF install directory and on the directories containing my content (in and out of the actual web root), I'm good, right? No need to set any permissions on the Windows directories at all? The old KB article also says to give the user full control of the registry key /HKEY_LOCAL_MACHINE/SOFTWARE/. Is that still necessary? Was it ever? -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| 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:330267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Chase Paymentech Orbital Gateway
Has anyone added a shopping cart application on their site that interfaces with Paymentech? We host our own CF site and want to start accepting on-line payments. If so, do you have any recommendations for an easy to use SDK? Or what would be the steps needed to start from scratch? I researched all the shopping cart vendors listed on Chase's authorized Orbital Gateway partners, but didn't find one that mentioned Coldfusion -- all of them seemed geared towards ASP.net. Thanks in advance for any advice. Dawn Sekel dawn.sekel.tcleose.tx.state.us ~| 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:330268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Running CF as a specific user
So as long as I have the correct permissions on the CF install directory and on the directories containing my content (in and out of the actual web root), I'm good, right? No need to set any permissions on the Windows directories at all? If you create a new user account as a member of the Local Users group, it will have Read permissions on the Windows directories. I think CF may need that, but honestly I'm not sure it does. The old KB article also says to give the user full control of the registry key /HKEY_LOCAL_MACHINE/SOFTWARE/. Is that still necessary? Was it ever? If you were (or presumably are) storing Client variables in the Registry, CF needs to be able to write to a subkey within there. My answer to that is, don't store Client variables in the Registry - it's just a bad idea. http://jochem.vandieten.net/2008/04/06/windows-file-permissions-for-the-coldfusion-account/ Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:330269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Running CF as a specific user
Hi Dave, On Fri, Jan 29, 2010 at 12:17 PM, Dave Watts dwa...@figleaf.com wrote: If you were (or presumably are) storing Client variables in the Registry, CF needs to be able to write to a subkey within there. My answer to that is, don't store Client variables in the Registry - it's just a bad idea. Wouldn't think of it. Thanks again for your always-generous help. And thanks for the link to Jochem's blog entry. -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| 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:330270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF9 Solr Security Vulnerability
Hi Folks, Incase you missed it, Adobe just released a security bulletin for CF9: http://www.adobe.com/support/security/bulletins/apsb10-04.html Essentially the CF9 solr service runs on port 8983 on your servers public IP's, instead of just 127.0.0.1, which leaves your solr collections open. The technote to fix it is here: http://kb2.adobe.com/cps/807/cpsid_80719.html I have blogged some more about it here: http://www.petefreitag.com/item/738.cfm Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? ~| 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:330271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF Equivalent of JAVA code.
Hi All, I'm trying to do some work and I have some java examples. For the most part I can easily convert to CF, but I'm not sure how to convert this: If(wb instanceof XSSFWorkbook) file += x; I don't know how to check if wb is an instance of XSSFWorkbook. Wb could be XSSFWorkbook or HSSFWorkbook. Thanks, Steve ~| 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:330272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Need to create an ecrypted zip file
Running CF 7 we are using the zip.cfc to create a dynamic zip file and this works great. We need to then add a password to this. we tried to use the tag cfx_zippassword to add a password and I am getting a wierd error. if you only have one file it works, but if you add more then only the first works but all others give you an error when you try to extract them. Does anyone know a way to do this. ~| 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:330273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Clients Can't Login - IE8 Caching?
Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| 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:330274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CF Equivalent of JAVA code.
At the risk of making several assumptions if(getmetadata(wb).name == 'XSSFWorkbook') file += x; ~Brad Original Message Subject: CF Equivalent of JAVA code. From: DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com Date: Fri, January 29, 2010 12:50 pm To: cf-talk cf-talk@houseoffusion.com Hi All, I'm trying to do some work and I have some java examples. For the most part I can easily convert to CF, but I'm not sure how to convert this: If(wb instanceof XSSFWorkbook) file += x; I don't know how to check if wb is an instance of XSSFWorkbook. Wb could be XSSFWorkbook or HSSFWorkbook. ~| 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:330275 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Equivalent of JAVA code.
Dohh, it wasn't that, but when you did that I decided to cfdump the object. After a little investigation, I found that cfif findNoCase(XSSFWorkbook, Variables.wb1.class.getCanonicalName()) Is the equivalent of what I needed. Thanks for the push in the right direction! -Original Message- From: b...@bradwood.com [mailto:b...@bradwood.com] Sent: Friday, January 29, 2010 2:27 PM To: cf-talk Subject: RE: CF Equivalent of JAVA code. At the risk of making several assumptions if(getmetadata(wb).name == 'XSSFWorkbook') file += x; ~Brad Original Message Subject: CF Equivalent of JAVA code. From: DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com Date: Fri, January 29, 2010 12:50 pm To: cf-talk cf-talk@houseoffusion.com Hi All, I'm trying to do some work and I have some java examples. For the most part I can easily convert to CF, but I'm not sure how to convert this: If(wb instanceof XSSFWorkbook) file += x; I don't know how to check if wb is an instance of XSSFWorkbook. Wb could be XSSFWorkbook or HSSFWorkbook. ~| 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:330276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Equivalent of JAVA code.
You can use the IsInstanceOf() function in CF8+ to do this, but you would need the full package classname of XSSFWorkbook, for example: cfif IsInstanceOf(wb, com.example.XSSFWorkbook) ... /cfif Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Fri, Jan 29, 2010 at 2:26 PM, b...@bradwood.com wrote: At the risk of making several assumptions if(getmetadata(wb).name == 'XSSFWorkbook') file += x; ~Brad Original Message Subject: CF Equivalent of JAVA code. From: DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com Date: Fri, January 29, 2010 12:50 pm To: cf-talk cf-talk@houseoffusion.com Hi All, I'm trying to do some work and I have some java examples. For the most part I can easily convert to CF, but I'm not sure how to convert this: If(wb instanceof XSSFWorkbook) file += x; I don't know how to check if wb is an instance of XSSFWorkbook. Wb could be XSSFWorkbook or HSSFWorkbook. ~| 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:330277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Equivalent of JAVA code.
Definitely good to know. I'm hoping that when I'm done with the changes to a cfc I'm working on it will be backward compatible all the way to CFMX. We have a lot of different versions throughout the company and it would be nice if we had one cfc for all/most of them. Maybe in the future I'll use that for CF8 and after! Thanks, Steve -Original Message- From: Pete Freitag [mailto:pfrei...@gmail.com] Sent: Friday, January 29, 2010 2:49 PM To: cf-talk Subject: Re: CF Equivalent of JAVA code. You can use the IsInstanceOf() function in CF8+ to do this, but you would need the full package classname of XSSFWorkbook, for example: cfif IsInstanceOf(wb, com.example.XSSFWorkbook) ... /cfif Pete Freitag http://foundeo.com/ - ColdFusion Consulting Products http://petefreitag.com/ - My Blog http://hackmycf.com - Is your ColdFusion Server Secure? On Fri, Jan 29, 2010 at 2:26 PM, b...@bradwood.com wrote: At the risk of making several assumptions if(getmetadata(wb).name == 'XSSFWorkbook') file += x; ~Brad Original Message Subject: CF Equivalent of JAVA code. From: DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com Date: Fri, January 29, 2010 12:50 pm To: cf-talk cf-talk@houseoffusion.com Hi All, I'm trying to do some work and I have some java examples. For the most part I can easily convert to CF, but I'm not sure how to convert this: If(wb instanceof XSSFWorkbook) file += x; I don't know how to check if wb is an instance of XSSFWorkbook. Wb could be XSSFWorkbook or HSSFWorkbook. ~| 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:330278 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clients Can't Login - IE8 Caching?
I have had a similar problem with my site recently, could i ask whether you use session variables as the structure for your login process and also whether you have J2EE session variables enabled or just using regular session variables (cookie based) in your CF admin settings. Not sure if your issue is the same and i am also not sure if I have fully solved my issue but the instances have reduced. I am restricted by the hosting company config, they don't allow j2ee session variables and I had an issue with the regular session variables not clearing and users could not login. This can be an issue with cflocation if you have a redirect post vaildating the user credentials and you would also check that you are clearing the session variables upon logout. If you can enable j2ee it should solve the issue or in my case I have a bunch of cfide cookie expiries and structdelete's to clear the CFIDE tokens onSessionEnd in my app.cfc I found these posts useful, may not be your issue but interesting the same: http://www.jensbits.com/2009/07/29/coldfusion-dropping-losing-or-resetting-session-variables-and-cfidcftoken/ http://www.mail-archive.com/cf-talk@houseoffusion.com/msg35466.html Cheers, Bas. On Sat, Jan 30, 2010 at 6:11 AM, Randy Zeitman stonerosedesigndot...@yahoo.com wrote: Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| 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:330279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Clients Can't Login - IE8 Caching?
I have seen some problems with jQuery and IE8 caching. IE8 sees the same URL variables and decides to use the cached page rather than loading the page again. I added a time stamp variable (foo=hhmmss) to my URLs and IE sees the different URL variables and loads the page rather than using the cached version. -Original Message- From: Randy Zeitman [mailto:stonerosedesigndot...@yahoo.com] Sent: Friday, January 29, 2010 2:12 PM To: cf-talk Subject: Clients Can't Login - IE8 Caching? Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| 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:330280 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clients Can't Login - IE8 Caching?
A form post shouldn't be cached, and https URLs shouldn't be cached either. Does your login page perform a form post? Does it use SSL? For the login attempts you say aren't logged in your custom logging solution, do the Web server logs have any record of the form posts? If your Web server is showing hits, then you can bump caching down on the list of possibilities. Inspect the Web log for one of the failed login attempts and compare it to a successful login, The difference between the two could reveal the problem, assuming you are logging detailed information, such as cookie contents. The most common error I have seen that fits these symptoms is that the logout page and the login page are the same page, such as login.cfm?action=logout. People bookmark the logout page, thinking they are bookmarking the login page, and the login logic doesn't account for this possibility. Good luck, Mike Chabot On Fri, Jan 29, 2010 at 2:11 PM, Randy Zeitman stonerosedesigndot...@yahoo.com wrote: Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| 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:330281 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Clients Can't Login - IE8 Caching?
In the past I had issues staying logged in if the url didnât have the www. in it, you could log in but every page would ask you for a login and this was just with setting a reg session, so I forced the www. on the name and it was fine after. I have seen some problems with jQuery and IE8 caching. IE8 sees the same URL variables and decides to use the cached page rather than loading the page again. I added a time stamp variable (foo=hhmmss) to my URLs and IE sees the different URL variables and loads the page rather than using the cached version. -Original Message- From: Randy Zeitman [mailto:stonerosedesigndot...@yahoo.com] Sent: Friday, January 29, 2010 2:12 PM To: cf-talk Subject: Clients Can't Login - IE8 Caching? Sometimes people fail when they login to my site, even with the correct info. As I made my own log of success/fails I saw the attempts weren't even being logged. I had one user delete the temp file cache, in IE8, and it magically worked (and was properly logged...so now the login page actually loaded where before it didn't.). So what happened? Why did the login page not execute and the member automatically went to the failed login page? Is this just an IE thing?... What could I do on my CF side to make sure the login page executes? Thanks (for helping this novice... one day I'll be intermediate). Randy ~| 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:330282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4